1. Use SQL Profiler/Trace. This helps you localize the bottlenecks
and identify poorly running queries
2. Check Execution Plans. Enables you to fine tune the queries and
statements within your stored procedure and refine your logic
3. Cut-and-paste the SP code into the Query Analyzer and do the
4. Insert PRINT statements in the SP to check if the intermediate
queries/statements are working OK
5. Browse the web and buy some 3rd Party tool for SP Debugging
Quote:> Hi can some one tell me how to debug the stored procedure
> I am using sql 2000 client version. to debug the stored procedure i have
> to have the server version or client version is ok. actually i am enable
> to change start up service account in server property thanks...
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!