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?
Showing posts with label books. Show all posts
Showing posts with label books. Show all posts
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?
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?
Monday, March 26, 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?
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?
Friday, March 9, 2012
re-index
Take a look at dbcc dbreindex on Books Online.
Ben Nevarez, MCDBA, OCP
Database Administrator
"00KobeBrian" wrote:
> How do you re-index in SQL 2000? Thanks.
>
>Hi,
Check following two articles:
http://msdn2.microsoft.com/en-us/library/ms181671.aspx
http://msdn2.microsoft.com/en-us/library/ms188388.aspx
They apply to SQL 2000 as well.
Thanks.
Best regards,
Vincent Xu
Microsoft Online Partner Support
========================================
==============
Get Secure! - www.microsoft.com/security
========================================
==============
When responding to posts, please "Reply to Group" via your newsreader so
that others
may learn and benefit from this issue.
========================================
==============
This posting is provided "AS IS" with no warranties,and confers no rights.
========================================
==============
--[vbcol=seagreen]|||Hi Vincent,
Looks like alter index does not apply to SQL Server 2000.
Ben Nevarez, MCDBA, OCP
Database Administrator
"Vincent Xu [MSFT]" wrote:
> Hi,
> Check following two articles:
> http://msdn2.microsoft.com/en-us/library/ms181671.aspx
> http://msdn2.microsoft.com/en-us/library/ms188388.aspx
> They apply to SQL 2000 as well.
> Thanks.
>
> Best regards,
> Vincent Xu
> Microsoft Online Partner Support
> ========================================
==============
> Get Secure! - www.microsoft.com/security
> ========================================
==============
> When responding to posts, please "Reply to Group" via your newsreader so
> that others
> may learn and benefit from this issue.
> ========================================
==============
> This posting is provided "AS IS" with no warranties,and confers no rights.
> ========================================
==============
>
> --
>|||How do you re-index in SQL 2000? Thanks.|||Take a look at dbcc dbreindex on Books Online.
Ben Nevarez, MCDBA, OCP
Database Administrator
"00KobeBrian" wrote:
> How do you re-index in SQL 2000? Thanks.
>
>|||Hi,
Check following two articles:
http://msdn2.microsoft.com/en-us/library/ms181671.aspx
http://msdn2.microsoft.com/en-us/library/ms188388.aspx
They apply to SQL 2000 as well.
Thanks.
Best regards,
Vincent Xu
Microsoft Online Partner Support
========================================
==============
Get Secure! - www.microsoft.com/security
========================================
==============
When responding to posts, please "Reply to Group" via your newsreader so
that others
may learn and benefit from this issue.
========================================
==============
This posting is provided "AS IS" with no warranties,and confers no rights.
========================================
==============
--[vbcol=seagreen]|||Hi Vincent,
Looks like alter index does not apply to SQL Server 2000.
Ben Nevarez, MCDBA, OCP
Database Administrator
"Vincent Xu [MSFT]" wrote:
> Hi,
> Check following two articles:
> http://msdn2.microsoft.com/en-us/library/ms181671.aspx
> http://msdn2.microsoft.com/en-us/library/ms188388.aspx
> They apply to SQL 2000 as well.
> Thanks.
>
> Best regards,
> Vincent Xu
> Microsoft Online Partner Support
> ========================================
==============
> Get Secure! - www.microsoft.com/security
> ========================================
==============
> When responding to posts, please "Reply to Group" via your newsreader so
> that others
> may learn and benefit from this issue.
> ========================================
==============
> This posting is provided "AS IS" with no warranties,and confers no rights.
> ========================================
==============
>
> --
>|||Hi All,
Sorry, my mistake.I assume this as a matter of course
We have to use DBCC
Check following article:
<http://www.microsoft.com/technet/pr...in/ss2kidbp.msp
x>
Best regards,
Vincent Xu
Microsoft Online Partner Support
========================================
==============
Get Secure! - www.microsoft.com/security
========================================
==============
When responding to posts, please "Reply to Group" via your newsreader so
that others
may learn and benefit from this issue.
========================================
==============
This posting is provided "AS IS" with no warranties,and confers no rights.
========================================
==============
--[vbcol=seagreen]
<DD275389-46FA-4FA8-AD04-C9AB9FE75B21@.microsoft.com>
<rJ$Z6gAnGHA.2028@.TK2MSFTNGXA01.phx.gbl>[vbcol=seagreen]
so[vbcol=seagreen]
rights.[vbcol=seagreen]|||Hi All,
Sorry, my mistake.I assume this as a matter of course
We have to use DBCC
Check following article:
<http://www.microsoft.com/technet/pr...in/ss2kidbp.msp
x>
Best regards,
Vincent Xu
Microsoft Online Partner Support
========================================
==============
Get Secure! - www.microsoft.com/security
========================================
==============
When responding to posts, please "Reply to Group" via your newsreader so
that others
may learn and benefit from this issue.
========================================
==============
This posting is provided "AS IS" with no warranties,and confers no rights.
========================================
==============
--[vbcol=seagreen]
<DD275389-46FA-4FA8-AD04-C9AB9FE75B21@.microsoft.com>
<rJ$Z6gAnGHA.2028@.TK2MSFTNGXA01.phx.gbl>[vbcol=seagreen]
so[vbcol=seagreen]
rights.[vbcol=seagreen]
Ben Nevarez, MCDBA, OCP
Database Administrator
"00KobeBrian" wrote:
> How do you re-index in SQL 2000? Thanks.
>
>Hi,
Check following two articles:
http://msdn2.microsoft.com/en-us/library/ms181671.aspx
http://msdn2.microsoft.com/en-us/library/ms188388.aspx
They apply to SQL 2000 as well.
Thanks.
Best regards,
Vincent Xu
Microsoft Online Partner Support
========================================
==============
Get Secure! - www.microsoft.com/security
========================================
==============
When responding to posts, please "Reply to Group" via your newsreader so
that others
may learn and benefit from this issue.
========================================
==============
This posting is provided "AS IS" with no warranties,and confers no rights.
========================================
==============
--[vbcol=seagreen]|||Hi Vincent,
Looks like alter index does not apply to SQL Server 2000.
Ben Nevarez, MCDBA, OCP
Database Administrator
"Vincent Xu [MSFT]" wrote:
> Hi,
> Check following two articles:
> http://msdn2.microsoft.com/en-us/library/ms181671.aspx
> http://msdn2.microsoft.com/en-us/library/ms188388.aspx
> They apply to SQL 2000 as well.
> Thanks.
>
> Best regards,
> Vincent Xu
> Microsoft Online Partner Support
> ========================================
==============
> Get Secure! - www.microsoft.com/security
> ========================================
==============
> When responding to posts, please "Reply to Group" via your newsreader so
> that others
> may learn and benefit from this issue.
> ========================================
==============
> This posting is provided "AS IS" with no warranties,and confers no rights.
> ========================================
==============
>
> --
>|||How do you re-index in SQL 2000? Thanks.|||Take a look at dbcc dbreindex on Books Online.
Ben Nevarez, MCDBA, OCP
Database Administrator
"00KobeBrian" wrote:
> How do you re-index in SQL 2000? Thanks.
>
>|||Hi,
Check following two articles:
http://msdn2.microsoft.com/en-us/library/ms181671.aspx
http://msdn2.microsoft.com/en-us/library/ms188388.aspx
They apply to SQL 2000 as well.
Thanks.
Best regards,
Vincent Xu
Microsoft Online Partner Support
========================================
==============
Get Secure! - www.microsoft.com/security
========================================
==============
When responding to posts, please "Reply to Group" via your newsreader so
that others
may learn and benefit from this issue.
========================================
==============
This posting is provided "AS IS" with no warranties,and confers no rights.
========================================
==============
--[vbcol=seagreen]|||Hi Vincent,
Looks like alter index does not apply to SQL Server 2000.
Ben Nevarez, MCDBA, OCP
Database Administrator
"Vincent Xu [MSFT]" wrote:
> Hi,
> Check following two articles:
> http://msdn2.microsoft.com/en-us/library/ms181671.aspx
> http://msdn2.microsoft.com/en-us/library/ms188388.aspx
> They apply to SQL 2000 as well.
> Thanks.
>
> Best regards,
> Vincent Xu
> Microsoft Online Partner Support
> ========================================
==============
> Get Secure! - www.microsoft.com/security
> ========================================
==============
> When responding to posts, please "Reply to Group" via your newsreader so
> that others
> may learn and benefit from this issue.
> ========================================
==============
> This posting is provided "AS IS" with no warranties,and confers no rights.
> ========================================
==============
>
> --
>|||Hi All,
Sorry, my mistake.I assume this as a matter of course
We have to use DBCC
Check following article:
<http://www.microsoft.com/technet/pr...in/ss2kidbp.msp
x>
Best regards,
Vincent Xu
Microsoft Online Partner Support
========================================
==============
Get Secure! - www.microsoft.com/security
========================================
==============
When responding to posts, please "Reply to Group" via your newsreader so
that others
may learn and benefit from this issue.
========================================
==============
This posting is provided "AS IS" with no warranties,and confers no rights.
========================================
==============
--[vbcol=seagreen]
<DD275389-46FA-4FA8-AD04-C9AB9FE75B21@.microsoft.com>
<rJ$Z6gAnGHA.2028@.TK2MSFTNGXA01.phx.gbl>[vbcol=seagreen]
so[vbcol=seagreen]
rights.[vbcol=seagreen]|||Hi All,
Sorry, my mistake.I assume this as a matter of course
We have to use DBCC
Check following article:
<http://www.microsoft.com/technet/pr...in/ss2kidbp.msp
x>
Best regards,
Vincent Xu
Microsoft Online Partner Support
========================================
==============
Get Secure! - www.microsoft.com/security
========================================
==============
When responding to posts, please "Reply to Group" via your newsreader so
that others
may learn and benefit from this issue.
========================================
==============
This posting is provided "AS IS" with no warranties,and confers no rights.
========================================
==============
--[vbcol=seagreen]
<DD275389-46FA-4FA8-AD04-C9AB9FE75B21@.microsoft.com>
<rJ$Z6gAnGHA.2028@.TK2MSFTNGXA01.phx.gbl>[vbcol=seagreen]
so[vbcol=seagreen]
rights.[vbcol=seagreen]
Subscribe to:
Posts (Atom)