collation

Hi,
I have built a server based on a db's collation that I want to load, however
I still receive the 'cannot resolve collation conflict for equal to
operation'.
I have checked the collations of the loaded against the tempdb.
loaded db:
SQL_Latin1_General_CP1_CI_AS
Latin1-General, case-insensitive, accent-sensitive, kanatype-insensitive,
width-insensitive
for Unicode Data, SQL Server Sort Order 52 on Code Page 1252 for non-Unicode
Data
tempdb:
Latin1_General_CI_AS
Latin1-General, case-insensitive, accent-sensitive, kanatype-insensitive,
width-insensitive
I would have thought the above would have been ok?
Does this mean a rebuild of master db to map collation to db?
Thanks.Hi sysbox27,
Definitly not the same! You can:
1. Rebuild you master database to have the same collation as your user
database.
OR
1.Change your user database collation to match the server collation by A)
Using DTS or Alter database, Alter table/alter column (the Alter table/alter
column has many restrictions). The following article describes how the above
can be done:
Article title: How to transfer a database from one collation to another
collation in SQL Server
Article Link:
http://support.microsoft.com/default.aspx?scid=kb;en-us;325335&Product=sql2k
Sasan Saidi
Senior DBA
"sysbox27" wrote:
> Hi,
> I have built a server based on a db's collation that I want to load, however
> I still receive the 'cannot resolve collation conflict for equal to
> operation'.
> I have checked the collations of the loaded against the tempdb.
> loaded db:
> SQL_Latin1_General_CP1_CI_AS
> Latin1-General, case-insensitive, accent-sensitive, kanatype-insensitive,
> width-insensitive
> for Unicode Data, SQL Server Sort Order 52 on Code Page 1252 for non-Unicode
> Data
> tempdb:
> Latin1_General_CI_AS
> Latin1-General, case-insensitive, accent-sensitive, kanatype-insensitive,
> width-insensitive
> I would have thought the above would have been ok?
> Does this mean a rebuild of master db to map collation to db?
> Thanks.|||Hi Sasan,
firstly let me say thanks for the assistance - much appreciated.
in my case I'm quite happy to rebuild server, but my problem is that I don't
see the collation below listed when it comes time to setup:
> > SQL_Latin1_General_CP1_CI_AS
> > Latin1-General, case-insensitive, accent-sensitive, kanatype-insensitive,
> > width-insensitive
> > for Unicode Data, SQL Server Sort Order 52 on Code Page 1252 for non-Unicode
> > Data
so how do I get this collation set?
thanks again.
"Sasan Saidi" wrote:
> Hi sysbox27,
> Definitly not the same! You can:
> 1. Rebuild you master database to have the same collation as your user
> database.
> OR
> 1.Change your user database collation to match the server collation by A)
> Using DTS or Alter database, Alter table/alter column (the Alter table/alter
> column has many restrictions). The following article describes how the above
> can be done:
> Article title: How to transfer a database from one collation to another
> collation in SQL Server
> Article Link:
> http://support.microsoft.com/default.aspx?scid=kb;en-us;325335&Product=sql2k
> Sasan Saidi
> Senior DBA
> "sysbox27" wrote:
> > Hi,
> > I have built a server based on a db's collation that I want to load, however
> > I still receive the 'cannot resolve collation conflict for equal to
> > operation'.
> >
> > I have checked the collations of the loaded against the tempdb.
> > loaded db:
> > SQL_Latin1_General_CP1_CI_AS
> > Latin1-General, case-insensitive, accent-sensitive, kanatype-insensitive,
> > width-insensitive
> > for Unicode Data, SQL Server Sort Order 52 on Code Page 1252 for non-Unicode
> > Data
> >
> > tempdb:
> > Latin1_General_CI_AS
> > Latin1-General, case-insensitive, accent-sensitive, kanatype-insensitive,
> > width-insensitive
> >
> > I would have thought the above would have been ok?
> >
> > Does this mean a rebuild of master db to map collation to db?
> >
> > Thanks.|||If you run the following to see the list of all the collations supported by
Microsoft® SQL Server� 2000:
SELECT * FROM ::fn_helpcollations()
you will see "SQL_Latin1_General_CP1_CI_AS". On my server it is row 706!
Sasan
"sysbox27" wrote:
> Hi Sasan,
> firstly let me say thanks for the assistance - much appreciated.
> in my case I'm quite happy to rebuild server, but my problem is that I don't
> see the collation below listed when it comes time to setup:
> > > SQL_Latin1_General_CP1_CI_AS
> > > Latin1-General, case-insensitive, accent-sensitive, kanatype-insensitive,
> > > width-insensitive
> > > for Unicode Data, SQL Server Sort Order 52 on Code Page 1252 for non-Unicode
> > > Data
> so how do I get this collation set?
> thanks again.
>
>
>
> "Sasan Saidi" wrote:
> > Hi sysbox27,
> >
> > Definitly not the same! You can:
> > 1. Rebuild you master database to have the same collation as your user
> > database.
> > OR
> > 1.Change your user database collation to match the server collation by A)
> > Using DTS or Alter database, Alter table/alter column (the Alter table/alter
> > column has many restrictions). The following article describes how the above
> > can be done:
> >
> > Article title: How to transfer a database from one collation to another
> > collation in SQL Server
> > Article Link:
> > http://support.microsoft.com/default.aspx?scid=kb;en-us;325335&Product=sql2k
> >
> > Sasan Saidi
> > Senior DBA
> >
> > "sysbox27" wrote:
> >
> > > Hi,
> > > I have built a server based on a db's collation that I want to load, however
> > > I still receive the 'cannot resolve collation conflict for equal to
> > > operation'.
> > >
> > > I have checked the collations of the loaded against the tempdb.
> > > loaded db:
> > > SQL_Latin1_General_CP1_CI_AS
> > > Latin1-General, case-insensitive, accent-sensitive, kanatype-insensitive,
> > > width-insensitive
> > > for Unicode Data, SQL Server Sort Order 52 on Code Page 1252 for non-Unicode
> > > Data
> > >
> > > tempdb:
> > > Latin1_General_CI_AS
> > > Latin1-General, case-insensitive, accent-sensitive, kanatype-insensitive,
> > > width-insensitive
> > >
> > > I would have thought the above would have been ok?
> > >
> > > Does this mean a rebuild of master db to map collation to db?
> > >
> > > Thanks.|||Sasan,
right I see it in the list, but when I create a new server instance I don't
see that collation listed. how do I now go about changing the collation to
what I want or even building a new server with the collation mentioned below?
many thanks.
"Sasan Saidi" wrote:
> If you run the following to see the list of all the collations supported by
> Microsoft® SQL Server� 2000:
> SELECT * FROM ::fn_helpcollations()
> you will see "SQL_Latin1_General_CP1_CI_AS". On my server it is row 706!
> Sasan
> "sysbox27" wrote:
> > Hi Sasan,
> > firstly let me say thanks for the assistance - much appreciated.
> > in my case I'm quite happy to rebuild server, but my problem is that I don't
> > see the collation below listed when it comes time to setup:
> >
> > > > SQL_Latin1_General_CP1_CI_AS
> > > > Latin1-General, case-insensitive, accent-sensitive, kanatype-insensitive,
> > > > width-insensitive
> > > > for Unicode Data, SQL Server Sort Order 52 on Code Page 1252 for non-Unicode
> > > > Data
> >
> > so how do I get this collation set?
> >
> > thanks again.
> >
> >
> >
> >
> >
> >
> >
> > "Sasan Saidi" wrote:
> >
> > > Hi sysbox27,
> > >
> > > Definitly not the same! You can:
> > > 1. Rebuild you master database to have the same collation as your user
> > > database.
> > > OR
> > > 1.Change your user database collation to match the server collation by A)
> > > Using DTS or Alter database, Alter table/alter column (the Alter table/alter
> > > column has many restrictions). The following article describes how the above
> > > can be done:
> > >
> > > Article title: How to transfer a database from one collation to another
> > > collation in SQL Server
> > > Article Link:
> > > http://support.microsoft.com/default.aspx?scid=kb;en-us;325335&Product=sql2k
> > >
> > > Sasan Saidi
> > > Senior DBA
> > >
> > > "sysbox27" wrote:
> > >
> > > > Hi,
> > > > I have built a server based on a db's collation that I want to load, however
> > > > I still receive the 'cannot resolve collation conflict for equal to
> > > > operation'.
> > > >
> > > > I have checked the collations of the loaded against the tempdb.
> > > > loaded db:
> > > > SQL_Latin1_General_CP1_CI_AS
> > > > Latin1-General, case-insensitive, accent-sensitive, kanatype-insensitive,
> > > > width-insensitive
> > > > for Unicode Data, SQL Server Sort Order 52 on Code Page 1252 for non-Unicode
> > > > Data
> > > >
> > > > tempdb:
> > > > Latin1_General_CI_AS
> > > > Latin1-General, case-insensitive, accent-sensitive, kanatype-insensitive,
> > > > width-insensitive
> > > >
> > > > I would have thought the above would have been ok?
> > > >
> > > > Does this mean a rebuild of master db to map collation to db?
> > > >
> > > > Thanks.|||sysbox27,
Do a custom setup to see the collation dialog. On this dialog you'll want
to select the "SQL Collations" radio button (the other will be "Windows
Collations"). This will enable a drop down listbox at the bottom of the
form. In this listbox you should select "Dictionary order case insensitive
for use with the 1252 character set". On a U.S. English system this is the
default SQL collation, so you may not need to hunt for it in the list.
HTH,
Bart
--
Bart Duncan
Microsoft SQL Server Support
Please reply to the newsgroup only - thanks.
This posting is provided "AS IS" with no warranties, and confers no rights.
| Thread-Topic: collation
| thread-index: AcUYZ0SE2quK7560RG6lTeGqz6LsZg==| X-WBNR-Posting-Host: 82.35.233.73
| From: "=?Utf-8?B?c3lzYm94Mjc=?=" <sysbox27@.discussions.microsoft.com>
| References: <DBFB1E09-6BD0-4C1B-B012-1462AB8E7702@.microsoft.com>
<1A456C86-B4B3-49EC-9A51-6D92834B27FB@.microsoft.com>
<11CDF551-ED2B-436E-A3C2-29FCFC714607@.microsoft.com>
<BED1A525-DD68-4664-9504-9D0C1C2A6AB9@.microsoft.com>
| Subject: RE: collation
| Date: Mon, 21 Feb 2005 14:47:06 -0800
| Lines: 85
| Message-ID: <5A7D9817-DC47-4C23-B4AF-CADBA218F707@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 8bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.server
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
| Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.server:378854
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| Sasan,
| right I see it in the list, but when I create a new server instance I
don't
| see that collation listed. how do I now go about changing the collation
to
| what I want or even building a new server with the collation mentioned
below?
| many thanks.
|
| "Sasan Saidi" wrote:
|
| > If you run the following to see the list of all the collations
supported by
| > Microsoft® SQL Server� 2000:
| >
| > SELECT * FROM ::fn_helpcollations()
| >
| > you will see "SQL_Latin1_General_CP1_CI_AS". On my server it is row 706!
| >
| > Sasan
| > "sysbox27" wrote:
| >
| > > Hi Sasan,
| > > firstly let me say thanks for the assistance - much appreciated.
| > > in my case I'm quite happy to rebuild server, but my problem is that
I don't
| > > see the collation below listed when it comes time to setup:
| > >
| > > > > SQL_Latin1_General_CP1_CI_AS
| > > > > Latin1-General, case-insensitive, accent-sensitive,
kanatype-insensitive,
| > > > > width-insensitive
| > > > > for Unicode Data, SQL Server Sort Order 52 on Code Page 1252 for
non-Unicode
| > > > > Data
| > >
| > > so how do I get this collation set?
| > >
| > > thanks again.
| > >
| > >
| > >
| > >
| > >
| > >
| > >
| > > "Sasan Saidi" wrote:
| > >
| > > > Hi sysbox27,
| > > >
| > > > Definitly not the same! You can:
| > > > 1. Rebuild you master database to have the same collation as your
user
| > > > database.
| > > > OR
| > > > 1.Change your user database collation to match the server collation
by A)
| > > > Using DTS or Alter database, Alter table/alter column (the Alter
table/alter
| > > > column has many restrictions). The following article describes how
the above
| > > > can be done:
| > > >
| > > > Article title: How to transfer a database from one collation to
another
| > > > collation in SQL Server
| > > > Article Link:
| > > >
http://support.microsoft.com/default.aspx?scid=kb;en-us;325335&Product=sql2k
| > > >
| > > > Sasan Saidi
| > > > Senior DBA
| > > >
| > > > "sysbox27" wrote:
| > > >
| > > > > Hi,
| > > > > I have built a server based on a db's collation that I want to
load, however
| > > > > I still receive the 'cannot resolve collation conflict for equal
to
| > > > > operation'.
| > > > >
| > > > > I have checked the collations of the loaded against the tempdb.
| > > > > loaded db:
| > > > > SQL_Latin1_General_CP1_CI_AS
| > > > > Latin1-General, case-insensitive, accent-sensitive,
kanatype-insensitive,
| > > > > width-insensitive
| > > > > for Unicode Data, SQL Server Sort Order 52 on Code Page 1252 for
non-Unicode
| > > > > Data
| > > > >
| > > > > tempdb:
| > > > > Latin1_General_CI_AS
| > > > > Latin1-General, case-insensitive, accent-sensitive,
kanatype-insensitive,
| > > > > width-insensitive
| > > > >
| > > > > I would have thought the above would have been ok?
| > > > >
| > > > > Does this mean a rebuild of master db to map collation to db?
| > > > >
| > > > > Thanks.
||||Thank you Bart & Sasan for your help.
Regards.
"Bart Duncan [MSFT]" wrote:
> sysbox27,
> Do a custom setup to see the collation dialog. On this dialog you'll want
> to select the "SQL Collations" radio button (the other will be "Windows
> Collations"). This will enable a drop down listbox at the bottom of the
> form. In this listbox you should select "Dictionary order case insensitive
> for use with the 1252 character set". On a U.S. English system this is the
> default SQL collation, so you may not need to hunt for it in the list.
> HTH,
> Bart
> --
> Bart Duncan
> Microsoft SQL Server Support
> Please reply to the newsgroup only - thanks.
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> --
> | Thread-Topic: collation
> | thread-index: AcUYZ0SE2quK7560RG6lTeGqz6LsZg==> | X-WBNR-Posting-Host: 82.35.233.73
> | From: "=?Utf-8?B?c3lzYm94Mjc=?=" <sysbox27@.discussions.microsoft.com>
> | References: <DBFB1E09-6BD0-4C1B-B012-1462AB8E7702@.microsoft.com>
> <1A456C86-B4B3-49EC-9A51-6D92834B27FB@.microsoft.com>
> <11CDF551-ED2B-436E-A3C2-29FCFC714607@.microsoft.com>
> <BED1A525-DD68-4664-9504-9D0C1C2A6AB9@.microsoft.com>
> | Subject: RE: collation
> | Date: Mon, 21 Feb 2005 14:47:06 -0800
> | Lines: 85
> | Message-ID: <5A7D9817-DC47-4C23-B4AF-CADBA218F707@.microsoft.com>
> | MIME-Version: 1.0
> | Content-Type: text/plain;
> | charset="Utf-8"
> | Content-Transfer-Encoding: 8bit
> | X-Newsreader: Microsoft CDO for Windows 2000
> | Content-Class: urn:content-classes:message
> | Importance: normal
> | Priority: normal
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> | Newsgroups: microsoft.public.sqlserver.server
> | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
> | Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
> | Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.server:378854
> | X-Tomcat-NG: microsoft.public.sqlserver.server
> |
> | Sasan,
> | right I see it in the list, but when I create a new server instance I
> don't
> | see that collation listed. how do I now go about changing the collation
> to
> | what I want or even building a new server with the collation mentioned
> below?
> | many thanks.
> |
> | "Sasan Saidi" wrote:
> |
> | > If you run the following to see the list of all the collations
> supported by
> | > MicrosoftÃ?® SQL Serverââ'¢ 2000:
> | >
> | > SELECT * FROM ::fn_helpcollations()
> | >
> | > you will see "SQL_Latin1_General_CP1_CI_AS". On my server it is row 706!
> | >
> | > Sasan
> | > "sysbox27" wrote:
> | >
> | > > Hi Sasan,
> | > > firstly let me say thanks for the assistance - much appreciated.
> | > > in my case I'm quite happy to rebuild server, but my problem is that
> I don't
> | > > see the collation below listed when it comes time to setup:
> | > >
> | > > > > SQL_Latin1_General_CP1_CI_AS
> | > > > > Latin1-General, case-insensitive, accent-sensitive,
> kanatype-insensitive,
> | > > > > width-insensitive
> | > > > > for Unicode Data, SQL Server Sort Order 52 on Code Page 1252 for
> non-Unicode
> | > > > > Data
> | > >
> | > > so how do I get this collation set?
> | > >
> | > > thanks again.
> | > >
> | > >
> | > >
> | > >
> | > >
> | > >
> | > >
> | > > "Sasan Saidi" wrote:
> | > >
> | > > > Hi sysbox27,
> | > > >
> | > > > Definitly not the same! You can:
> | > > > 1. Rebuild you master database to have the same collation as your
> user
> | > > > database.
> | > > > OR
> | > > > 1.Change your user database collation to match the server collation
> by A)
> | > > > Using DTS or Alter database, Alter table/alter column (the Alter
> table/alter
> | > > > column has many restrictions). The following article describes how
> the above
> | > > > can be done:
> | > > >
> | > > > Article title: How to transfer a database from one collation to
> another
> | > > > collation in SQL Server
> | > > > Article Link:
> | > > >
> http://support.microsoft.com/default.aspx?scid=kb;en-us;325335&Product=sql2k
> | > > >
> | > > > Sasan Saidi
> | > > > Senior DBA
> | > > >
> | > > > "sysbox27" wrote:
> | > > >
> | > > > > Hi,
> | > > > > I have built a server based on a db's collation that I want to
> load, however
> | > > > > I still receive the 'cannot resolve collation conflict for equal
> to
> | > > > > operation'.
> | > > > >
> | > > > > I have checked the collations of the loaded against the tempdb.
> | > > > > loaded db:
> | > > > > SQL_Latin1_General_CP1_CI_AS
> | > > > > Latin1-General, case-insensitive, accent-sensitive,
> kanatype-insensitive,
> | > > > > width-insensitive
> | > > > > for Unicode Data, SQL Server Sort Order 52 on Code Page 1252 for
> non-Unicode
> | > > > > Data
> | > > > >
> | > > > > tempdb:
> | > > > > Latin1_General_CI_AS
> | > > > > Latin1-General, case-insensitive, accent-sensitive,
> kanatype-insensitive,
> | > > > > width-insensitive
> | > > > >
> | > > > > I would have thought the above would have been ok?
> | > > > >
> | > > > > Does this mean a rebuild of master db to map collation to db?
> | > > > >
> | > > > > Thanks.
> |
>

