Devart Studio for SQL Server Issues

I am documenting known issues I have run into with Devarts’ Studio for SQL Server here. I want to state up front that this is an exception program with a TON of cool features and functionality. It IS my main tool at work for doing all deployments and resolving issues. I would absolutely recommend this application to any production or development DBA.

I am currently running version 5.0.337.

ISO Encoding Issue

I recent deploy a script for our marketing team where they had a few thousand INSERT statements for content for our websites that are multi-lingual. I usually just double-click the file in the folder and launch DSSS that way, but unfortunately it defaults to code page 1252 (as shown below). If you select the file first (very important!) then change the encoding option, the file will open with the correct encoding and the editor will not replace the encoded characters with garbage.

DSS Open File Dialog
DSS Open File Dialog

Encoding Selection Options
Encoding Selection Options

Query Result Row Counts

Recently I had a query to run at work where the results displayed in the panel below the query editor did not reflect the complete result-set of the query (the query had indeed completed). The panel displayed “1 of 439” rows when in fact if you scroll down the see the bottom of the result-set, it then updated to the 1911 rows expected.

Views – 1969