CODEWITHSUNDEEP
sqlsql-server-2008logging
Manish
Manish

Reputation: 6286

Error logging in SQL Server 2008

A very short and straight question: I want to catch the error using try..catch and log it into a file. Is this possible in SQL Server 2008?

Any directions, help are welcome.

Upvotes: 7

Views: 12641

Answers (3)

Oleg Dok
Oleg Dok

Reputation: 21776

Like this, not exactly to file, but to eventlog, I think writing to file is only possible with CLR procedure:

BEGIN TRY
  Do some error
END TRY
Begin CATCh
  Declare @error nvarchar(max) = error_message()+' your data'
  exec master..xp_logevent 50001, @error, 'error'
  --Notify host application
   RAISERROR(@error, 16, 1) 
END CATCH

Upvotes: 0

hgulyan
hgulyan

Reputation: 8249

Yes, you can.

Just implement try catch as it's described here TRY...CATCH . Error logging can be logged either in application or in sql by writing errors to a table.

If you want to log into a file, you can do that using SQLCLR. Check the answer here

How to log in T-SQL

There're some similar questions you can check.

Logging into table in SQL Server trigger

Best Practices - Stored Procedure Logging

Another approach is to use Log4Sql

Upvotes: 8

Siva Charan
Siva Charan

Reputation: 18064

View the SQL Server error log by using SQL Server Management Studio or any text editor.

By default, the error log is located at Program Files\Microsoft SQL Server\MSSQL.n\MSSQL\LOG\ERRORLOG and ERRORLOG.n files.

Go through Viewing the SQL Server Error Log page

Upvotes: 1

Related Questions