Using the Error Message Number to Resolve the Error

Earlier in this chapter, you learned that, by using the error message number, you could quickly retrieve detailed information about the error and possible ways to resolve the error. How, you might ask? Books Online!


Isn't technology great? I believe that to really appreciate Microsoft's Books Online, you have to have been a Sybase DBA from the 4.2 UNIX days. When an error would occur that displayed the error number, you jotted down the error number and then tried to locate the error messages and the troubleshooting guide. Of course, the book was never in the same place. And if you had my luck, when you found the book, the error number was never in the book—it ...

Get Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.