Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
thanksfor help
Posting Yak Master
106 Posts |
 Posted - 2006-01-27 : 17:03:00
|
| Hi, I want to copy all the stored procedure and function of a database in a CD. Any help is appreciated.Thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-01-27 : 17:03:48
|
| Right click on the database in Enterprise Manager, go to All tasks...Generate SQL script. Select your objects then save it to a file. Burn the file to CD.Tara Kizeraka tduggan |
 |
|
|
thanksfor help
Posting Yak Master
106 Posts |
Posted - 2006-01-27 : 17:22:44
|
| Can this be done in SP because there are 150 SP and 100 functions in the Databasethanks |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-01-27 : 17:29:28
|
| Enterprise Manager can do it all at once.Tara Kizeraka tduggan |
|
|
|
thanksfor help
Posting Yak Master
106 Posts |
Posted - 2006-01-27 : 17:48:40
|
| Thanks, I checked, it works fine. |
|
|
|
|
|
|
Copy Stored Procedure