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 |
|
coolerbob
Aged Yak Warrior
841 Posts |
 Posted - 2005-04-20 : 10:18:43
|
| When I try and get enterprise manager (2000) to create a db script it works fine as long as I dont tell it to script the Sp's as well. I heard somewhere that this sometimes happens if you have encryption code in one of your SP's; but this is not the case on this occasion.Does anyone have any other ideas? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-04-20 : 16:05:27
|
| So what isn't working though when you try to script the sprocs? You didn't provide an error message.Tara |
 |
|
|
pentiumsingh
Starting Member
9 Posts |
Posted - 2005-04-20 : 22:07:18
|
| Can u please elaborate, giving proper error u recieved and the sp you have used in the scriptPentiumsingh |
|
|
|
coolerbob
Aged Yak Warrior
841 Posts |
Posted - 2005-04-21 : 04:12:44
|
| Error Window caption: Scripting ErrorMessage: An error occurred during scripting.Error 21305: [SQL-DMO]Unexpected parameter value or other condition. |
|
|
|
|
|
|
SP causing DB script failure