different sort order id

When I am trying to restore a database, getting an error
message which says "database attempting to restore was
backed up under different sort order id than the one
currently running and atleast one of them is a non-binary
sort order. Operation terminating abnormally."
How I can I rectify this problem ?
I'm guessing this is happening under SQL 7.0. On SQL 7.0 you can only
restore backups that contain the same sort order as the server in which you
are trying to restore to. Basically SQL 7.0 supports only a single sort
order for the server. But SQL 2000 does not have this limitation. In SQL
2000 you have server, database even column level sort orders, so you should
be able to restore your database backup to a 2000 server.
You might consider using DTS to move the data from the source server to your
new target server that has a different sort order then your source server.
----
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"Jagdish" <jnasit_x@.hss.hns.com> wrote in message
news:692701c42ea5$8b364e10$a101280a@.phx.gbl...
> When I am trying to restore a database, getting an error
> message which says "database attempting to restore was
> backed up under different sort order id than the one
> currently running and atleast one of them is a non-binary
> sort order. Operation terminating abnormally."
> How I can I rectify this problem ?
>

different sort order id

When I am trying to restore a database, getting an error
message which says "database attempting to restore was
backed up under different sort order id than the one
currently running and atleast one of them is a non-binary
sort order. Operation terminating abnormally."
How I can I rectify this problem ?I'm guessing this is happening under SQL 7.0. On SQL 7.0 you can only
restore backups that contain the same sort order as the server in which you
are trying to restore to. Basically SQL 7.0 supports only a single sort
order for the server. But SQL 2000 does not have this limitation. In SQL
2000 you have server, database even column level sort orders, so you should
be able to restore your database backup to a 2000 server.
You might consider using DTS to move the data from the source server to your
new target server that has a different sort order then your source server.
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"Jagdish" <jnasit_x@.hss.hns.com> wrote in message
news:692701c42ea5$8b364e10$a101280a@.phx.gbl...
> When I am trying to restore a database, getting an error
> message which says "database attempting to restore was
> backed up under different sort order id than the one
> currently running and atleast one of them is a non-binary
> sort order. Operation terminating abnormally."
> How I can I rectify this problem ?
>

different sort order id

When I am trying to restore a database, getting an error
message which says "database attempting to restore was
backed up under different sort order id than the one
currently running and atleast one of them is a non-binary
sort order. Operation terminating abnormally."
How I can I rectify this problem ?I'm guessing this is happening under SQL 7.0. On SQL 7.0 you can only
restore backups that contain the same sort order as the server in which you
are trying to restore to. Basically SQL 7.0 supports only a single sort
order for the server. But SQL 2000 does not have this limitation. In SQL
2000 you have server, database even column level sort orders, so you should
be able to restore your database backup to a 2000 server.
You might consider using DTS to move the data from the source server to your
new target server that has a different sort order then your source server.
--
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"Jagdish" <jnasit_x@.hss.hns.com> wrote in message
news:692701c42ea5$8b364e10$a101280a@.phx.gbl...
> When I am trying to restore a database, getting an error
> message which says "database attempting to restore was
> backed up under different sort order id than the one
> currently running and atleast one of them is a non-binary
> sort order. Operation terminating abnormally."
> How I can I rectify this problem ?
>

different behaviour of SQL Server 2000 errors dependent on windows OS

