Wednesday, March 28, 2012

Relationship between Error Numbers and books Online URls?

Hi,
Is there any relationship between a sql server error number and the naming
convention used in SqlServer Books Online documentation error documentation
files?
Example:
The file name for Error # 207 in books Online ends with "_1_1qyf.htm",
in the msdn version of books online it ends with "_1_1qyf.asp"
The file name for error # 208 ends with "_1_1qyg.asp"
My goal: to programtically generate urls that point to each error's
documentation in books online (sqlException's "Number" property contains the
error number value, so the idea is to programatically set the helplink
property to the correct url by evaluating the number value and running it
through some operation to create the correct url).
I know the error numbers refer to the error id column value in
master.dbo.sysmessages -- but i want to be able to derive urls to books
online from the error number b/c those files have more complete information.
Any suggestions?> Is there any relationship between a sql server error number and the naming
> convention used in SqlServer Books Online documentation error
> documentation
> files?

> My goal: to programtically generate urls that point to each error's
> documentation in books online (sqlException's "Number" property contains
> the
> error number value, so the idea is to programatically set the helplink
> property to the correct url by evaluating the number value and running it
> through some operation to create the correct url).
Sorry, there is no intentional relationship between an error message number
and the filename of the corresponding topic in BOL. Nor is there a way to
predict the filename based on the error number. The filenames for Books
Online topics are auto-generated by the authoring system we use. At best
you can know that the topics for system error messages will have a filename
that starts with "tr_reslsyserr_%" , but the numbering sequence used to
create a unique filename (for example, tr_reslsyserr_1_2a0j.htm) is not
predictable.
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
"Chris Mohan" <ChrisMohan@.discussions.microsoft.com> wrote in message
news:86009ACC-4B0E-4308-B642-4BCA8D9E12E9@.microsoft.com...
> Hi,
> Is there any relationship between a sql server error number and the naming
> convention used in SqlServer Books Online documentation error
> documentation
> files?
> Example:
> The file name for Error # 207 in books Online ends with "_1_1qyf.htm",
> in the msdn version of books online it ends with "_1_1qyf.asp"
> The file name for error # 208 ends with "_1_1qyg.asp"
> My goal: to programtically generate urls that point to each error's
> documentation in books online (sqlException's "Number" property contains
> the
> error number value, so the idea is to programatically set the helplink
> property to the correct url by evaluating the number value and running it
> through some operation to create the correct url).
> I know the error numbers refer to the error id column value in
> master.dbo.sysmessages -- but i want to be able to derive urls to books
> online from the error number b/c those files have more complete
> information.
> Any suggestions?

No comments:

Post a Comment