Changing collation when installing SQL2000

Hi,
I'm installing SQL2000 on a new cluster server.
I selected a 'custom installation' and was presented with a
'Collation settings' screen.
I need it to be SQL_Latin1_General_CP1_CI_AS collation
as I will be restoring databases with this collation.
What should I choose from the 'Collation designator' and 'SQL
Collations' box.
Is it 'Dictionary order, case-insensitive, for use with 1252
characters'?

What will be the default? Will it be the same default as for the
'typical' installation?
Thanks(polinaskulski@.aol.com) writes:
> I'm installing SQL2000 on a new cluster server.
> I selected a 'custom installation' and was presented with a
> 'Collation settings' screen.
> I need it to be SQL_Latin1_General_CP1_CI_AS collation
> as I will be restoring databases with this collation.
> What should I choose from the 'Collation designator' and 'SQL
> Collations' box.
> Is it 'Dictionary order, case-insensitive, for use with 1252
> characters'?

I would guess that is be the one, although the description also fits into
SQL_Latin1_General_CP1_CI_AI.

When you install Window collations, there are check-boxes for the
sensitivity stuff, but there might not be for SQL collations. (I
never install these.)

> What will be the default? Will it be the same default as for the
> 'typical' installation?

I believe that SQL_Latin1_General_CP1_CI_AS is the default is your
regional settings is English (USA).

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

Changing @@version

Hi
I have Sql2000 Server , i want to change the @.@.version.
Can i change the result of SELECT @.@.version ?
Where can i do this ?
Paul
No you can't change it...it's a built in function.
-Sue
On Wed, 31 Aug 2005 04:29:01 -0700, "paul"
<paul@.discussions.microsoft.com> wrote:

>Hi
>I have Sql2000 Server , i want to change the @.@.version.
>Can i change the result of SELECT @.@.version ?
>Where can i do this ?
|||Hi,
No you cant manually change that. As soon as you install the service
pack/security updates the version is automatically updated.
Thanks
Hari
SQL Server MVP
"paul" <paul@.discussions.microsoft.com> wrote in message
news:26F0A282-D97C-4C78-BAB7-E9518F17E8D7@.microsoft.com...
> Hi
> I have Sql2000 Server , i want to change the @.@.version.
> Can i change the result of SELECT @.@.version ?
> Where can i do this ?
> --
> Paul
|||As the others stated, you cannot change @.@.version, or the values returned by
the other system functions whose names start with @.@.. Also, it would be very
confusing to DBAs or others if @.@.version on an instance of the database
engine started reporting something other than the version of the software.
What do you want to change? Do you want to pull parts of the information
out? If so, have a look at the SERVERPROPERTY function, different parameters
for that function report different parts of the information available in
@.@.version. Or maybe you could use SUBSTRING to pull out the part you're
interested in.
Alan Brewer [MSFT]
Content Architect, SQL Server Documentation Team
SQL Server Developer Center: http://msdn.microsoft.com/sql
SQL Server TechCenter: http://technet.microsoft.com/sql/
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Hi
I have a aplication (software) that only run if the answerd of the select
@.@.version is : MSDE SQL serrver... ..... .
But my aplication is already with 1,9 Gb , so if i change to SQL SERVER the
aplication will not run.
If i can use SQL Server and altered the result of @.@.version , to MSDE .....
, i think that the aplication will run .
Paul
"Alan Brewer [MSFT]" wrote:

> As the others stated, you cannot change @.@.version, or the values returned by
> the other system functions whose names start with @.@.. Also, it would be very
> confusing to DBAs or others if @.@.version on an instance of the database
> engine started reporting something other than the version of the software.
> What do you want to change? Do you want to pull parts of the information
> out? If so, have a look at the SERVERPROPERTY function, different parameters
> for that function report different parts of the information available in
> @.@.version. Or maybe you could use SUBSTRING to pull out the part you're
> interested in.
> --
> Alan Brewer [MSFT]
> Content Architect, SQL Server Documentation Team
> SQL Server Developer Center: http://msdn.microsoft.com/sql
> SQL Server TechCenter: http://technet.microsoft.com/sql/
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
>
|||I suggest you contact the software author or vendor for support. Safest
to assume there's a valid reason why such a constraint would be built
in to the software. For example maybe the vendor only licenses the
product for use with MSDE.
David Portas
SQL Server MVP

Changing @@version