I am having a problem inserting data into a database table. There is a
stored procedure that is attempting to insert data into several tables, if
there is a duplicate entry already exists in the table then a unique key
violation is thrown back from sql server (2000) to the data access layer.
The data access layer then processes the sql exceptions and check the error
codes and the number of sql errors that occurred. If the error codes and
number of exceptions are the expected number and expected type then the
exception is surpressed and processing continues, BUT if the number of
exceptions or the number of the sql error is different then the exception is
propagated up the stack. (I didn't design this )
Development environment is XP Pro (2002) SP1 - .Net Framework 1.1
Production\Test environment is Windows 2003 (Standard Edition) - .Net
Framework 1.1
both machines are accessing the same physical database.
So in development we get 4 exceptions back with the expected error codes and
in production\test we get back 1 error. Can anyone explain why?
Is there a setting somewhere in the registry to affect how sql server errors
are processed by the native database access driver on the client machine?
Am I loosing the plot? - YES
As far as I can see this is NOT an .Net framework issue but an issue with
error propagatation\processing with the server installation of sql server
2000
Cheers
Ollie Riches
http://www.phoneanalyser.net
Disclaimer: Opinions expressed in this forum are my own, and not
representative of my employer.
I do not answer questions on behalf of my employer. I'm just a programmer
helping programmers.
FYI
When the stored procedure calls RAISERROR the severity level is 16.
Ollie
"Ollie Riches" <ollie.riches@.phoneanalser.net> wrote in message
news:uQb9AumHFHA.2976@.TK2MSFTNGP15.phx.gbl...
> I am having a problem inserting data into a database table. There is a
> stored procedure that is attempting to insert data into several tables, if
> there is a duplicate entry already exists in the table then a unique key
> violation is thrown back from sql server (2000) to the data access layer.
> The data access layer then processes the sql exceptions and check the
error
> codes and the number of sql errors that occurred. If the error codes and
> number of exceptions are the expected number and expected type then the
> exception is surpressed and processing continues, BUT if the number of
> exceptions or the number of the sql error is different then the exception
is
> propagated up the stack. (I didn't design this )
> Development environment is XP Pro (2002) SP1 - .Net Framework 1.1
> Production\Test environment is Windows 2003 (Standard Edition) - .Net
> Framework 1.1
> both machines are accessing the same physical database.
> So in development we get 4 exceptions back with the expected error codes
and
> in production\test we get back 1 error. Can anyone explain why?
> Is there a setting somewhere in the registry to affect how sql server
errors
> are processed by the native database access driver on the client machine?
> Am I loosing the plot? - YES
> As far as I can see this is NOT an .Net framework issue but an issue with
> error propagatation\processing with the server installation of sql server
> 2000
> Cheers
> Ollie Riches
> http://www.phoneanalyser.net
> Disclaimer: Opinions expressed in this forum are my own, and not
> representative of my employer.
> I do not answer questions on behalf of my employer. I'm just a programmer
> helping programmers.
>
>
>

different behaviour of SQL Server 2000 errors dependent on windows OS

I am having a problem inserting data into a database table. There is a
stored procedure that is attempting to insert data into several tables, if
there is a duplicate entry already exists in the table then a unique key
violation is thrown back from sql server (2000) to the data access layer.
The data access layer then processes the sql exceptions and check the error
codes and the number of sql errors that occurred. If the error codes and
number of exceptions are the expected number and expected type then the
exception is surpressed and processing continues, BUT if the number of
exceptions or the number of the sql error is different then the exception is
propagated up the stack. (I didn't design this )
Development environment is XP Pro (2002) SP1 - .Net Framework 1.1
Production\Test environment is Windows 2003 (Standard Edition) - .Net
Framework 1.1
both machines are accessing the same physical database.
So in development we get 4 exceptions back with the expected error codes and
in production\test we get back 1 error. Can anyone explain why?
Is there a setting somewhere in the registry to affect how sql server errors
are processed by the native database access driver on the client machine?
Am I loosing the plot? - YES
As far as I can see this is NOT an .Net framework issue but an issue with
error propagatation\processing with the server installation of sql server
2000
Cheers
Ollie Riches
http://www.phoneanalyser.net
Disclaimer: Opinions expressed in this forum are my own, and not
representative of my employer.
I do not answer questions on behalf of my employer. I'm just a programmer
helping programmers.
FYI
When the stored procedure calls RAISERROR the severity level is 16.
Ollie
"Ollie Riches" <ollie.riches@.phoneanalser.net> wrote in message
news:uQb9AumHFHA.2976@.TK2MSFTNGP15.phx.gbl...
> I am having a problem inserting data into a database table. There is a
> stored procedure that is attempting to insert data into several tables, if
> there is a duplicate entry already exists in the table then a unique key
> violation is thrown back from sql server (2000) to the data access layer.
> The data access layer then processes the sql exceptions and check the
error
> codes and the number of sql errors that occurred. If the error codes and
> number of exceptions are the expected number and expected type then the
> exception is surpressed and processing continues, BUT if the number of
> exceptions or the number of the sql error is different then the exception
is
> propagated up the stack. (I didn't design this )
> Development environment is XP Pro (2002) SP1 - .Net Framework 1.1
> Production\Test environment is Windows 2003 (Standard Edition) - .Net
> Framework 1.1
> both machines are accessing the same physical database.
> So in development we get 4 exceptions back with the expected error codes
and
> in production\test we get back 1 error. Can anyone explain why?
> Is there a setting somewhere in the registry to affect how sql server
errors
> are processed by the native database access driver on the client machine?
> Am I loosing the plot? - YES
> As far as I can see this is NOT an .Net framework issue but an issue with
> error propagatation\processing with the server installation of sql server
> 2000
> Cheers
> Ollie Riches
> http://www.phoneanalyser.net
> Disclaimer: Opinions expressed in this forum are my own, and not
> representative of my employer.
> I do not answer questions on behalf of my employer. I'm just a programmer
> helping programmers.
>
>
>

different behaviour of SQL Server 2000 errors dependent on windows OS

I am having a problem inserting data into a database table. There is a
stored procedure that is attempting to insert data into several tables, if
there is a duplicate entry already exists in the table then a unique key
violation is thrown back from sql server (2000) to the data access layer.
The data access layer then processes the sql exceptions and check the error
codes and the number of sql errors that occurred. If the error codes and
number of exceptions are the expected number and expected type then the
exception is surpressed and processing continues, BUT if the number of
exceptions or the number of the sql error is different then the exception is
propagated up the stack. (I didn't design this :))
Development environment is XP Pro (2002) SP1 - .Net Framework 1.1
Production\Test environment is Windows 2003 (Standard Edition) - .Net
Framework 1.1
both machines are accessing the same physical database.
So in development we get 4 exceptions back with the expected error codes and
in production\test we get back 1 error. Can anyone explain why?
Is there a setting somewhere in the registry to affect how sql server errors
are processed by the native database access driver on the client machine?
Am I loosing the plot? - YES
As far as I can see this is NOT an .Net framework issue but an issue with
error propagatation\processing with the server installation of sql server
2000
Cheers
Ollie Riches
http://www.phoneanalyser.net
Disclaimer: Opinions expressed in this forum are my own, and not
representative of my employer.
I do not answer questions on behalf of my employer. I'm just a programmer
helping programmers.FYI
When the stored procedure calls RAISERROR the severity level is 16.
Ollie
"Ollie Riches" <ollie.riches@.phoneanalser.net> wrote in message
news:uQb9AumHFHA.2976@.TK2MSFTNGP15.phx.gbl...
> I am having a problem inserting data into a database table. There is a
> stored procedure that is attempting to insert data into several tables, if
> there is a duplicate entry already exists in the table then a unique key
> violation is thrown back from sql server (2000) to the data access layer.
> The data access layer then processes the sql exceptions and check the
error
> codes and the number of sql errors that occurred. If the error codes and
> number of exceptions are the expected number and expected type then the
> exception is surpressed and processing continues, BUT if the number of
> exceptions or the number of the sql error is different then the exception
is
> propagated up the stack. (I didn't design this :))
> Development environment is XP Pro (2002) SP1 - .Net Framework 1.1
> Production\Test environment is Windows 2003 (Standard Edition) - .Net
> Framework 1.1
> both machines are accessing the same physical database.
> So in development we get 4 exceptions back with the expected error codes
and
> in production\test we get back 1 error. Can anyone explain why?
> Is there a setting somewhere in the registry to affect how sql server
errors
> are processed by the native database access driver on the client machine?
> Am I loosing the plot? - YES
> As far as I can see this is NOT an .Net framework issue but an issue with
> error propagatation\processing with the server installation of sql server
> 2000
> Cheers
> Ollie Riches
> http://www.phoneanalyser.net
> Disclaimer: Opinions expressed in this forum are my own, and not
> representative of my employer.
> I do not answer questions on behalf of my employer. I'm just a programmer
> helping programmers.
>
>
>

different behaviour of SQL Server 2000 errors dependent on windows OS

I am having a problem inserting data into a database table. There is a
stored procedure that is attempting to insert data into several tables, if
there is a duplicate entry already exists in the table then a unique key
violation is thrown back from sql server (2000) to the data access layer.
The data access layer then processes the sql exceptions and check the error
codes and the number of sql errors that occurred. If the error codes and
number of exceptions are the expected number and expected type then the
exception is surpressed and processing continues, BUT if the number of
exceptions or the number of the sql error is different then the exception is
propagated up the stack. (I didn't design this )
Development environment is XP Pro (2002) SP1 - .Net Framework 1.1
Production\Test environment is Windows 2003 (Standard Edition) - .Net
Framework 1.1
both machines are accessing the same physical database.
So in development we get 4 exceptions back with the expected error codes and
in production\test we get back 1 error. Can anyone explain why?
Is there a setting somewhere in the registry to affect how sql server errors
are processed by the native database access driver on the client machine?
Am I loosing the plot? - YES
As far as I can see this is NOT an .Net framework issue but an issue with
error propagatation\processing with the server installation of sql server
2000
Cheers
Ollie Riches
http://www.phoneanalyser.net
Disclaimer: Opinions expressed in this forum are my own, and not
representative of my employer.
I do not answer questions on behalf of my employer. I'm just a programmer
helping programmers.FYI
When the stored procedure calls RAISERROR the severity level is 16.
Ollie
"Ollie Riches" <ollie.riches@.phoneanalser.net> wrote in message
news:uQb9AumHFHA.2976@.TK2MSFTNGP15.phx.gbl...
> I am having a problem inserting data into a database table. There is a
> stored procedure that is attempting to insert data into several tables, if
> there is a duplicate entry already exists in the table then a unique key
> violation is thrown back from sql server (2000) to the data access layer.
> The data access layer then processes the sql exceptions and check the
error
> codes and the number of sql errors that occurred. If the error codes and
> number of exceptions are the expected number and expected type then the
> exception is surpressed and processing continues, BUT if the number of
> exceptions or the number of the sql error is different then the exception
is
> propagated up the stack. (I didn't design this )
> Development environment is XP Pro (2002) SP1 - .Net Framework 1.1
> Production\Test environment is Windows 2003 (Standard Edition) - .Net
> Framework 1.1
> both machines are accessing the same physical database.
> So in development we get 4 exceptions back with the expected error codes
and
> in production\test we get back 1 error. Can anyone explain why?
> Is there a setting somewhere in the registry to affect how sql server
errors
> are processed by the native database access driver on the client machine?
> Am I loosing the plot? - YES
> As far as I can see this is NOT an .Net framework issue but an issue with
> error propagatation\processing with the server installation of sql server
> 2000
> Cheers
> Ollie Riches
> http://www.phoneanalyser.net
> Disclaimer: Opinions expressed in this forum are my own, and not
> representative of my employer.
> I do not answer questions on behalf of my employer. I'm just a programmer
> helping programmers.
>
>
>

different behaviour of SQL Server 2000 errors dependent on windows OS

I am having a problem inserting data into a database table. There is a
stored procedure that is attempting to insert data into several tables, if
there is a duplicate entry already exists in the table then a unique key
violation is thrown back from sql server (2000) to the data access layer.
The data access layer then processes the sql exceptions and check the error
codes and the number of sql errors that occurred. If the error codes and
number of exceptions are the expected number and expected type then the
exception is surpressed and processing continues, BUT if the number of
exceptions or the number of the sql error is different then the exception is
propagated up the stack. (I didn't design this :))
Development environment is XP Pro (2002) SP1 - .Net Framework 1.1
Production\Test environment is Windows 2003 (Standard Edition) - .Net
Framework 1.1
both machines are accessing the same physical database.
So in development we get 4 exceptions back with the expected error codes and
in production\test we get back 1 error. Can anyone explain why?
Is there a setting somewhere in the registry to affect how sql server errors
are processed by the native database access driver on the client machine?
Am I loosing the plot? - YES
As far as I can see this is NOT an .Net framework issue but an issue with
error propagatation\processing with the server installation of sql server
2000
Cheers
Ollie Riches
http://www.phoneanalyser.net
Disclaimer: Opinions expressed in this forum are my own, and not
representative of my employer.
I do not answer questions on behalf of my employer. I'm just a programmer
helping programmers.FYI
When the stored procedure calls RAISERROR the severity level is 16.
Ollie
"Ollie Riches" <ollie.riches@.phoneanalser.net> wrote in message
news:uQb9AumHFHA.2976@.TK2MSFTNGP15.phx.gbl...
> I am having a problem inserting data into a database table. There is a
> stored procedure that is attempting to insert data into several tables, if
> there is a duplicate entry already exists in the table then a unique key
> violation is thrown back from sql server (2000) to the data access layer.
> The data access layer then processes the sql exceptions and check the
error
> codes and the number of sql errors that occurred. If the error codes and
> number of exceptions are the expected number and expected type then the
> exception is surpressed and processing continues, BUT if the number of
> exceptions or the number of the sql error is different then the exception
is
> propagated up the stack. (I didn't design this :))
> Development environment is XP Pro (2002) SP1 - .Net Framework 1.1
> Production\Test environment is Windows 2003 (Standard Edition) - .Net
> Framework 1.1
> both machines are accessing the same physical database.
> So in development we get 4 exceptions back with the expected error codes
and
> in production\test we get back 1 error. Can anyone explain why?
> Is there a setting somewhere in the registry to affect how sql server
errors
> are processed by the native database access driver on the client machine?
> Am I loosing the plot? - YES
> As far as I can see this is NOT an .Net framework issue but an issue with
> error propagatation\processing with the server installation of sql server
> 2000
> Cheers
> Ollie Riches
> http://www.phoneanalyser.net
> Disclaimer: Opinions expressed in this forum are my own, and not
> representative of my employer.
> I do not answer questions on behalf of my employer. I'm just a programmer
> helping programmers.
>
>
>

Differences between subscription types - help needed

I'm attempting to learn about Data Driven Subscriptions via Books
Online, particularly this tutorial:
http://msdn2.microsoft.com/en-us/library/ms169673.aspx, with no luck
thus far.
I have created essentially the same subscription as a non-data driven
one, and this successfully creates the file (rather than the email
mentioned in the tutorial). What could cause a data-driven subscription
not to work when an almost identical regular subscription does work? I
have tried both methods multiple times, with the same results.
Thanks in advance.This problem has been resolved. The local copy of that tutorial is
outdated, with the new version online. It makes values for a few fields
more explicit, and explores writing to a fileshare rather than to
email.