Microsoft KB Archive/101259: Difference between revisions
(importing KB archive) |
m (Text replacement - """ to """) |
||
Line 22: | Line 22: | ||
== SUMMARY == | == 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 | 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.<br /> | ||
<br /> | <br /> | ||
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 | 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:<br /> | ||
* The master device is located in directory | * The master device is located in directory "x:\...\data" or "x:\...\DATA."<br /> | ||
<br /> | <br /> | ||
-and- | -and- | ||
* The errorlog has the path name | * The errorlog has the path name "x:\...\log\errorlog." | ||
<br /> | <br /> | ||
Line 37: | Line 37: | ||
== MORE INFORMATION == | == MORE INFORMATION == | ||
If the master device is not in directories | If the master device is not in directories "x:\...\data" or "x:\...\DATA," the following error message will be generated:<br /> | ||
<blockquote><div class="ERRORMESSAGE"> | <blockquote><div class="ERRORMESSAGE"> | ||
"error open errorlog" | |||
</div></blockquote> | </div></blockquote> | ||
<br /> | <br /> | ||
If the errorlog doesn't locate on | If the errorlog doesn't locate on "x:\...\log\errorlog," the following error message will be generated:<br /> | ||
<blockquote><div class="ERRORMESSAGE"> | <blockquote><div class="ERRORMESSAGE"> | ||
"sql server errorlog is not available" | |||
</div></blockquote> | </div></blockquote> | ||
Line 59: | Line 59: | ||
=== Example === | === Example === | ||
If the master device's name is | 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 | Additional query words: Windows NT |
Latest revision as of 09:19, 20 July 2020
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
Last Reviewed: April 4, 2000 |