Home Forums SQL Server 2008 T-SQL (SS2K8) Proc giving error in one sesison and runs in another RE: Proc giving error in one sesison and runs in another

  • I faced a similar issue a while back. In my case there was a dynamic SQL block in the proc which was creating problems due to creation temp tables.

    One way to isolate the problem is that you comment the code in proc and keep un-commenting line by line until you reach the point of error. If the proc is too large then do the same activity in code blocks instead of each line.