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:44:42
|
| On some of the computer the name of my stored proc change in my access project, it add ";1" or ";0" and it's impossible to execute those, it say that it's impossible to find the stored procedure 'dbo.the_name;1'. What can I do? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-11-06 : 12:28:15
|
| ;1 and ;0 is just the revision number, kind of like history in VSS. I can't remember how they work, but they all fall under dbo.the_name as the parent name, in your example at least. To see what you've got, you could take a look at sysobjects where type = 'P'. See which stored procedure names come up in the list.Tara |
 |
|
|
will91
Starting Member
6 Posts |
Posted - 2003-11-06 : 13:18:07
|
| Where's sysobjects? I'm not able to create a new stored procedure it say the same thing that when I try to execute one alresdy create. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-11-06 : 13:27:09
|
| sysobjects is a system table found in every database. This table will show you which objects you have in a database. If you put WHERE type = 'P' in your SELECT statement, it will return the stored procedure names.Why not use ALTER PROC instead of CREATE PROC if you just want to modify the stored procedure?Tara |
|
|
|
will91
Starting Member
6 Posts |
Posted - 2003-11-06 : 13:36:10
|
| It's in access project, I'm not able to go in creation. I can do notting with those stored procedure. It always say that they "can't find the stored procedure" |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-11-06 : 13:37:22
|
| This forum is for SQL Server. Please post your Access questions here:[url]http://www.sqlteam.com/forums/forum.asp?FORUM_ID=3[/url]Tara |
|
|
|
|
|
|
Problem with stored procedure on some computer