Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
bogey
Posting Yak Master
166 Posts |
 Posted - 2006-10-24 : 09:23:50
|
| Trying to debug a stored proc that resides on our dev sql server 2005 machine. I'm running VS2003.The error message is:Cannot debug stored procedures because the SQL Server databas is not setup correctly or user does not have permission to execute master.sp_sdidebug. Run SQL Server setup or contact database administrator. |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
bogey
Posting Yak Master
166 Posts |
Posted - 2006-10-24 : 11:19:16
|
| In the old days (sql server 2000) debugging stored procedures was built into the EM. Now, you must use the management studio OR I'm using TOAD for sql server and MGMT Studio. I get this error."Cannot debug stored procedures because the SQL Server database is not setup correctly or user does not have permission to execute master.sp_sdidebug. Run SQL Server setup or contact database administrator." |
 |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
bogey
Posting Yak Master
166 Posts |
Posted - 2006-10-24 : 12:41:49
|
quote:
Originally posted by X002548
I understand. I can't help you with that, but what is the error you are trying to debug. Maybe we can fix that.
There is no error. I just need to debug some proc's to see the logic that is being used. If anyone has this setup and working correctly let me know. Thanks for answering back X002548 :) |
|
|
|
|
|
|
Debugging SP's with SQL Server 2005