Posts
Sort by recent activity
Detection of Logins should use SUSER_ID
The code generated to test for an existing SQL login is thisIF NOT EXISTS (SELECT * FROM master.dbo.syslogins WHERE loginname = N'xxx')
CREATE LOGIN [xxx] WITH PASSWORD = 'p@ssw0rd'...
SQL Compare does not detect disabled indexes
Hi
tl;dr: SQL Compare does not detect disabled indexes
More...
I was playing with a bulk load script for test data.
In this, I disable constraints (CHECK and FK) and triggers.
However I wanted to d...
Filtered index syntax error: WHERE and WITH clauses swapped
SQL Data Compare 10.2.3.5 (and earlier) generates incorrect syntax for restoring filtered indexes that have a FILLFACTOR clause
The WHERE and WITH clauses are the wrong way around
What is generated...
Feature request: "Compare to folder"
Like the SQL Server Compare tools
This allows schema changes to be checked into local SVN folder or such.
This would also require a scripts per object too.
Thanks
Shawn