Comments
Sort by recent activity
Hello!
I have run into a similar problem (and I am on version 7.0.0.62) where the SQL Prompt complains: "... column could not be resolved as a column with that name exists in multiple tables...". Below is my query (slightly revised to protect the innocent):
UPDATE TableA
SET Column1 = ( SELECT Column1
FROM TableB
)
WHERE Column1 IS NULL
AND MyType = 'A'; / comments
Hello!
I have run into a similar problem (and I am on version 7.0.0.62) where the SQL Prompt complains: "... column could not be resolved as a column with that name exists in multiple tables...". ...
Upgrading to the latest version (7.3.0.775) solved this problem for me. / comments
Upgrading to the latest version (7.3.0.775) solved this problem for me.
I have just installed the latest version of SQL Doc (3.0.3.9). It looks like the tool does not understand clustered columnstore indexes in SQL Server 2014. When trying to view any table with such index I get "Preview cannot be displayed. An exception has occurred while trying to display the preview. The error message is: Specified argument was out of range of valid values" / comments
I have just installed the latest version of SQL Doc (3.0.3.9). It looks like the tool does not understand clustered columnstore indexes in SQL Server 2014. When trying to view any table with such...
Thank you, Brian! This is very helpful and good to know. I ended up going with a different approach. I specify output of sqlcompare to be an Excel file and then programmatically open this Excel and save it as CSV (because Excel is notoriously hard to work with in SSIS). From then on it's pretty easy to load into a database table using SSIS flat file connection manager. / comments
Thank you, Brian! This is very helpful and good to know. I ended up going with a different approach. I specify output of sqlcompare to be an Excel file and then programmatically open this Excel ...
Thank you, Brian! I hope this is correct, but just want to confirm. Please go to this URL: http://www.red-gate.com/supportcenter/c ... _in_the_cl
Scroll to the bottom and view this text (pasted below):
Deprecated Options /Sourcecontrol1
Allows a folder of scripts to be used as the source.
/Sourcecontrol2
Allows a folder of scripts to be used as the target. / comments
Thank you, Brian! I hope this is correct, but just want to confirm. Please go to this URL: http://www.red-gate.com/supportcenter/c ... _in_the_cl
Scroll to the bottom and view this text (pasted b...
I am experiencing very similar slowness with SQL Prompt and I am still running a trial version. This started happenning just a few days ago, it was working well initially. / comments
I am experiencing very similar slowness with SQL Prompt and I am still running a trial version. This started happenning just a few days ago, it was working well initially.