collation

Hi,
I have built a server based on a db's collation that I want to load, however
I still receive the 'cannot resolve collation conflict for equal to
operation'.
I have checked the collations of the loaded against the tempdb.
loaded db:
SQL_Latin1_General_CP1_CI_AS
Latin1-General, case-insensitive, accent-sensitive, kanatype-insensitive,
width-insensitive
for Unicode Data, SQL Server Sort Order 52 on Code Page 1252 for non-Unicode
Data
tempdb:
Latin1_General_CI_AS
Latin1-General, case-insensitive, accent-sensitive, kanatype-insensitive,
width-insensitive
I would have thought the above would have been ok?
Does this mean a rebuild of master db to map collation to db?
Thanks.
Hi sysbox27,
Definitly not the same! You can:
1. Rebuild you master database to have the same collation as your user
database.
OR
1.Change your user database collation to match the server collation by A)
Using DTS or Alter database, Alter table/alter column (the Alter table/alter
column has many restrictions). The following article describes how the above
can be done:
Article title: How to transfer a database from one collation to another
collation in SQL Server
Article Link:
http://support.microsoft.com/default...&Product=sql2k
Sasan Saidi
Senior DBA
"sysbox27" wrote:

> Hi,
> I have built a server based on a db's collation that I want to load, however
> I still receive the 'cannot resolve collation conflict for equal to
> operation'.
> I have checked the collations of the loaded against the tempdb.
> loaded db:
> SQL_Latin1_General_CP1_CI_AS
> Latin1-General, case-insensitive, accent-sensitive, kanatype-insensitive,
> width-insensitive
> for Unicode Data, SQL Server Sort Order 52 on Code Page 1252 for non-Unicode
> Data
> tempdb:
> Latin1_General_CI_AS
> Latin1-General, case-insensitive, accent-sensitive, kanatype-insensitive,
> width-insensitive
> I would have thought the above would have been ok?
> Does this mean a rebuild of master db to map collation to db?
> Thanks.
|||Hi Sasan,
firstly let me say thanks for the assistance - much appreciated.
in my case I'm quite happy to rebuild server, but my problem is that I don't
see the collation below listed when it comes time to setup:
[vbcol=seagreen]
so how do I get this collation set?
thanks again.
"Sasan Saidi" wrote:
[vbcol=seagreen]
> Hi sysbox27,
> Definitly not the same! You can:
> 1. Rebuild you master database to have the same collation as your user
> database.
> OR
> 1.Change your user database collation to match the server collation by A)
> Using DTS or Alter database, Alter table/alter column (the Alter table/alter
> column has many restrictions). The following article describes how the above
> can be done:
> Article title: How to transfer a database from one collation to another
> collation in SQL Server
> Article Link:
> http://support.microsoft.com/default...&Product=sql2k
> Sasan Saidi
> Senior DBA
> "sysbox27" wrote:
|||If you run the following to see the list of all the collations supported by
Microsoft? SQL Server? 2000:
SELECT * FROM ::fn_helpcollations()
you will see "SQL_Latin1_General_CP1_CI_AS". On my server it is row 706!
Sasan
"sysbox27" wrote:
[vbcol=seagreen]
> Hi Sasan,
> firstly let me say thanks for the assistance - much appreciated.
> in my case I'm quite happy to rebuild server, but my problem is that I don't
> see the collation below listed when it comes time to setup:
>
> so how do I get this collation set?
> thanks again.
>
>
>
> "Sasan Saidi" wrote:
|||Sasan,
right I see it in the list, but when I create a new server instance I don't
see that collation listed. how do I now go about changing the collation to
what I want or even building a new server with the collation mentioned below?
many thanks.
"Sasan Saidi" wrote:
[vbcol=seagreen]
> If you run the following to see the list of all the collations supported by
> Microsoft? SQL Server? 2000:
> SELECT * FROM ::fn_helpcollations()
> you will see "SQL_Latin1_General_CP1_CI_AS". On my server it is row 706!
> Sasan
> "sysbox27" wrote:
|||sysbox27,
Do a custom setup to see the collation dialog. On this dialog you'll want
to select the "SQL Collations" radio button (the other will be "Windows
Collations"). This will enable a drop down listbox at the bottom of the
form. In this listbox you should select "Dictionary order case insensitive
for use with the 1252 character set". On a U.S. English system this is the
default SQL collation, so you may not need to hunt for it in the list.
HTH,
Bart
Bart Duncan
Microsoft SQL Server Support
Please reply to the newsgroup only - thanks.
This posting is provided "AS IS" with no warranties, and confers no rights.
| Thread-Topic: collation
| thread-index: AcUYZ0SE2quK7560RG6lTeGqz6LsZg==
| X-WBNR-Posting-Host: 82.35.233.73
| From: "=?Utf-8?B?c3lzYm94Mjc=?=" <sysbox27@.discussions.microsoft.com>
| References: <DBFB1E09-6BD0-4C1B-B012-1462AB8E7702@.microsoft.com>
<1A456C86-B4B3-49EC-9A51-6D92834B27FB@.microsoft.com>
<11CDF551-ED2B-436E-A3C2-29FCFC714607@.microsoft.com>
<BED1A525-DD68-4664-9504-9D0C1C2A6AB9@.microsoft.com>
| Subject: RE: collation
| Date: Mon, 21 Feb 2005 14:47:06 -0800
| Lines: 85
| Message-ID: <5A7D9817-DC47-4C23-B4AF-CADBA218F707@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 8bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.server
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
| Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSF TNGXA03.phx.gbl
| Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.server:378854
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| Sasan,
| right I see it in the list, but when I create a new server instance I
don't
| see that collation listed. how do I now go about changing the collation
to
| what I want or even building a new server with the collation mentioned
below?
| many thanks.
|
| "Sasan Saidi" wrote:
|
| > If you run the following to see the list of all the collations
supported by
| > Microsoft? SQL Server? 2000:
| >
| > SELECT * FROM ::fn_helpcollations()
| >
| > you will see "SQL_Latin1_General_CP1_CI_AS". On my server it is row 706!
| >
| > Sasan
| > "sysbox27" wrote:
| >
| > > Hi Sasan,
| > > firstly let me say thanks for the assistance - much appreciated.
| > > in my case I'm quite happy to rebuild server, but my problem is that
I don't
| > > see the collation below listed when it comes time to setup:
| > >
| > > > > SQL_Latin1_General_CP1_CI_AS
| > > > > Latin1-General, case-insensitive, accent-sensitive,
kanatype-insensitive,
| > > > > width-insensitive
| > > > > for Unicode Data, SQL Server Sort Order 52 on Code Page 1252 for
non-Unicode
| > > > > Data
| > >
| > > so how do I get this collation set?
| > >
| > > thanks again.
| > >
| > >
| > >
| > >
| > >
| > >
| > >
| > > "Sasan Saidi" wrote:
| > >
| > > > Hi sysbox27,
| > > >
| > > > Definitly not the same! You can:
| > > > 1. Rebuild you master database to have the same collation as your
user
| > > > database.
| > > > OR
| > > > 1.Change your user database collation to match the server collation
by A)
| > > > Using DTS or Alter database, Alter table/alter column (the Alter
table/alter
| > > > column has many restrictions). The following article describes how
the above
| > > > can be done:
| > > >
| > > > Article title: How to transfer a database from one collation to
another
| > > > collation in SQL Server
| > > > Article Link:
| > > >
http://support.microsoft.com/default...&Product=sql2k
| > > >
| > > > Sasan Saidi
| > > > Senior DBA
| > > >
| > > > "sysbox27" wrote:
| > > >
| > > > > Hi,
| > > > > I have built a server based on a db's collation that I want to
load, however
| > > > > I still receive the 'cannot resolve collation conflict for equal
to
| > > > > operation'.
| > > > >
| > > > > I have checked the collations of the loaded against the tempdb.
| > > > > loaded db:
| > > > > SQL_Latin1_General_CP1_CI_AS
| > > > > Latin1-General, case-insensitive, accent-sensitive,
kanatype-insensitive,
| > > > > width-insensitive
| > > > > for Unicode Data, SQL Server Sort Order 52 on Code Page 1252 for
non-Unicode
| > > > > Data
| > > > >
| > > > > tempdb:
| > > > > Latin1_General_CI_AS
| > > > > Latin1-General, case-insensitive, accent-sensitive,
kanatype-insensitive,
| > > > > width-insensitive
| > > > >
| > > > > I would have thought the above would have been ok?
| > > > >
| > > > > Does this mean a rebuild of master db to map collation to db?
| > > > >
| > > > > Thanks.
|
|||Thank you Bart & Sasan for your help.
Regards.
"Bart Duncan [MSFT]" wrote:

