The first place to look is the Application Log in your NT Event Viewer. SQL
Server will log any program errors there. SQL Server also writes logfiles
into the %SQLDIR%\log directory. The current logfile is named Errorlog and
the past five logfiles are named Errorlog.1 through Errorlog.5

Whether or not there is user error logging depends on whether the
application has error logging in it. The server itself would return error
messages to an application, but it does not log them except for the most
severe.

Another good place to look for issues is within the Enterprise Manager.
Expand the Management, then expand SQL Server Agent and look if there are
any Alerts set. Also look at the Jobs folder. Right click on the jobs and
select Job History to see if there have been any failures of the scheduled
jobs. Hope this helps.

Yomi

-----Original Message-----
From: Mathias Awundaga [mailto:[Email Address Removed] Friday, March 29, 2002 9:29 AM
To: [Email Address Removed] Where can I look for user logs containing user or program
errors


Hi Guys,

My SQL Server DB seems to be acting up and I want to know where to go
get information on user or program errors if at all SQL Server logs
them? Are there any other alert logs produced and if so how can I view
them?

Thanks
Mathias



---------------------------------------------------------------------
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page