Hi
I have Sql2000 Server , i want to change the @.@.version.
Can i change the result of SELECT @.@.version ?
Where can i do this ?
--
PaulNo you can't change it...it's a built in function.
-Sue
On Wed, 31 Aug 2005 04:29:01 -0700, "paul"
<paul@.discussions.microsoft.com> wrote:
>Hi
>I have Sql2000 Server , i want to change the @.@.version.
>Can i change the result of SELECT @.@.version ?
>Where can i do this ?|||Hi,
No you cant manually change that. As soon as you install the service
pack/security updates the version is automatically updated.
Thanks
Hari
SQL Server MVP
"paul" <paul@.discussions.microsoft.com> wrote in message
news:26F0A282-D97C-4C78-BAB7-E9518F17E8D7@.microsoft.com...
> Hi
> I have Sql2000 Server , i want to change the @.@.version.
> Can i change the result of SELECT @.@.version ?
> Where can i do this ?
> --
> Paul|||As the others stated, you cannot change @.@.version, or the values returned by
the other system functions whose names start with @.@.. Also, it would be very
confusing to DBAs or others if @.@.version on an instance of the database
engine started reporting something other than the version of the software.
What do you want to change? Do you want to pull parts of the information
out? If so, have a look at the SERVERPROPERTY function, different parameters
for that function report different parts of the information available in
@.@.version. Or maybe you could use SUBSTRING to pull out the part you're
interested in.
--
Alan Brewer [MSFT]
Content Architect, SQL Server Documentation Team
SQL Server Developer Center: http://msdn.microsoft.com/sql
SQL Server TechCenter: http://technet.microsoft.com/sql/
This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi
I have a aplication (software) that only run if the answerd of the select
@.@.version is : MSDE SQL serrver... ..... .
But my aplication is already with 1,9 Gb , so if i change to SQL SERVER the
aplication will not run.
If i can use SQL Server and altered the result of @.@.version , to MSDE .....
, i think that the aplication will run .
Paul
"Alan Brewer [MSFT]" wrote:
> As the others stated, you cannot change @.@.version, or the values returned by
> the other system functions whose names start with @.@.. Also, it would be very
> confusing to DBAs or others if @.@.version on an instance of the database
> engine started reporting something other than the version of the software.
> What do you want to change? Do you want to pull parts of the information
> out? If so, have a look at the SERVERPROPERTY function, different parameters
> for that function report different parts of the information available in
> @.@.version. Or maybe you could use SUBSTRING to pull out the part you're
> interested in.
> --
> Alan Brewer [MSFT]
> Content Architect, SQL Server Documentation Team
> SQL Server Developer Center: http://msdn.microsoft.com/sql
> SQL Server TechCenter: http://technet.microsoft.com/sql/
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
>|||I suggest you contact the software author or vendor for support. Safest
to assume there's a valid reason why such a constraint would be built
in to the software. For example maybe the vendor only licenses the
product for use with MSDE.
--
David Portas
SQL Server MVP
--

Changing @@version

Hi
I have Sql2000 Server , i want to change the @.@.version.
Can i change the result of SELECT @.@.version ?
Where can i do this ?
PaulNo you can't change it...it's a built in function.
-Sue
On Wed, 31 Aug 2005 04:29:01 -0700, "paul"
<paul@.discussions.microsoft.com> wrote:

>Hi
>I have Sql2000 Server , i want to change the @.@.version.
>Can i change the result of SELECT @.@.version ?
>Where can i do this ?|||Hi,
No you cant manually change that. As soon as you install the service
pack/security updates the version is automatically updated.
Thanks
Hari
SQL Server MVP
"paul" <paul@.discussions.microsoft.com> wrote in message
news:26F0A282-D97C-4C78-BAB7-E9518F17E8D7@.microsoft.com...
> Hi
> I have Sql2000 Server , i want to change the @.@.version.
> Can i change the result of SELECT @.@.version ?
> Where can i do this ?
> --
> Paul|||As the others stated, you cannot change @.@.version, or the values returned by
the other system functions whose names start with @.@.. Also, it would be very
confusing to DBAs or others if @.@.version on an instance of the database
engine started reporting something other than the version of the software.
What do you want to change? Do you want to pull parts of the information
out? If so, have a look at the SERVERPROPERTY function, different parameters
for that function report different parts of the information available in
@.@.version. Or maybe you could use SUBSTRING to pull out the part you're
interested in.
Alan Brewer [MSFT]
Content Architect, SQL Server Documentation Team
SQL Server Developer Center: http://msdn.microsoft.com/sql
SQL Server TechCenter: http://technet.microsoft.com/sql/
This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi
I have a aplication (software) that only run if the answerd of the select
@.@.version is : MSDE SQL serrver... ..... .
But my aplication is already with 1,9 Gb , so if i change to SQL SERVER the
aplication will not run.
If i can use SQL Server and altered the result of @.@.version , to MSDE .....
, i think that the aplication will run .
Paul
"Alan Brewer [MSFT]" wrote:

