Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Exporting stored procedures to txt files 1
- Thread starter James1981
- Start date
-
1
- #2
Hi,
U can script out all ur SP's from Enterprise manager, just select the DB u want to script out then right click and select "All Tasks" then select "Generate SQL Scripts" and then click "show all" button on the window that comes up, Select stored procedures then go to the 3rd Tab and Select windows ANSI and click ok... it will ask for a file name, this file file created will .SQL file, but basically a text file u can open it with note pad.
Hope it helps
Sunil
U can script out all ur SP's from Enterprise manager, just select the DB u want to script out then right click and select "All Tasks" then select "Generate SQL Scripts" and then click "show all" button on the window that comes up, Select stored procedures then go to the 3rd Tab and Select windows ANSI and click ok... it will ask for a file name, this file file created will .SQL file, but basically a text file u can open it with note pad.
Hope it helps
Sunil
DBAWinnipeg
Programmer
Is there anyways to schedule this scripting to happen nightly through a scheduled job?
Thanks in advance!!!
Colin in da 'Peg
Thanks in advance!!!
Colin in da 'Peg
- Status
Similar threads
- Question