September 2, 2005 at 2:45 am
Hi, i want to make a copy of all my stored procedures of a database and restore them to other sqlserver. Its possible? any help plz?
September 2, 2005 at 3:20 am
Use Enterprise Manager to generate a script for them, and then run that script against the other server.
September 2, 2005 at 3:33 am
In Enterprise Manger select all stored procedures and choose All Tasks->Generate SQL Script in context menu. It'll generate SQL-script to text file. Run this script on the destanation server.
Also if you have great amount of stored procedures you can retreive their source-code from syscomments table. (I haven't tried it)
September 2, 2005 at 5:09 am
Many thanks its done
September 2, 2005 at 5:35 am
OR you could use the import/export wizard OR SQL Copy task in DTS, OR....
Good Hunting!
AJ Ahrens
webmaster@kritter.net
September 6, 2005 at 1:27 pm
You've gotta love 'cowboy' environments ... no one seemed to think about going to their 'source code control system' for the stored procedures ...
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply