SQL Server service where your stored procedures are
located must be running under a Windows NT user account
that has administration privileges to the server.
De* can't run if SQL Server is running under a local
system account. To check the type of account your server
uses, go to Control Panel >> Services >> select the
MSSQLServer service. Click on the Startup button and you
will see Service dialog window. In the Log On As tab,
uncheck the System Account option button and enter the
account username and password in the fields located in the
tab. The username can't be LocalSystem, the account user-
name and password must be for a user.
--Vishal
Quote:>-----Original Message-----
>I'm having some problems using the store procedure
>de*. I have used it in the past and liked it. The
>procedure I am doing follows:
>1. bring up SQL Query analyzer
>2. select stored procedure, right click and select
>debug...
>3. fill in parameters if any, and hit ok/run (whatever it
>is)
>4. The de* then fully runs the code and stops at
>completion of the stored proc. I have no option to set
>breakpoints. then I set breakpoints and select go and it
>does the same thing (runs to completion never stopping at
>the breakpoints).
>Any ideas whats going on? I'm not the dba - are there
>parameters that need to be set?
>Bill
>.
by