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 |
|
will91
Starting Member
6 Posts |
 Posted - 2003-11-06 : 11:07:52
|
| On some of the computer the name of my stored proc change, it add ";1" or ";0" and it's impossible to open those, it say that it's impossible to find the stored procedure 'dbo.the_name;1'. |
|
|
JustinBigelow
SQL Gigolo
1157 Posts |
Posted - 2003-11-06 : 11:27:32
|
| What do you mean by "open"? Do you mean execute or sp_helptext? The ;1 ;2 .... is for grouping procedures with the same name for the purpose of dropping them. However you can execute a procedure with a trailing ;1 but a trailing ;0 will net you the following error.Line 1: Invalid procedure number (0). Must be between 1 and 32767.Justin"I want to thank you. You could've given us help, but you've given us so much more." |
 |
|
|
will91
Starting Member
6 Posts |
Posted - 2003-11-06 : 11:37:18
|
| I mean execute, sorry for my bad english. Why that on my computer there's no ';1' or ';0'? And how can I make the others execute? |
|
|
|
JustinBigelow
SQL Gigolo
1157 Posts |
Posted - 2003-11-06 : 12:21:33
|
| What is the exact error message of that you get when you try and execute the procedure with the trailing ;1?Can you execute it without the ;1?Is it possibly a permission issue?Justin"I want to thank you. You could've given us help, but you've given us so much more." |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-11-06 : 13:26:23
|
| Please do not cross post:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=30373 |
|
|
|
|
|
|
Problem with stored proc