> As the others stated, you cannot change @.@.version, or the values returned
by
> the other system functions whose names start with @.@.. Also, it would be ve
ry
> confusing to DBAs or others if @.@.version on an instance of the database
> engine started reporting something other than the version of the software.
> What do you want to change? Do you want to pull parts of the information
> out? If so, have a look at the SERVERPROPERTY function, different paramete
rs
> for that function report different parts of the information available in
> @.@.version. Or maybe you could use SUBSTRING to pull out the part you're
> interested in.
> --
> Alan Brewer [MSFT]
> Content Architect, SQL Server Documentation Team
> SQL Server Developer Center: http://msdn.microsoft.com/sql
> SQL Server TechCenter: http://technet.microsoft.com/sql/
> This posting is provided "AS IS" with no warranties, and confers no rights
.
>
>|||I suggest you contact the software author or vendor for support. Safest
to assume there's a valid reason why such a constraint would be built
in to the software. For example maybe the vendor only licenses the
product for use with MSDE.
David Portas
SQL Server MVP
--

change sql 2000 server collation

Hello,
Is there a way to change the collation of a sql2000 from
Latin1_General_CS_AI to Latin1_General_CI_AI?
thanks
WilfridIf you have to change the collation on server level meaning the collation of
master database then you will have to rebuild the master database. You can
change the collation of user databases by creating a new database with
desired collation and then transferring data from old database to new
database. Here is a microsoft article which describes it in detail:
http://support.microsoft.com/?kbid=325335#8
Bob
"Wilfrid" wrote:
> Hello,
> Is there a way to change the collation of a sql2000 from
> Latin1_General_CS_AI to Latin1_General_CI_AI?
> thanks
> Wilfrid
>
>

change sql 2000 server collation

Hello,
Is there a way to change the collation of a sql2000 from
Latin1_General_CS_AI to Latin1_General_CI_AI?
thanks
WilfridIf you have to change the collation on server level meaning the collation of
master database then you will have to rebuild the master database. You can
change the collation of user databases by creating a new database with
desired collation and then transferring data from old database to new
database. Here is a microsoft article which describes it in detail:
http://support.microsoft.com/?kbid=325335#8
Bob
"Wilfrid" wrote:

> Hello,
> Is there a way to change the collation of a sql2000 from
> Latin1_General_CS_AI to Latin1_General_CI_AI?
> thanks
> Wilfrid
>
>

Change publisher server

I have transactional replication on SQL2000 with 60 subscribers.
For disaster recovery procedure i need to establish new replication within 15 minutes on another server with same subscribers.
Can i just confogure another DB as publisher and connect exist subscribers to new publisher ??

ThanX.Yes and no.

Before we begin, a cluster might be a better solution for this case. Either active-active or active-passive will allow you to avoid the down time and the hassle of the move. There is a trade off in terms of the complexity of the cluster, but that still seems like a better choice to me for your situation.

I'd suggest that you check KB #822400 (http://support.microsoft.com/default.aspx?scid=kb;en-us;822400) for more details on Disaster Recovery for SQL Server.

-PatP|||First of all thank you for answering.
Now i have cluster in my environment (Active / Passive ) .I am talking about real disaster - cluster have gone , so i need to move the publisher during minimal time to another location.
Thanx

Change publisher of replication

I have transactional replication on SQL2000 with 60 subscribers.
For disaster recovery procedure i need to establish new replication within 15 minutes on another server with same subscribers.
Can i just confogure another DB as publisher and connect exist subscribers to new publisher ?
ThanX.
This isn't quite so simple. How are you synchronizing with the standby publisher? Are you intending to use 'sync with backup' which ensures the publisher backup is never behind the distributor backup. Will you be restoring earlier copies of the subscriber
to ensure they are not ahead of the distributor? have a look in BOL at "Strategies for Backing Up and Restoring Transactional Replication".
HTH,
Paul Ibison

Change owner of user defined data types?

Hello is there a way to change the owner of a user defined data type in sql2000? If so help is appreciatedCheck this link,

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q327123