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 |
|
nitin1353
Constraint Violating Yak Guru
381 Posts |
 Posted - 2008-07-21 : 23:30:01
|
| GurusCan you please guide that how do i catch errors in dynamic sql in sqlserver 2000?Thanks |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2008-07-21 : 23:41:45
|
use PRINT to print out the dynamically form query and copy & paste it in query window and run it
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
nitin1353
Constraint Violating Yak Guru
381 Posts |
Posted - 2008-07-22 : 00:39:36
|
| Thanks for the replyPlease guide if my query is written in a Stored ProcedureThanksNitin |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-07-22 : 04:44:48
|
| www.sommarskog.se/Error-Handling-I.htmlwww.sommarskog.se/Error-Handling-II.htmlMadhivananFailing to plan is Planning to fail |
|
|
|
nitin1353
Constraint Violating Yak Guru
381 Posts |
Posted - 2008-07-22 : 07:13:06
|
| These links are not working madhvanPlease AdviceNitin |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
How do i catch errors in Dynamic Sql