Hello Ken > Instead of dropping the scripts on the destination server, why no use ALTER > PROC instead. You can have the SQL Server 2000 Query Analyser create the > ALTER scripts for you (and it seems to keep most of the formatting, some > spaces/tabs seem to get switched around, but that's it)
I am able to run the a script with stored procedures and triggers on the remote server, enabling me to re-create or update the existing procedures transfered using Object Transfer from the MMC. How come the formatting goes out of the window?! Perhaps SQL Server sees the extra spaces as "not necessary" when object transfering and strips them out? Thanks in advance Anders Borum --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
