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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Debugging Stored Procedures

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-01-06 : 08:37:47
Martin writes "I am trying to use the Debug facility from the SQL Query Analyzer.

I get the error 'Debug might not work when logged on as 'Local System Account''

If I look in the Event viewer I get 'SQL must no log on as System account'

The debug than runs but does not give you the ability to stop and step through the code.

I have seen this wotking at home but cannot figure out what permissions are needed to to make this work.

Any help would be gratefully appreciated.

Martin"

SqlStar
Posting Yak Master

121 Posts

Posted - 2005-01-06 : 08:43:43
Hi,

Try to give local administrator rights to that user.

:) While we stop to think, we often miss our opportunity :)
Go to Top of Page
   

- Advertisement -