1 Resources for

error_state

Sponsored White Papers, Webcasts, and Downloads

ERROR_STATE() in SQL2005: Anybody help me explain the description of the return-value from ERROR_STATE. Thanks ERROR_STATE: Returns the state number of the error that caused the CATCH block of a TRY…CATCH construct to be run. BUT I would like to know the meaning or context which the returned-number stands for. :'(thanks for...; Tags: ERROR_STATE, programming, khanhmy264@...; Discussion threads 2006-12-06

Understanding the new Try/Catch statement in SQL Server 2005: Error handling has come a long way in SQL Server 2005. Arthur Fuller says that if you're using Raiserror instead of the new Try/Catch statement, it's time to wake up and smell the coffee! Versions prior to SQL Server 2005 offered little in the way of error handling—Raiserror...; Tags: Microsoft SQL Server, Microsoft SQL Server 2005, Try/Catch, Databases, Arthur Fuller, Error Handling, Begin Catch, Begin Try, SQL Server Newsletter, TechRepublic Inc., Error, Listing B, Catch, Enterprise Software, Software, Data Management; Technical articles 2006-08-21
Get detailed error handling information in SQL Server 2005: In a recent article, I demonstrated how to catch errors inSQL Server 2000. The most significant aspect of error handling in SQLServer 2000 is the @@ERROR variable. You must query the value of this variableafter every statement execution to ensure no error has occurred that wouldrequire the transaction to be...; Tags: Microsoft SQL Server, Microsoft SQL Server 2000, Microsoft SQL Server 2005, Tim Chapman; Technical articles 2006-06-19

Help Desk Trouble Ticket Form: The Help Desk Trouble Ticket is an important document for the technical support professional. This form contains all the essential fields for maintain ...; Buy Now

Windows XP vs. Mac OS X: This presentation, entitled Standardizing on Windows XP Instead of MAC OS X, provides a pre-packaged option for defending Windows XP against MAC OS X. ...; Buy Now