[posted and mailed, please reply in news]
M1st3rK3n (mi*******@yahoo.com) writes:
I'm using the Transact-SQL Debugger for the first time here.
I go to Object Browser, find my stored procedure, right click and
choose "Debug".
The "Debug Procedure" window comes up, and I click on the Execute
button.
The Debug environment comes up and automatically executes my
procedure. It doesn't allow me to single step through the code.
What am I missing here?
All of the "step" buttons, "restart", and "stop debugging" buttons
are dimmed out.
The most likely reason is that the SQL Server is running under the
local system account. It should be running on a domain account. On
the SQL Server machine, right click My Computer, choose Manager.
Find Services, and the find the MSSQL Server services. (There is one
per instance.) Right-click the service, select Properites and on the
second tab is log on.
You may also have problems if SQL Server is running SP3, but your
Query Analyzer is SP2.
--
Erland Sommarskog, SQL Server MVP,
so****@algonet.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp