I am running one existing complex store procedure and in some cases i couldnot find wrong results .I want to debug the procedure.But as data is large i could not debug store procedure.I used print statements as well.
What I have tried:
1. i used PRINT STATEMENT
2. I used some Temp tables as well
3. I tried debugging but it fails as large data and hangs stored procedure .
4. Also I tried in some extent SQL Server Profiler but even then I Couldn't find error.
Will anyone tell me best way with handling performance and perfect way to debug Stored Procedure