Posts
Sort by recent activity
IDENTITY_INSERT
Is there a known issue with comparing data between tables where the primary key is the identity? The generated script failed to cope with this:
Cannot insert explicit value for identity column in ...
COLLATE problem between SQL 7 and SQL 2000 databases
I am comparing two databases, one on SQL 7 and one on SQL 2000. They contain a table which is indexed on a varchar(8) field. SQL Compare shows that the table on SQL 2000 differs from the one on S...
SQL Server Error: [8525] Distributed transaction completed.
I'm getting this error when synchronising a stored procedure that joins to a table on a linked server (sorry about the subject matter):
The following error message was returned from the SQL Server:...