SqlServer 2000 Error Logging

To log error in sql log / windows log, just exec the following SP:

….sql code goes here which will cause error.
--To check for error, we use @@error global variable predefined in sql.
set @error = @@error
if @error <> 0
exec sp_altermessage @error ,'with_log', 'true'

To view the error, you can either view either in

1. windows event viewer
2. SQL server Mgmt studio , path is : --> Management --> Sql Server Logs
3. exec master..xp_readerrorlog

To learn more visit
http://www.sqlservercentral.com/articles/Error+Description/65013/

Regards