I have to write a sql script for comparing the difference's with the indexes of table of SQL Server.
A:
Hi Huzaifa - if all you want is the structure you can generate the scripts using this procedure.
You can then compare the files between the two databases.
Jayoaichen
2010-08-18 16:26:56
A:
sys.indexes holds all the information about the indexes on a given database.
Huzaifa
2010-08-19 09:09:50