Error Message when trying to setup query with SQL stored procedure

[elainec351]

I am hoping someone can help me with a new issue. I am attempting to setup a query using a SQL stored procedure through the TableAdapter Query Configuration Wizard.

I am getting an error each time I try that states "Failed to retrieve data for this request. An exception occurred while executing a Transact-SQL statement..."

While trying to pin the reason down, I also noticed that I cannot view the stored procedures within the server explorer. I can see the tables, but not the stored procedures.

I am pretty sure the two issues are directly related, but I have no idea how to resolve the problem.

Can anyone point me in the right direction?

Thanks,
Elaine

 

[cjard]

permissions? can you see the sprocs in sql server management studio expresS?

 

[elainec351]

permissions?

Taking the chance of sounding like a complete idiot, but what is sql server management studio express (not Server Explorer, is it).

My connection is using an id that should have permission to see and use the stored procedures.

Sorry I did not mention that I am using SQL Server 2000 for the database, if this is relevant.

Elaine

 

[cjard]

SSMSE is a free product like VB Express, but for developing and managing SQL Servers. You can download it here:

http://www.microsoft.com/downloads/...ae-4bd1-4e3d-94b8-5a0f62bf7796&displaylang=en


I use it to develop complex queries, run and debug tsql, see execution plans and design databases. It goes a little bit further than server explorer in most cases