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 2005 Forums
 Transact-SQL (2005)
 Error Handling

Author  Topic 

msv
Starting Member

9 Posts

Posted - 2009-08-13 : 11:37:14
How should we raise an error if there is a problem in the network or like database connection????

TG
Master Smack Fu Yak Hacker

6065 Posts

Posted - 2009-08-13 : 13:43:55
every tier in your architecture needs to trap and handle potential errors. sql errors can be handled by t-sql code in a variety of ways including use of try/catch blocks. A sql server forum is probably not the best place to discuss handling Non-sql errors. What technology are you using to connect to your database server?

Be One with the Optimizer
TG
Go to Top of Page

msv
Starting Member

9 Posts

Posted - 2009-08-13 : 14:11:41
Well.. I am writing a stored procedure using T-SQL and i try to catch the data errors and stuff but I want to see how it is handled when the DB Connection is lost and how those errors are handled?
Go to Top of Page
   

- Advertisement -