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 |
|
mahesh_bote
Constraint Violating Yak Guru
298 Posts |
 Posted - 2007-05-29 : 09:57:45
|
| Can anybody tell me, how to Debug Stored Procedure in SQL 2005 and even in SQL 2000?thanks in advance,Mahesh |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-05-29 : 10:01:45
|
| SQL 2000:[url]http://www.15seconds.com/issue/050106.htm[/url]For SQL 2005, you can only debug using Visual Studio IDE.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
akashenk
Posting Yak Master
111 Posts |
Posted - 2007-05-30 : 02:44:19
|
| For SQL Server 2005, I believe you can get your hands on SQL Management Studio (Express or other version). In addition to managing database objects, this allows you to create, alter, test stored procedures against objects available in the database. I believe there is also a way to test stored procedures against databases exterenal to the one you are conneting to through SQL Management Studio, though I have not tried this. |
|
|
|
|
|
|
Debug Stored Procedure