November 7, 2005 at 9:59 am
I choose a procedure, right click and choose debug.
I recieve the following error:
SP Debugging may not work properly if you log on as 'Local System Account'
while SQL Server is configured to run as a service. You can open Event viwer
to see details.
Do you wish to continue?
I click ok and then am prompted for the procedure's variable values which
I assign. I then try to debug through but all the program allows me to do
is run the procedure. I'm very new to SQL Server and would appreciate articles
or advice anyone can shed on using query analyzer to debug or any other tool
that may be out there.
Thank you very much
November 8, 2005 at 3:41 pm
Did you grant exec privledges on master.dbo.sp_sdidebug to the login attempting to do the debugging?
Be warned that using the T-SQL debugger will cause major blocking issues. It's a common practice to not use this debugger.
A.J.
DBA with an attitude
November 8, 2005 at 8:47 pm
There're a lot of threads on this site for this topic...
Here're a few that a quick search unearthed - maybe one of them will help you..
**ASCII stupid question, get a stupid ANSI !!!**
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply