Hey Guys, Check this out... Scripting SQL Server 2000 Indexes http://www.devx.com/codemag/Article/11516 Cheers, Gaurav
Thanks for giving such a nice article...because I am a new guy for this type of programming and hence i didn't get how to write the stored procedure like how to prepare the stored procedure for usp_GetIndexKeys can any body give some information...how to make that script given in that article please. More over I will be very thankful if somebody gives full script in the form of the source code. Thanks in advance.
The original post was write on april. Now is password protected and suscrition is not free. Luis Martin ...Thus mathematics may be defined as the subject in which we never know what we are talking about, nor whether what we are saying is true. Bertrand Russell
Alternatively, may use Nigel's scripthttp://www.nigelrivett.net/DMOScriptAllDatabases.html to accomplish the task. _________ Satya SKJ Moderator SQL-Server-Performance.Com