I am totally stumped. In SQL Server 2000, I would fire up my EM and right-click on multiple SPs and then Generate Scripts. I then would start QA and run the script on a different DB. This was a very convenient feature to copy SPs over from one DB to other as well as from one machine to other. I can’t seem to do the same in SQL Management Studio. Is it possible? If yes, how?
You do have the option to have SQL Server Generate SQL Script, There are a couple of option like, script to drop object, script to add object as well as an output option to put sql script to query analyser or output it to clip boad.
mom
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply