SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Cannot use parameters with stored procedures
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

SidKnee
Starting Member

2 Posts

Posted - 05/05/2011 :  11:06:00  Show Profile  Reply with Quote
Hi

Hope I'm posting to correct forum. The problem has arisen as part of development but I think it's a database server/permission issue.

I have a database that is working fine. I can RDP to the server and run Enterprise Manager as dbo. I can create a stored procedure within this database fine. I can then launch Query Analyzer and view and open the stored procedure. However, if the stored procedure specifies parameters, they do not appear in the parameters list in the Execute Procedure window and I'm unable to set values. Naturally executing the procedure causes an "expects parameter" error. Also, when navigating the stored procedures for this database in the object browser in query analyzer, expanding the parameters folder for any procedure is empty. This is the same for any of the procedures created in this database including those added after using the diagram features e.g. dbo.dt_adduserobject. Therefore, I'm pretty confident that its not a syntax issue.

If I create a stored procedure which doesn't take any parameters, it works fine. I've confirmed that all tables are owned by dbo, I'm connecting as dbo which has full permissions.

Other databases on the server work fine and I can create and execute stored procedures with parameters fine.

Any help greatly appreciated.

Steven

russell
Pyro-ma-ni-yak

USA
5071 Posts

Posted - 05/05/2011 :  11:41:02  Show Profile  Visit russell's Homepage  Reply with Quote
It should open a window listing paramaters where you can key in the value(s).

But, why not just execute it in Query Analyzer?
Go to Top of Page

SidKnee
Starting Member

2 Posts

Posted - 05/05/2011 :  12:02:55  Show Profile  Reply with Quote
It does open the Execute Procedure window where I expect to see the parameters listed and should be able to enter values but the parameters are not appearing in the list so I cannot enter values.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000