Help with SQL 2000 Debugger

I installed the SQL 2000 trial as a local server on a standalone XP Pro system. When use the debugger, it executes the stored procedure without allowing me to step into the code.

Any help would be greatly appreciated.

Check in the help topic in SQL Server Books Online titled: Troubleshooting the Transact-SQL Debugger

You can experience the problems you are having when the DCOM settings aren't configured correctly.

-Sue

|||

Sue, thanks for responding. Yes I've gone thru the DCOM settings and made sure EVERYONE was there and set to allow, SYSTEM is also there and set to allow. The identy for sqldbreg is set at interactive like described in the Troubleshooting the Transact-SQL Debugger section of the books online. You should know that I'm not a windows op sys expert. I think it has something to do with the Windows Services Account is the Local System Account. All the Services Account stuff is well beyond my knowledge or experience and I don't know if since my system is XP Pro wether I can even setup a Domain User Account?

Any more help would be appreciated.

|||Sue, I just figured it out. I had to change the MSSQLSERVER properties logon to logon using a User Account versus the Local System.|||

Can you please tell me where do I go to set MSSQLServer properties logon? Should I be a SysAdmin/DBA and have access to the server box.

Thank you.

|||

In SQL Server 2000, use Enterprise Manager to change the service accounts. Right click on the server and select properties. Then go to the Security tab.

In SQL Server 2005, you would use Configuration Manager to change the service accounts.

-Sue