Hi Brian Kelley,

The article is very informative. I tried the dubugging process in my server, it is sql2000 server which runs under the Win2k OS. When i try to debug the sp it says "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 ? " and if i continues with this it executes and gives the result of the procedure and i can not able to start the debugging process after placing the breakpoint, it just executes the procedure and gives the result of the same . I was not able to use the debug commands (sep in, step out etc.,). What could be the problem. Looking forward for your reply.

Regards,

Lingasamy K