Stored procedure Debug in .Net 2003

  • Thread starter Thread starter Dneupane
  • Start date Start date
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
 
Back
Top