> sysbox27,
> Do a custom setup to see the collation dialog. On this dialog you'll want
> to select the "SQL Collations" radio button (the other will be "Windows
> Collations"). This will enable a drop down listbox at the bottom of the
> form. In this listbox you should select "Dictionary order case insensitive
> for use with the 1252 character set". On a U.S. English system this is the
> default SQL collation, so you may not need to hunt for it in the list.
> HTH,
> Bart
> --
> Bart Duncan
> Microsoft SQL Server Support
> Please reply to the newsgroup only - thanks.
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> --
> | Thread-Topic: collation
> | thread-index: AcUYZ0SE2quK7560RG6lTeGqz6LsZg==
> | X-WBNR-Posting-Host: 82.35.233.73
> | From: "=?Utf-8?B?c3lzYm94Mjc=?=" <sysbox27@.discussions.microsoft.com>
> | References: <DBFB1E09-6BD0-4C1B-B012-1462AB8E7702@.microsoft.com>
> <1A456C86-B4B3-49EC-9A51-6D92834B27FB@.microsoft.com>
> <11CDF551-ED2B-436E-A3C2-29FCFC714607@.microsoft.com>
> <BED1A525-DD68-4664-9504-9D0C1C2A6AB9@.microsoft.com>
> | Subject: RE: collation
> | Date: Mon, 21 Feb 2005 14:47:06 -0800
> | Lines: 85
> | Message-ID: <5A7D9817-DC47-4C23-B4AF-CADBA218F707@.microsoft.com>
> | MIME-Version: 1.0
> | Content-Type: text/plain;
> | charset="Utf-8"
> | Content-Transfer-Encoding: 8bit
> | X-Newsreader: Microsoft CDO for Windows 2000
> | Content-Class: urn:content-classes:message
> | Importance: normal
> | Priority: normal
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> | Newsgroups: microsoft.public.sqlserver.server
> | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
> | Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSF TNGXA03.phx.gbl
> | Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.server:378854
> | X-Tomcat-NG: microsoft.public.sqlserver.server
> |
> | Sasan,
> | right I see it in the list, but when I create a new server instance I
> don't
> | see that collation listed. how do I now go about changing the collation
> to
> | what I want or even building a new server with the collation mentioned
> below?
> | many thanks.
> |
> | "Sasan Saidi" wrote:
> |
> | > If you run the following to see the list of all the collations
> supported by
> | > Microsoft?? SQL Servera?￠ 2000:
> | >
> | > SELECT * FROM ::fn_helpcollations()
> | >
> | > you will see "SQL_Latin1_General_CP1_CI_AS". On my server it is row 706!
> | >
> | > Sasan
> | > "sysbox27" wrote:
> | >
> | > > Hi Sasan,
> | > > firstly let me say thanks for the assistance - much appreciated.
> | > > in my case I'm quite happy to rebuild server, but my problem is that
> I don't
> | > > see the collation below listed when it comes time to setup:
> | > >
> | > > > > SQL_Latin1_General_CP1_CI_AS
> | > > > > Latin1-General, case-insensitive, accent-sensitive,
> kanatype-insensitive,
> | > > > > width-insensitive
> | > > > > for Unicode Data, SQL Server Sort Order 52 on Code Page 1252 for
> non-Unicode
> | > > > > Data
> | > >
> | > > so how do I get this collation set?
> | > >
> | > > thanks again.
> | > >
> | > >
> | > >
> | > >
> | > >
> | > >
> | > >
> | > > "Sasan Saidi" wrote:
> | > >
> | > > > Hi sysbox27,
> | > > >
> | > > > Definitly not the same! You can:
> | > > > 1. Rebuild you master database to have the same collation as your
> user
> | > > > database.
> | > > > OR
> | > > > 1.Change your user database collation to match the server collation
> by A)
> | > > > Using DTS or Alter database, Alter table/alter column (the Alter
> table/alter
> | > > > column has many restrictions). The following article describes how
> the above
> | > > > can be done:
> | > > >
> | > > > Article title: How to transfer a database from one collation to
> another
> | > > > collation in SQL Server
> | > > > Article Link:
> | > > >
> http://support.microsoft.com/default...&Product=sql2k
> | > > >
> | > > > Sasan Saidi
> | > > > Senior DBA
> | > > >
> | > > > "sysbox27" wrote:
> | > > >
> | > > > > Hi,
> | > > > > I have built a server based on a db's collation that I want to
> load, however
> | > > > > I still receive the 'cannot resolve collation conflict for equal
> to
> | > > > > operation'.
> | > > > >
> | > > > > I have checked the collations of the loaded against the tempdb.
> | > > > > loaded db:
> | > > > > SQL_Latin1_General_CP1_CI_AS
> | > > > > Latin1-General, case-insensitive, accent-sensitive,
> kanatype-insensitive,
> | > > > > width-insensitive
> | > > > > for Unicode Data, SQL Server Sort Order 52 on Code Page 1252 for
> non-Unicode
> | > > > > Data
> | > > > >
> | > > > > tempdb:
> | > > > > Latin1_General_CI_AS
> | > > > > Latin1-General, case-insensitive, accent-sensitive,
> kanatype-insensitive,
> | > > > > width-insensitive
> | > > > >
> | > > > > I would have thought the above would have been ok?
> | > > > >
> | > > > > Does this mean a rebuild of master db to map collation to db?
> | > > > >
> | > > > > Thanks.
> |
>

