December 29, 2006 at 3:52 pm
I have a SQL 2000 DTS package that utilizes scptxfr.exe. I use this executable to script all indexes prior to deleting them for a new data import. Once the new data is imported, the package then executes the scripts to re-apply the indexes.
I am now trying to import this package into SQL 2005 and have found that scptxfr.exe is not available in the SQL 2005 install. I have tried moving the scptxfr.exe utility to the server and running it through the package, but the task just hangs and no script files are produced.
Does anyone know of an equivalent to this? I basically just need something that will script existing indexes to a file....maybe a stored procedure?
December 30, 2006 at 9:02 am
the script located here
http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=1541
would give you a good starting point
it was designed to move indexes from one filegroup to another, but it could easily be modified to create a file or table with the create index commands - run it in QA with the debug flag set to 1 and it will print a list of commands it would have run
MVDBA
January 2, 2007 at 1:33 pm
Thank you so much. I will give this a try.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply