Comments
Sort by recent activity
Also, what's the count(*) from sysobjects for your database(s) / comments
Also, what's the count(*) from sysobjects for your database(s)
Does this happen often? Is Counter in multiple tables in this query? Do you know what might be on the right side? / comments
Does this happen often? Is Counter in multiple tables in this query? Do you know what might be on the right side?
In VS, do you have the SQL Prompt menu and suggestions enabled?
[image]
/ comments
In VS, do you have the SQL Prompt menu and suggestions enabled?
Glad to hear it. Hope you don't find any more new issues. / comments
Glad to hear it. Hope you don't find any more new issues.
You can get some versions here: https://www.red-gate.com/products/old-versions
If you want to get a specific one, then let me know and I'll chase it down.
/ comments
You can get some versions here: https://www.red-gate.com/products/old-versions
If you want to get a specific one, then let me know and I'll chase it down.
Is this working for you? Which SSMS version do you have that caused issues with v9? / comments
Is this working for you? Which SSMS version do you have that caused issues with v9?
Confirmed. Comments are misaligned. / comments
Confirmed. Comments are misaligned.
A database snapshot or a SQL Compare snapshot? / comments
A database snapshot or a SQL Compare snapshot?
This would not be a DLM function, but just a T-SQL call. You could use a SQLCMD step in your build/release tool, or a PoSh step, and call the CREATE DATABASE AS SNAPSHOT OF command. / comments
This would not be a DLM function, but just a T-SQL call. You could use a SQLCMD step in your build/release tool, or a PoSh step, and call the CREATE DATABASE AS SNAPSHOT OF command.
OK, I need more information about what you did. I created a new SCA project and deployed it to a database. This worked fine with the SCA build and release tasks (v3) for the table. I then added a new column, as you did, and deployed it. That worked. Next, I added an index on the target, then added another new column on the dev side and deployed it. This also succeeded, even though there was drift on this table. Could you have otherwise altered this table (my_table), between deployments? I'm wondering what drift check you're catching. If you run a SQL Compare from the dev db to the prod one (or target), what comes back? / comments
OK, I need more information about what you did. I created a new SCA project and deployed it to a database. This worked fine with the SCA build and release tasks (v3) for the table. I then added a n...