collation

Hi,
I have built a server based on a db's collation that I want to load, however
I still receive the 'cannot resolve collation conflict for equal to
operation'.
I have checked the collations of the loaded against the tempdb.
loaded db:
SQL_Latin1_General_CP1_CI_AS
Latin1-General, case-insensitive, accent-sensitive, kanatype-insensitive,
width-insensitive
for Unicode Data, SQL Server Sort Order 52 on Code Page 1252 for non-Unicode
Data
tempdb:
Latin1_General_CI_AS
Latin1-General, case-insensitive, accent-sensitive, kanatype-insensitive,
width-insensitive
I would have thought the above would have been ok?
Does this mean a rebuild of master db to map collation to db?
Thanks.Hi sysbox27,
Definitly not the same! You can:
1. Rebuild you master database to have the same collation as your user
database.
OR
1.Change your user database collation to match the server collation by A)
Using DTS or Alter database, Alter table/alter column (the Alter table/alter
column has many restrictions). The following article describes how the above
can be done:
Article title: How to transfer a database from one collation to another
collation in SQL Server
Article Link:
http://support.microsoft.com/defaul...5&Product=sql2k
Sasan Saidi
Senior DBA
"sysbox27" wrote:

> Hi,
> I have built a server based on a db's collation that I want to load, howev
er
> I still receive the 'cannot resolve collation conflict for equal to
> operation'.
> I have checked the collations of the loaded against the tempdb.
> loaded db:
> SQL_Latin1_General_CP1_CI_AS
> Latin1-General, case-insensitive, accent-sensitive, kanatype-insensitive,
> width-insensitive
> for Unicode Data, SQL Server Sort Order 52 on Code Page 1252 for non-Unico
de
> Data
> tempdb:
> Latin1_General_CI_AS
> Latin1-General, case-insensitive, accent-sensitive, kanatype-insensitive,
> width-insensitive
> I would have thought the above would have been ok?
> Does this mean a rebuild of master db to map collation to db?
> Thanks.|||Hi Sasan,
firstly let me say thanks for the assistance - much appreciated.
in my case I'm quite happy to rebuild server, but my problem is that I don't
see the collation below listed when it comes time to setup:
[vbcol=seagreen]
so how do I get this collation set?
thanks again.
"Sasan Saidi" wrote:
[vbcol=seagreen]
> Hi sysbox27,
> Definitly not the same! You can:
> 1. Rebuild you master database to have the same collation as your user
> database.
> OR
> 1.Change your user database collation to match the server collation by A)
> Using DTS or Alter database, Alter table/alter column (the Alter table/alt
er
> column has many restrictions). The following article describes how the abo
ve
> can be done:
> Article title: How to transfer a database from one collation to another
> collation in SQL Server
> Article Link:
> [url]http://support.microsoft.com/default.aspx?scid=kb;en-us;325335&Product=sql2k[/ur
l]
> Sasan Saidi
> Senior DBA
> "sysbox27" wrote:
>|||If you run the following to see the list of all the collations supported by
Microsoft? SQL Server? 2000:
SELECT * FROM ::fn_helpcollations()
you will see "SQL_Latin1_General_CP1_CI_AS". On my server it is row 706!
Sasan
"sysbox27" wrote:
[vbcol=seagreen]
> Hi Sasan,
> firstly let me say thanks for the assistance - much appreciated.
> in my case I'm quite happy to rebuild server, but my problem is that I don
't
> see the collation below listed when it comes time to setup:
>
> so how do I get this collation set?
> thanks again.
>
>
>
> "Sasan Saidi" wrote:
>|||Sasan,
right I see it in the list, but when I create a new server instance I don't
see that collation listed. how do I now go about changing the collation to
what I want or even building a new server with the collation mentioned below
?
many thanks.
"Sasan Saidi" wrote:
[vbcol=seagreen]
> If you run the following to see the list of all the collations supported b
y
> Microsoft? SQL Server? 2000:
> SELECT * FROM ::fn_helpcollations()
> you will see "SQL_Latin1_General_CP1_CI_AS". On my server it is row 706!
> Sasan
> "sysbox27" wrote:
>|||sysbox27,
Do a custom setup to see the collation dialog. On this dialog you'll want
to select the "SQL Collations" radio button (the other will be "Windows
Collations"). This will enable a drop down listbox at the bottom of the
form. In this listbox you should select "Dictionary order case insensitive
for use with the 1252 character set". On a U.S. English system this is the
default SQL collation, so you may not need to hunt for it in the list.
HTH,
Bart
--
Bart Duncan
Microsoft SQL Server Support
Please reply to the newsgroup only - thanks.
This posting is provided "AS IS" with no warranties, and confers no rights.
| Thread-Topic: collation
| thread-index: AcUYZ0SE2quK7560RG6lTeGqz6LsZg==
| X-WBNR-Posting-Host: 82.35.233.73
| From: "examnotes" <sysbox27@.discussions.microsoft.com>
| References: <DBFB1E09-6BD0-4C1B-B012-1462AB8E7702@.microsoft.com>
<1A456C86-B4B3-49EC-9A51-6D92834B27FB@.microsoft.com>
<11CDF551-ED2B-436E-A3C2-29FCFC714607@.microsoft.com>
<BED1A525-DD68-4664-9504-9D0C1C2A6AB9@.microsoft.com>
| Subject: RE: collation
| Date: Mon, 21 Feb 2005 14:47:06 -0800
| Lines: 85
| Message-ID: <5A7D9817-DC47-4C23-B4AF-CADBA218F707@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 8bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.server
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
| Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.server:378854
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| Sasan,
| right I see it in the list, but when I create a new server instance I
don't
| see that collation listed. how do I now go about changing the collation
to
| what I want or even building a new server with the collation mentioned
below?
| many thanks.
|
| "Sasan Saidi" wrote:
|
| > If you run the following to see the list of all the collations
supported by
| > Microsoft? SQL Server? 2000:
| >
| > SELECT * FROM ::fn_helpcollations()
| >
| > you will see "SQL_Latin1_General_CP1_CI_AS". On my server it is row 706!
| >
| > Sasan
| > "sysbox27" wrote:
| >
| > > Hi Sasan,
| > > firstly let me say thanks for the assistance - much appreciated.
| > > in my case I'm quite happy to rebuild server, but my problem is that
I don't
| > > see the collation below listed when it comes time to setup:
| > >
| > > > > SQL_Latin1_General_CP1_CI_AS
| > > > > Latin1-General, case-insensitive, accent-sensitive,
kanatype-insensitive,
| > > > > width-insensitive
| > > > > for Unicode Data, SQL Server Sort Order 52 on Code Page 1252 for
non-Unicode
| > > > > Data
| > >
| > > so how do I get this collation set?
| > >
| > > thanks again.
| > >
| > >
| > >
| > >
| > >
| > >
| > >
| > > "Sasan Saidi" wrote:
| > >
| > > > Hi sysbox27,
| > > >
| > > > Definitly not the same! You can:
| > > > 1. Rebuild you master database to have the same collation as your
user
| > > > database.
| > > > OR
| > > > 1.Change your user database collation to match the server collation
by A)
| > > > Using DTS or Alter database, Alter table/alter column (the Alter
table/alter
| > > > column has many restrictions). The following article describes how
the above
| > > > can be done:
| > > >
| > > > Article title: How to transfer a database from one collation to
another
| > > > collation in SQL Server
| > > > Article Link:
| > > >
http://support.microsoft.com/defaul...5&Product=sql2k
| > > >
| > > > Sasan Saidi
| > > > Senior DBA
| > > >
| > > > "sysbox27" wrote:
| > > >
| > > > > Hi,
| > > > > I have built a server based on a db's collation that I want to
load, however
| > > > > I still receive the 'cannot resolve collation conflict for equal
to
| > > > > operation'.
| > > > >
| > > > > I have checked the collations of the loaded against the tempdb.
| > > > > loaded db:
| > > > > SQL_Latin1_General_CP1_CI_AS
| > > > > Latin1-General, case-insensitive, accent-sensitive,
kanatype-insensitive,
| > > > > width-insensitive
| > > > > for Unicode Data, SQL Server Sort Order 52 on Code Page 1252 for
non-Unicode
| > > > > Data
| > > > >
| > > > > tempdb:
| > > > > Latin1_General_CI_AS
| > > > > Latin1-General, case-insensitive, accent-sensitive,
kanatype-insensitive,
| > > > > width-insensitive
| > > > >
| > > > > I would have thought the above would have been ok?
| > > > >
| > > > > Does this mean a rebuild of master db to map collation to db?
| > > > >
| > > > > Thanks.
||||Thank you Bart & Sasan for your help.
Regards.
"Bart Duncan [MSFT]" wrote:

