T-SQL Debugger Proglem.

microsoft.public.sqlserver.programming

25 Nov 2005 3:27 PM

vindaloo1

I'm trying to use the T-SQL debugger, but I'm getting this message: "SP
debugging may not work properly if you log on as 'Local System
account."

I'm using SQL Server 2000 and Windows XP Home Edition. Even though I
get this message the debugger will run but I can't step through the
stored procedure.

I tried creating a new user using the Control Panel/New Accounts and
gave the new user administrative rights. Then I added that user in the
SQL Enterprise Manager, and then logged in as that new user. But I
still get the same error message.

Any ideas how to get around this problem?

25 Nov 2005 5:22 PM

marcmc

Check does the sql server agent log in as Local System Account.
You will find it in control panel >> AdminTools >> services >>
SQLSERVERAGENT & MSSQL.

If so try with sa