INF: How SQL Monitor Locates SQL Server's Errorlog

  - Microsoft SQL Server version 4.2 for OS/2
  - Microsoft SQL Server version 4.2

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"

   "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."