> sysbox27,
> Do a custom setup to see the collation dialog. On this dialog you'll want
> to select the "SQL Collations" radio button (the other will be "Windows
> Collations"). This will enable a drop down listbox at the bottom of the
> form. In this listbox you should select "Dictionary order case insensitiv
e
> for use with the 1252 character set". On a U.S. English system this is th
e
> default SQL collation, so you may not need to hunt for it in the list.
> HTH,
> Bart
> --
> Bart Duncan
> Microsoft SQL Server Support
> Please reply to the newsgroup only - thanks.
> This posting is provided "AS IS" with no warranties, and confers no rights
.
>
> --
> | Thread-Topic: collation
> | thread-index: AcUYZ0SE2quK7560RG6lTeGqz6LsZg==
> | X-WBNR-Posting-Host: 82.35.233.73
> | From: "examnotes" <sysbox27@.discussions.microsoft.com>
> | References: <DBFB1E09-6BD0-4C1B-B012-1462AB8E7702@.microsoft.com>
> <1A456C86-B4B3-49EC-9A51-6D92834B27FB@.microsoft.com>
> <11CDF551-ED2B-436E-A3C2-29FCFC714607@.microsoft.com>
> <BED1A525-DD68-4664-9504-9D0C1C2A6AB9@.microsoft.com>
> | Subject: RE: collation
> | Date: Mon, 21 Feb 2005 14:47:06 -0800
> | Lines: 85
> | Message-ID: <5A7D9817-DC47-4C23-B4AF-CADBA218F707@.microsoft.com>
> | MIME-Version: 1.0
> | Content-Type: text/plain;
> | charset="Utf-8"
> | Content-Transfer-Encoding: 8bit
> | X-Newsreader: Microsoft CDO for Windows 2000
> | Content-Class: urn:content-classes:message
> | Importance: normal
> | Priority: normal
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> | Newsgroups: microsoft.public.sqlserver.server
> | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
> | Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
> | Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.server:378854
> | X-Tomcat-NG: microsoft.public.sqlserver.server
> |
> | Sasan,
> | right I see it in the list, but when I create a new server instance I
> don't
> | see that collation listed. how do I now go about changing the collation
> to
> | what I want or even building a new server with the collation mentioned
> below?
> | many thanks.
> |
> | "Sasan Saidi" wrote:
> |
> | > If you run the following to see the list of all the collations
> supported by
> | > Microsoft?? SQL Servera?￠ 2000:
> | >
> | > SELECT * FROM ::fn_helpcollations()
> | >
> | > you will see "SQL_Latin1_General_CP1_CI_AS". On my server it is row 70
6!
> | >
> | > Sasan
> | > "sysbox27" wrote:
> | >
> | > > Hi Sasan,
> | > > firstly let me say thanks for the assistance - much appreciated.
> | > > in my case I'm quite happy to rebuild server, but my problem is that
> I don't
> | > > see the collation below listed when it comes time to setup:
> | > >
> | > > > > SQL_Latin1_General_CP1_CI_AS
> | > > > > Latin1-General, case-insensitive, accent-sensitive,
> kanatype-insensitive,
> | > > > > width-insensitive
> | > > > > for Unicode Data, SQL Server Sort Order 52 on Code Page 1252 for
> non-Unicode
> | > > > > Data
> | > >
> | > > so how do I get this collation set?
> | > >
> | > > thanks again.
> | > >
> | > >
> | > >
> | > >
> | > >
> | > >
> | > >
> | > > "Sasan Saidi" wrote:
> | > >
> | > > > Hi sysbox27,
> | > > >
> | > > > Definitly not the same! You can:
> | > > > 1. Rebuild you master database to have the same collation as your
> user
> | > > > database.
> | > > > OR
> | > > > 1.Change your user database collation to match the server collatio
n
> by A)
> | > > > Using DTS or Alter database, Alter table/alter column (the Alter
> table/alter
> | > > > column has many restrictions). The following article describes how
> the above
> | > > > can be done:
> | > > >
> | > > > Article title: How to transfer a database from one collation to
> another
> | > > > collation in SQL Server
> | > > > Article Link:
> | > > >
> [url]http://support.microsoft.com/default.aspx?scid=kb;en-us;325335&Product=sql2k[/ur
l]
> | > > >
> | > > > Sasan Saidi
> | > > > Senior DBA
> | > > >
> | > > > "sysbox27" wrote:
> | > > >
> | > > > > Hi,
> | > > > > I have built a server based on a db's collation that I want to
> load, however
> | > > > > I still receive the 'cannot resolve collation conflict for equa
l
> to
> | > > > > operation'.
> | > > > >
> | > > > > I have checked the collations of the loaded against the tempdb.
> | > > > > loaded db:
> | > > > > SQL_Latin1_General_CP1_CI_AS
> | > > > > Latin1-General, case-insensitive, accent-sensitive,
> kanatype-insensitive,
> | > > > > width-insensitive
> | > > > > for Unicode Data, SQL Server Sort Order 52 on Code Page 1252 for
> non-Unicode
> | > > > > Data
> | > > > >
> | > > > > tempdb:
> | > > > > Latin1_General_CI_AS
> | > > > > Latin1-General, case-insensitive, accent-sensitive,
> kanatype-insensitive,
> | > > > > width-insensitive
> | > > > >
> | > > > > I would have thought the above would have been ok?
> | > > > >
> | > > > > Does this mean a rebuild of master db to map collation to db?
> | > > > >
> | > > > > Thanks.
> |
>

Clustering, Security, Performance, Load Balance

I think this question has been asked number of times. However, I am
looking for some specific information. Perhaps some of you can help
close the gap. Or perhaps you can point me towards right direction.

Perhaps this group can help me fill in ms-sqlserver related following
questions.

1. Do this database have data Clustering capabilities?
1a. If yes, what mechanism is used such as shared disk, share nothing,
etc.
2. Do these dB have Security features?
2a. If yes, what security features are supported? For instance do they
support encryption or SSL connection?
3. How does the database perform and what is the criteria for the
performance matrix?
4. Do they have inbuilt load balance capabilities?

I want to thank everyone for taking your time to read this
correspondence. I will also greatly appreciate your efforts in sharing
your thoughts.

Regards,
ManishManish (marora@.gmail.com) writes:

Quote:

Originally Posted by

I think this question has been asked number of times. However, I am
looking for some specific information. Perhaps some of you can help
close the gap. Or perhaps you can point me towards right direction.
>
Perhaps this group can help me fill in ms-sqlserver related following
questions.
>
1. Do this database have data Clustering capabilities?
1a. If yes, what mechanism is used such as shared disk, share nothing,
etc.

What sort of clustering do you have in mind? Clustering in MS SQL
Server is all about high availablility. That is two or more machines
that share disk. If one machine dies, another in the machine in the
cluster can take over very quickly.

