Apr 23, 2009 #1 hapax Programmer Nov 10, 2006 105 US I'm a junior web developer. I need tips on how to troubleshoot stored procedures. As far as I know, you can't step through the execution of a stored proc, the way you could C# or VB code.
I'm a junior web developer. I need tips on how to troubleshoot stored procedures. As far as I know, you can't step through the execution of a stored proc, the way you could C# or VB code.
Apr 23, 2009 1 #2 hmckillop Programmer Oct 30, 2001 1,540 GB You can debug a stored procedure have a look at http://www.4guysfromrolla.com/articles/051607-1.aspx Alternatively some people like to use print statements or SELECT statements to return bit parts of the proc as and when it runs to see whats going on. "I'm living so far beyond my income that we may almost be said to be living apart Upvote 0 Downvote
You can debug a stored procedure have a look at http://www.4guysfromrolla.com/articles/051607-1.aspx Alternatively some people like to use print statements or SELECT statements to return bit parts of the proc as and when it runs to see whats going on. "I'm living so far beyond my income that we may almost be said to be living apart
Apr 23, 2009 #3 markros Programmer May 21, 2007 3,150 US You can in SQL Server 2008 or from Visual Studio. Upvote 0 Downvote