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 |
|
Swati Jain
Posting Yak Master
139 Posts |
 Posted - 2007-08-07 : 04:33:05
|
| Hello All, I tried to set the access permissions for debugging stored procedure by reading the articlehttp://msdn2.microsoft.com/en-us/library/w1bhybwz(VS.80).aspxandhttp://technet.microsoft.com/en-us/library/ms164014.aspxI have tried to add the role to sysaminas follows1)SELECT * FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_NAME = 'sp_sdidebug'(to find the sp)Error:--The stored procedure not found2)sp_addsrvrolemember 'Development\swati.jain', 'sysadmin' though this is executed successfuly . Error is still persisting Cannot debug stored procedures because the SQL Server database is not setup correctly or user does not have permission to execute master.sp_sdidebug.how to correct this?sp_addsrvrolemember 'ASPNET\swati.jain', 'sysadmin'I got the error'ASPNET/swati.jain' is not a valid login or you do not have permission. |
|
|
chrisrock
Starting Member
12 Posts |
Posted - 2007-08-09 : 22:05:05
|
| What version of sql server are you using? Sql 2000? 2005? Standard? Developer? |
 |
|
|
Swati Jain
Posting Yak Master
139 Posts |
Posted - 2007-08-10 : 01:20:47
|
quote:
Originally posted by chrisrock
What version of sql server are you using? Sql 2000? 2005? Standard? Developer?
Hi,I am using SQL2005 with following detailsMicrosoft SQL Server Management Studio Express 9.00.2047.00Microsoft Data Access Components (MDAC) 2000.086.1830.00 (srv03_sp1_rtm.050324-1447)Microsoft MSXML 2.6 3.0 4.0 6.0 Microsoft Internet Explorer 7.0.5730.11Microsoft .NET Framework 2.0.50727.42Operating System 5.2.3790 |
|
|
|
|
|
|
'sp_sdidebug'