problem executing stored procedures

[slames]

Hi, I hope someone here will be able to shed some light on a problem I'm having. When I try to open a form based on a stored procedure, it errors and closes, and when I want to go to the design view of a stored procedure nothing shows.
I think the problem is related to the fact that all stored procedures when viewed in the database window are followed by ;1 I have seen this before somewhere but just can't remember what the problem was. I've searched everywhere for an answer but can't find one.

Can anyone please please help as we can't use our database at the moment.

Thanks in advance

 

[SQLSister]

THis looks like a front end problem to me. I would post in the forum for the front end what ever that is. If you want to check the sp's directly open QUery Analyzer using the same login that your application would be using and then try to run the stored procedure.

Questions about posting. See faq183-874

 

[ClayG]

;1" is a sequence number for stored procedures, 1 is the default. If the calling statement is "exec xxxx" then it will execute procedure "xxxx;1". Note that if there is a procedure "xxxx;2" it will NOT be executed by "exec xxxx"; it could only be executed explicitly by "exec xxxx;2".

";1" is the default, so long as you dont have any ";2" in the database, the numbering is not an issue.

 

[slames]

I have now discovered the answer to my query - the knowledge base article relating to it is here:

http://support.microsoft.com/kb/269824/EN-US/

Thanks for your input anyway.