I know that in other products, clustering is about scalinng out, but
MS SQL Server does not offering anything like that.

Quote:

Originally Posted by

2. Do these dB have Security features?

Yes, there are security features in MS SQL Server. :-)

Quote:

Originally Posted by

2a. If yes, what security features are supported? For instance do they
support encryption or SSL connection?

You can encrypt data in SQL 2005, and you can also use SSL for
encrypting the connection.

Quote:

Originally Posted by

3. How does the database perform and what is the criteria for the
performance matrix?
4. Do they have inbuilt load balance capabilities?

I'm not sure that I understand these questions. But if they were asked
with a scale-out solution like Oracle's RAC in mind, they are not
applicable to SQL Server.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||On Nov 27, 5:38 pm, Erland Sommarskog <esq...@.sommarskog.sewrote:

Quote:

Originally Posted by

Manish (mar...@.gmail.com) writes:

Quote:

Originally Posted by

I think this question has been asked number of times. However, I am
looking for some specific information. Perhaps some of you can help
close the gap. Or perhaps you can point me towards right direction.

>

Quote:

Originally Posted by

Perhaps this group can help me fill in ms-sqlserver related following
questions.

>

Quote:

Originally Posted by

1. Do this database have data Clustering capabilities?
1a. If yes, what mechanism is used such as shared disk, share nothing,
etc.

>
What sort of clustering do you have in mind? Clustering in MS SQL
Server is all about high availablility. That is two or more machines
that share disk. If one machine dies, another in the machine in the
cluster can take over very quickly.
>
I know that in other products, clustering is about scalinng out, but
MS SQL Server does not offering anything like that.
>

Quote:

Originally Posted by

2. Do these dB have Security features?

>
Yes, there are security features in MS SQL Server. :-)
>

Quote:

Originally Posted by

2a. If yes, what security features are supported? For instance do they
support encryption or SSL connection?

>
You can encrypt data in SQL 2005, and you can also use SSL for
encrypting the connection.
>

Quote:

Originally Posted by

3. How does the database perform and what is the criteria for the
performance matrix?
4. Do they have inbuilt load balance capabilities?

>
I'm not sure that I understand these questions. But if they were asked
with a scale-out solution like Oracle's RAC in mind, they are not
applicable to SQL Server.
>
--
Erland Sommarskog, SQL Server MVP, esq...@.sommarskog.se
>
Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

How does the database perform and what is the criteria for the
performance matrix? To clarify, how will one collect performance data
related to MS-SQLserver? What is the criteria for collecting such
data?|||Manish (marora@.gmail.com) writes:

Quote:

Originally Posted by

How does the database perform and what is the criteria for the
performance matrix? To clarify, how will one collect performance data
related to MS-SQLserver?

You can use performance counters, Profiler, query dynamic management views.

Quote:

Originally Posted by

What is the criteria for collecting such data?

I'm afraid that I can't answer why you would like to collect some data.
Or I am not understanding your question.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

Clustering SQL servers

Does anyone have any information on how to link 2 separate computers with
SQL server to share the load of 1 database? [I think this is called a
cluster?]
In other words, I want to have 1 front-end application machine and 2
back-end database machines that share 1 database.
Thanks.
It might at first seem similar, but this is not really clustering;
clustering involves two or more SQL Server nodes and a shared disk array but
no load balancing. EG in an active/passive configuration the load is not
shared as, at any one time, only one SQL Server machine is in control of the
shared resource which holds the database file. For load balancing in SQL
Server 2000, there is a different technology called 'distributed partitioned
views', (in Enterprise Edition) - plenty of details in BOL.
Also, if you have a requirement to distribute processing where there is a
significant reporting element, you might want to look at having a reporting
server and using log-shipping to transfer changes from the production system
to the reporting server. In this case there is some latency involved and
your application will need to distinguish between servers for different
queries (using the 2 different connection strings).
HTH,
Paul Ibison

