Apr 23, 2009 #1 hapax Programmer Joined Nov 10, 2006 Messages 105 Location 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 Joined Oct 30, 2001 Messages 1,540 Location 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 Joined May 21, 2007 Messages 3,150 Location US You can in SQL Server 2008 or from Visual Studio. Upvote 0 Downvote