Brackets causing problems
Using SQL Server Management Studio (SSMS) 2005 I extracted the DDL for all objects, users, roles, etc. in one of my SQL Server 2000 production databases. To verify this extraction, I then created a blank database on another SQL 2000 server and ran the SQL script. I then compared the two databases using SQL Compare. Apparently SSMS places brackets around object owner names and table names, and SQL Compare does not because it showed a lot of differences between objects just because of the brackets. When I extracted the DDL using SQL Server Enterprise Manager 2000 and ran the same comparison, things worked as I expected.
0 · Share on Twitter