sql server programming: Could anyone please tell me from where I can read the SQL Server error log.
Actually when I do database back then after some time I get some error
wherein in the end is stated "..............See the SQL Server error log for
more details. That's why I wanted to read what that log says.

Thanks in advance!

You could run sp_readerrorlog. This procedure displays the current error
log. You can look at previous error logs by passing numbers 1 to n as the
first parameter, where n is the last error log number.

The error logs are stored as text files in the MSSQL\Log folder.

--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
What hardware is your SQL Server running on?
http://vyaskn.tripod.com/poll.htm




[quoted text, click to view]
Could anyone please tell me from where I can read the SQL Server error log.
Actually when I do database back then after some time I get some error
wherein in the end is stated "..............See the SQL Server error log for
more details. That's why I wanted to read what that log says.

Thanks in advance!

You'll find it in the\MSSQL\Log folder (wherever you installed SQL Server -
default is C: \Program Files\Microsoft SQL Server\MSSQL\Log). It's name is
ErrorLog. From previous reboots, you'll find ErrorLog.1, ErrorLog.2,.,.,..

--
Chuck Hawkins, MCSE, MCDBA
Author: SQL Server 2000 Stored Procedures,
Published by A! Press

[quoted text, click to view]

Also, you can find them in SQL Enterprise Manager, under the Management -
SQL Server Logs section for your server.

--
Chuck Hawkins, MCSE, MCDBA
Author: SQL Server 2000 Stored Procedures,
Published by A! Press
[quoted text, click to view]