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 |
|
mafeltz
Starting Member
7 Posts |
 Posted - 2009-07-09 : 12:18:16
|
| Hi, i have a database on server 'A' and have a development copy on server 'B'. on server 'A' i have 30 stored_procedures associated with the db and am trying to user the script generator to move them over to server 'B'. problem is that when i run the generate script wizard, no stored procedures show up to be scripted. I am at a loss. At help would be appreciated. |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2009-07-09 : 14:36:26
|
| Hmmm... that's weird. I've generated tons of scripts out of SQL 2000. Here's how I do it:Open Enterprise Manager and right-click on the database. Go to All Tasks..., Generate SQL Script. Then in the box that shows up, the first thing you have to do is click on the Show All button. Once you have done that, then you can click on the All Stored Procedures checkbox which automatically puts them all in the Objects to be Scripted box. Then pick your formattting and options and away you go.Does that work for you?--------------------------------------------Brand yourself at EmeraldCityDomains.com |
 |
|
|
mafeltz
Starting Member
7 Posts |
Posted - 2009-07-09 : 14:41:30
|
| Thanks, That does work but does not export/show system stored procedures, only user stored procedures. Just noticed that difference. So i assume i cannot export system stored procedures? |
|
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2009-07-09 : 15:28:04
|
| I can't think of a reason you would need or want to. Doesn't your server B have its own system stored procedures? The best way to be sure they are the same is to make sure you have the same version installed on both servers.--------------------------------------------Brand yourself at EmeraldCityDomains.com |
|
|
|
mafeltz
Starting Member
7 Posts |
Posted - 2009-07-15 : 10:18:02
|
| the system stored procedures are not on server 'b' but i have not checked the versions. i'll have to take a look at that and see if that may be the issue. Thanks. |
|
|
|
|
|
|
Stored Procedures not being exported