Posts
Sort by recent activity
problems registering servers using sql authentication
We use sql authentication with sql 2000 databases. I can remote desktop to a server using either the name or IP address to find a server. I can also use query analyzer with either the servername ...
single table compare from command line
I am having trouble comparing 1 single table from the command lineSQLCompare.exe /verbose /server1:HENRY /server2:HENRY
/username1:XX /username2:XX /database1:D11 /database2:RETAILDEV
/include:...
Different schemas - Compare aborts on first duplicate table
I have a database with 16,000 tables with 15,000 owned by dbo and 1,000 owned by an individual. 2 things:
1) Tablenames are identical between the two, only the owner differs.
2) SQL compare aborts...