Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
 Posted - 2009-01-06 : 06:13:05
|
| can anyone give me a link to something to show me how to debug stored procedures?is there a way to put an alert or something to see why values I think should happen are not happening |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2009-01-06 : 08:16:46
|
| Here is a link about debugging using Visual Studio. http://www.sqlteam.com/article/debugging-stored-procedures-in-visual-studio-2005SQL 2008 has debugging capabilities built into SSMS.Usually, I find the debugging tools for SQL queries less useful than, for example for C# programs. This is partly because the debugging tools are not as advanced, and partly because of the nature of the SQL queries which are mostly set-based queries that do not lend themselves to stepping through line by line. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-06 : 08:26:38
|
| you can use PRINT or SELECT to display intermediate values in procedures for debugging. |
|
|
|
|
|
|
how to debug stored prodcedures