My installed sql server 2000 is configured as mixed mode authentication & blank password & local user account.
I create a store procedure.But when i debug this procedure, i go to some step i.e.- right click on that procedure+click debug option. A windows is shown i.e.-'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 to see details.
Do you wish to continue?'.There have three button-Yes,No Cancel. I click yes button.
I give some parameter value and then click execute button.
A debugging windows is shown, Go,Toggle Breakpoints & Remove all Breakpoints button are enable but step into, step over, step out & run into cursor are disable.
how will i solve to debug that procedure???
Please help me any instruction...