April 7, 2005 at 6:09 am
I need the help in MS SQL Server 7.0 to identify stored procedures which retrieve info information about the error logs that are generated by MS SQL Server 7.0 under the dir LOG.
URGENT
Thanks & Regards
Bijoy Chacko
April 7, 2005 at 12:54 pm
I don't know of any stored procedure, but the error logs are clear text. First, you can view them from within Enterprise Manager by expanding the server, then expand management, then SQL Server Logs, then select the error log you wish to view. Alternately, since the logs are clear text, you can view them directly with any text editor.
Just be sure that you are not confusing error logs with transaction logs. Transaction logs cannot be viewed (unless you purchase a special 3rd party tool which allows this).
Steve
April 8, 2005 at 10:59 am
I do not know if this SQL2K extended stored priocedure exists in v7.0:
master..xp_readerrorlog
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
April 8, 2005 at 11:03 am
The clear text logs spoken about earlier can be found in the LOG directory under the MSSQL directory in your installation path.
Always remember to check the event logs as well. Usually you'll find the same or similiar information there for error situations.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply