Handling errors in stored procedure

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.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Handling errors in stored procedure

Author

Topic

mk_garg20
Constraint Violating Yak Guru

343 Posts

Posted - 2004-10-07 : 19:13:34

Following article shows how to handle non-fatal errors in stored procedure and application.

http://www.sqlteam.com/item.asp?ItemID=2841

How we can handle fatal errors?

Thanks

mk_garg

GunZ
Starting Member

29 Posts

Posted - 2004-10-07 : 20:04:20

aaaahhhhmmm.... Pray like it's the end of the world?

Australia.NSW.Sydney.GunZ

EDIT:
Enough funny answers... how fatal is it? I hope it's not like the end of the world type of fatality or... catastrophic might be the right word?

I like to know myself... cause we code some serious sql thingys that has the potential to stop the sql service for 20+ databases being served.

hgorijal
Constraint Violating Yak Guru

277 Posts

Posted - 2004-10-08 : 01:00:37

Can't. Must be why they are "FATAL" ;-)
Heard Yukon has some cool features in this aspect; like Try...Catch

Hemanth Gorijala
BI Architect / DBA...

mk_garg20
Constraint Violating Yak Guru

343 Posts

Posted - 2004-10-08 : 01:23:46

Thanks

mk_garg

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources