Q101259 - INF: How SQL Monitor Locates SQL Server's Errorlog

INF: How SQL Monitor Locates SQL Server's Errorlog

Q101259

The information in this article applies to:

Microsoft SQL Server version 4.2x

SUMMARY

You will sometimes get an error message when you try to view Microsoft SQL Server's errorlog from SQL Administrator. This could be caused by sqlmonitor assuming the errorlog is located on x:\...\log\errorlog, where "x" is the drive letter that the master device resides on.

Sqlmonitor first locates the master device's path by doing a SELECT on sysdevices, then it uses a string comparison and grabs the part before "\data" or "\DATA" and appends "log\errorlog" to it. It makes the following two assumptions here:

The master device is located in directory "x:\...\data" or "x:\...\DATA."

-and-

The errorlog has the path name "x:\...\log\errorlog."

MORE INFORMATION

If the master device is not in directories "x:\...\data" or "x:\...\DATA," the following error message will be generated:

"error open errorlog"

If the errorlog doesn't locate on "x:\...\log\errorlog," the following error message will be generated:

"sql server errorlog is not available"

Example

If the master device's name is "c:\data\master.dat," the errorlog's name should be "c:\log\errorlog."

Additional query words: Windows NT

Keywords : kbtool
Issue type : kbinfo
Technology : kbSQLServSearch kbAudDeveloper kbSQLServ420OS2