Posts
Sort by recent activity
Query processor could not produce a query plan because of the hints defined in this query.
I am getting this error when running dynamic sql with the forceseek query hint.
Moving columns without using migration scripts
What is the best way to move a column and preserver data without using migration scripts?
Deploying extended properties to Azure and the sql generated is raising an error
Error raised is To deploy sensitivity classification information to this platform, the ADD SENSITIVITY CLASSIFICATION syntax should be used.
SQL Compare latest production version not comparing encrypted stored procedures in Azure SQL DB
This comparison works fine in SQL Server 2016/17.
Moving a column from one table to another
I have the latest SQL Source control and DML components and am trying to move a column with data from one table to another. I have tried doing this using the following steps.
1. Add new column to t...
Problems comparing Source control versions
Since upgrading to the latest SQL Compare 12, I can no longer comparing one release in SVN to another release in SVN. We do this to create version upgrade scripts. SQL Compare is now stating 'Getti...