catch exception into a log file in SQL SERVER 2008

Fix:

print @ErrorMessage

You should log errors to a table not to a file.

You can export the table periodically to a file with bcp for example.

---

Kalman Toth Database & OLAP Architect IPAD SELECT Query Video Tutorial 3.5 Hours

New Book / Kindle: Exam 70-461 Bootcamp: Querying Microsoft SQL Server 2012