Clustering SQL servers

Does anyone have any information on how to link 2 separate computers with
SQL server to share the load of 1 database? [I think this is called a
cluster']
In other words, I want to have 1 front-end application machine and 2
back-end database machines that share 1 database.
Thanks.It might at first seem similar, but this is not really clustering;
clustering involves two or more SQL Server nodes and a shared disk array but
no load balancing. EG in an active/passive configuration the load is not
shared as, at any one time, only one SQL Server machine is in control of the
shared resource which holds the database file. For load balancing in SQL
Server 2000, there is a different technology called 'distributed partitioned
views', (in Enterprise Edition) - plenty of details in BOL.
Also, if you have a requirement to distribute processing where there is a
significant reporting element, you might want to look at having a reporting
server and using log-shipping to transfer changes from the production system
to the reporting server. In this case there is some latency involved and
your application will need to distinguish between servers for different
queries (using the 2 different connection strings).
HTH,
Paul Ibison

Clustering SQL servers

Does anyone have any information on how to link 2 separate computers with
SQL server to share the load of 1 database? [I think this is called a
cluster']
In other words, I want to have 1 front-end application machine and 2
back-end database machines that share 1 database.
Thanks.It might at first seem similar, but this is not really clustering;
clustering involves two or more SQL Server nodes and a shared disk array but
no load balancing. EG in an active/passive configuration the load is not
shared as, at any one time, only one SQL Server machine is in control of the
shared resource which holds the database file. For load balancing in SQL
Server 2000, there is a different technology called 'distributed partitioned
views', (in Enterprise Edition) - plenty of details in BOL.
Also, if you have a requirement to distribute processing where there is a
significant reporting element, you might want to look at having a reporting
server and using log-shipping to transfer changes from the production system
to the reporting server. In this case there is some latency involved and
your application will need to distinguish between servers for different
queries (using the 2 different connection strings).
HTH,
Paul Ibison

Clustering SQL Server with four 2-way, or two 4-way?

This depends on your SQL Instance and application architecture. If you are running more than 2 SQL Instances with high load on each then you may go with a 4-node cluster and run an active/active/active/active configuration which will give you a higher le
vel of availability (more than one node can fail and you are still in business, howbeit with higher response times). Be careful about comparing model x with 2 processors with model y with 4 processors. Also, say you have 16GB of RAM for one application o
n on 4-CPU node it will allow you to use AWE and improve performance on a "busy" node. This is of almost no benefit when running a 2-CPU node with say 4GB as you're pretty much stuck with the 2.7GB limit per SQL Instance (assuming you have /PAE /3G switc
hes enabled).
I'd [almost] always go for the 4P 16GB 2-node config over the 2P 4/8GB 4-node config. But it really depend on how many high-load SQL Instances you have and what level of server redundancy you need. If you are considering 2P nodes you probably have relat
ively light SQL load - which may also sway your decision.
Yes and no. With 4 proc machines, you have 2 more processors to use than
with 2 proc machines. BUT, it depends upon your application whether you
will get better performance or throughput. If you have massive DSS queries
running and parallelism turned on full blast, the 4 proc machine will
probably only get you marginally better performance since the DSS queries
will monopolize the processors. If you are running an OLTP style
application, you will be much better throughput on the 4 proc machine than
you will on the 2 proc machine.
Mike
Principal Mentor
Solid Quality Learning
"More than just Training"
SQL Server MVP
http://www.solidqualitylearning.com
http://www.mssqlserver.com

Clustering for performance

Hi,
As far as I know, clustering is used to increase availability of SQL Server.
Is it possible to benefit from clustering for performance (load balancing
or...)?
Thanks in advance,
Leila
No, SQL Server Clustering does not load balance a database across servers.
An instance of SQL will only run on any one machine at any time.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://msmvps.com/clustering - Blog
"Leila" <Leilas@.hotpop.com> wrote in message
news:OuYWVHYzEHA.1192@.tk2msftngp13.phx.gbl...
> Hi,
> As far as I know, clustering is used to increase availability of SQL
> Server.
> Is it possible to benefit from clustering for performance (load balancing
> or...)?
> Thanks in advance,
> Leila
>

Clustering

Can anyone point me in a good direction for Clustering SQL Server 2k (for
failover and load balancing)? I'm not sure where to begin my research at.
Thanks...
- DougHigh Availability Resources
http://www.microsoft.com/sql/techinfo/administration/2000/availability.asp
Microsoft SQL Server 2000 High Availability Series
http://www.microsoft.com/technet/treeview/default.asp?url=/technet/prodtechnol/sql/deploy/confeat/sqlha/SQLHALP.asp
Tips and Tricks
http://www.sql-server-performance.com/clustering_2000.asp
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Doug Threewitt" <doug@.seisystems.com> wrote in message
news:OUQQRbu%23DHA.3272@.TK2MSFTNGP09.phx.gbl...
> Can anyone point me in a good direction for Clustering SQL Server 2k (for
> failover and load balancing)? I'm not sure where to begin my research at.
> Thanks...
>
> - Doug
>|||To add to Jaspers post, these helped me in the past
http://support.microsoft.com/default.aspx?scid=kb;en-us;243218
http://www.microsoft.com/technet/treeview/default.asp?url=/technet/prodtechnol/sql/deploy/confeat/failclus.asp
GL
--
Ray Higdon MCSE, MCDBA, CCNA
--
"Doug Threewitt" <doug@.seisystems.com> wrote in message
news:OUQQRbu%23DHA.3272@.TK2MSFTNGP09.phx.gbl...
> Can anyone point me in a good direction for Clustering SQL Server 2k (for
> failover and load balancing)? I'm not sure where to begin my research at.
> Thanks...
>
> - Doug
>

Clustering

Can anyone point me in a good direction for Clustering SQL Server 2k (for
failover and load balancing)? I'm not sure where to begin my research at.
Thanks...
- DougHigh Availability Resources
http://www.microsoft.com/sql/techin...vailability.asp
Microsoft SQL Server 2000 High Availability Series
http://www.microsoft.com/technet/tr...lha/SQLHALP.asp
Tips and Tricks
http://www.sql-server-performance.c...tering_2000.asp
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Doug Threewitt" <doug@.seisystems.com> wrote in message
news:OUQQRbu%23DHA.3272@.TK2MSFTNGP09.phx.gbl...
> Can anyone point me in a good direction for Clustering SQL Server 2k (for
> failover and load balancing)? I'm not sure where to begin my research at.
> Thanks...
>
> - Doug
>|||To add to Jaspers post, these helped me in the past
http://support.microsoft.com/defaul...kb;en-us;243218
http://www.microsoft.com/technet/tr...at/failclus.asp
GL
Ray Higdon MCSE, MCDBA, CCNA
--
"Doug Threewitt" <doug@.seisystems.com> wrote in message
news:OUQQRbu%23DHA.3272@.TK2MSFTNGP09.phx.gbl...
> Can anyone point me in a good direction for Clustering SQL Server 2k (for
> failover and load balancing)? I'm not sure where to begin my research at.
> Thanks...
>
> - Doug
>