Stored procedure Debug in .Net 2003

D

Dneupane

Hi all
I am trying to debug a stored procedure using VS.Net 2003. I get this
message
"Cannot debug stored procedures because the SQL server database is not
setup correctly or user doesn't have permission to execute
master.sp_sdidebug."

Database server is running on Win3K
Database SQL 2000
Client desktop: Win XP pro sp1

I am logged in as Administrator

This problem only exists when I the debug stored procedure on remote
(SQL 2000 running on Win3K machine) database server. However I can
debug stored procedure on local database (SQL 2000) that is running on
XP pro sp1.

Any help would be greatly appreciated.

Thanks

Dipendra
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unable to debug SQL from within the .NET IDE 3
Call stored procedure in SSMS from Access 2016 doesn't work. 0
Unable to view system stored procedures from .NET IDE and unable to debug SQL 2
Invalid Column Name Sql-Error :Executing a stored procedure 1
Setting a breakpoint in sql server 2000 stored procedure from VS2005 7
SQL Update/Insert using SqlDataAdapter and Stored Procedure 1
cannot debug stored procedure msg - db not setip or permission prob ? 2
Creating Stored Procedure 5

Top