Known issues and limitations

A warning message is displayed by SSMS after the extension has been copied to the extensions folder.

This is due to the internal extension validation that is performed by SSMS every time it starts. SSMS only loads extensions that are white listed by the SSMS team at Microsoft and rejects everything else. There is a way to work around this but unfortunately it leaves the user with a warning message that he needs to select “No” to. Selecting “No” tells SSMS to skip the validation for this particular extension the next time it starts up. The extension itself won’t be loaded when SSMS starts but the flag to skip its validation will be set in the registry. The next time SSMS starts the validation will be skipped and the extension will load properly.

---

The extension pastes the column header along with the copied data when pasting text values.

Even though the extension handles data that is copied with the column header, this doesn’t work when the data is any kind of text. If the data consists of unique identifiers or any kind of numbers then the extension can detect the string header and remove it when pasting. If the data consists of strings and they are copied with the header, the extension can’t distinguish the header from the rest of the values and the header will be pasted along with them. To avoid this, select “Copy” instead of “Copy with Headers” when copying strings from the Results window.