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 |
|
sqlMan99
Starting Member
1 Post |
 Posted - 2007-07-10 : 09:22:42
|
| Hi I'm still new to sql2005 and I wanted to copy over a database to another machine along with the stored procedures but when I do an Import using SSIS import/export wizard I only get the database and not the stored procedures. Anyone know how I can also get the stored procedures? |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-07-10 : 09:30:34
|
| If you do Backup and Restore it will bring everything - Tables, Indexes, Data, Sprocs, the lot.If you just want Sprocs than use Generate SQL Script to create a script of all the things you want - that can be everything EXCEPT data.Kristen |
 |
|
|
|
|
|
How do I bring over Stored Procedures