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 |
|
vdpramesh
Starting Member
12 Posts |
 Posted - 2004-03-25 : 00:59:41
|
| Hi!I am getting the following error message in visual studio.net 1.1. ver when i am debugging sql server 200 stored proc."Cannot debug stored procedure because the sql server is not setup correctly or the user does not have the permissions to execute the master.sp_sdidebug. Run Sql server setup or contact database administrator "What is the solution for this.? pls help me ...thanks in advanceramesh. |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2004-03-25 : 01:15:01
|
| That makes perfect sense to me.Do you have permissions in the Master database ? If you don't, talk to your DBA.Damian |
 |
|
|
vdpramesh
Starting Member
12 Posts |
Posted - 2004-03-25 : 02:07:44
|
| Hi I am having dbo permission and ofcourse i logged in as a "sa" user. |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2004-03-25 : 07:52:27
|
| Why are you logging in as SA? Why are you using SA in your applications? This is a huge security breach and a great way to have your SQL Server hacked.Create another login and grant it only enough permissions necessary to get the work done, and use that instead. Using SA to log in all the time is playing with fire, and you WILL get burned. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Not able to debug stored proc.