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?

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?

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?

Relational Data and RDA

I have a few questions for you guys. I have a client

application that can be offline or online. While offline, records can be added and need to be later synced to production.

I will use rda to pull the table down, and this is working fine. Now what if I

have multiple tables where I want a foreign key relationship?

With rda I can only pull down one table at a time from

everything I've read. Now say create a constraint after pulling the two or more tables down. While in offline mode I create a new record on two seperate tables with foreign key/primary key relationship.

When I do the push to the server will it automatically

update the foreign key reference (locally) to the right one on the production

server? Or will I get a duplicate primary key error? On the production server the primary key will be different because of the identity. This is very important because I will have multiple clients.

Thanks in advance

Yes, you can add a foreign key constraint to a pulled table with tracking turned on and when you push it back to the server the key will be created there as well. This is one of the few schema changes that you can propagate back to the server.

When pushing your updates back to the server, no, the push does not also updated foreign key tables. This means if you have table A and table B and B contains a column that is an FK to a column in Table A, you need to always push A then B when doing your RDA push back to the server to prevent an referential integrity issue.

In anything more complex than this in terms of constraints or change tracking, you'll need to consider using merge replication.

Darren

sql

Relational Data and RDA

I have a few questions for you guys. I have a client

application that can be offline or online. While offline, records can be added and need to be later synced to production.

I will use rda to pull the table down, and this is working fine. Now what if I

have multiple tables where I want a foreign key relationship?

With rda I can only pull down one table at a time from

everything I've read. Now say create a constraint after pulling the two or more tables down. While in offline mode I create a new record on two seperate tables with foreign key/primary key relationship.

When I do the push to the server will it automatically

update the foreign key reference (locally) to the right one on the production

server? Or will I get a duplicate primary key error? On the production server the primary key will be different because of the identity. This is very important because I will have multiple clients.

Thanks in advance

Yes, you can add a foreign key constraint to a pulled table with tracking turned on and when you push it back to the server the key will be created there as well. This is one of the few schema changes that you can propagate back to the server.

When pushing your updates back to the server, no, the push does not also updated foreign key tables. This means if you have table A and table B and B contains a column that is an FK to a column in Table A, you need to always push A then B when doing your RDA push back to the server to prevent an referential integrity issue.

In anything more complex than this in terms of constraints or change tracking, you'll need to consider using merge replication.

Darren

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]

register online sql server

Hi, here is my problem

I am trying to conncet to an SQL Server that is on the net. The name of the server looks like : sqlServer.TheCompanyOwingIt.Com and it listens to port 2433

I am opening enterprise manager and trying to connect ,giving the name of the server and the credentials but no luck. I also tried opening hte client Network utility , created an alias for that server, specifying 2433 as the port but no luck again. Finally i tried to change the port of my sql server to be 2433 (instead of 1433), no luck again !!! Any ideas ? (there is no firewall running on the PC, but there is a router which might (?) cause the problem ? (i tried to port forward 2433 , but i am not sure if i did it correctly).

Any ideas, suggestions will be greatly appreciated

Thx in advance

Theodore

Did you use the syntax of

sqlServer.TheCompanyOwingIt.Com,2433

?

Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

Use it where ?

someplace in the enterprise manager? no, not really, i havent used it. Could u plz be more specific on the steps i have to follow?

thx

theodore

|||

Navigate to a group

New registration > Type in ServerName,portnumber e.g. JensOne,2222 > Next > Security information > Next > Next > Finish

Done :-)

Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

ok...

that didnt work either !!! i guess there might be a problem with my pc or my ISP ?.... i'll figure it out somehow

thx anyway Jens;-)