Check collations

Hello,
How can i check server collation an if any database table
or column as a different collation?
Best regardsHi
Look at INFORMATION_SCHEMA.COLUMNS view to retrieve information about
collation.
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
news:8fea01c47888$8e764ee0$a501280a@.phx.gbl...
> Hello,
> How can i check server collation an if any database table
> or column as a different collation?
> Best regards|||And to check the default collation property for the server
select serverproperty('collation')
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
news:8fea01c47888$8e764ee0$a501280a@.phx.gbl...
> Hello,
> How can i check server collation an if any database table
> or column as a different collation?
> Best regards|||I'm not 100% sure what you're asking.
SERVERPROPERTY ( propertyname )
DATABASEPROPERTYEX( database , property )
and for columns...
sp_help [ [ @.objname = ] name ]
Brian Moran
Principal Mentor
Solid Quality Learning
SQL Server MVP
http://www.solidqualitylearning.com
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
news:8fea01c47888$8e764ee0$a501280a@.phx.gbl...
> Hello,
> How can i check server collation an if any database table
> or column as a different collation?
> Best regards

Check collations

Hello,
How can i check server collation an if any database table
or column as a different collation?
Best regards
Hi
Look at INFORMATION_SCHEMA.COLUMNS view to retrieve information about
collation.
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
news:8fea01c47888$8e764ee0$a501280a@.phx.gbl...
> Hello,
> How can i check server collation an if any database table
> or column as a different collation?
> Best regards
|||And to check the default collation property for the server
select serverproperty('collation')
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
news:8fea01c47888$8e764ee0$a501280a@.phx.gbl...
> Hello,
> How can i check server collation an if any database table
> or column as a different collation?
> Best regards
|||I'm not 100% sure what you're asking.
SERVERPROPERTY ( propertyname )
DATABASEPROPERTYEX( database , property )
and for columns...
sp_help [ [ @.objname = ] name ]

Brian Moran
Principal Mentor
Solid Quality Learning
SQL Server MVP
http://www.solidqualitylearning.com
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
news:8fea01c47888$8e764ee0$a501280a@.phx.gbl...
> Hello,
> How can i check server collation an if any database table
> or column as a different collation?
> Best regards

Check collations

Hello,
How can i check server collation an if any database table
or column as a different collation?
Best regardsHi
Look at INFORMATION_SCHEMA.COLUMNS view to retrieve information about
collation.
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
news:8fea01c47888$8e764ee0$a501280a@.phx.gbl...
> Hello,
> How can i check server collation an if any database table
> or column as a different collation?
> Best regards|||And to check the default collation property for the server
select serverproperty('collation')
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
news:8fea01c47888$8e764ee0$a501280a@.phx.gbl...
> Hello,
> How can i check server collation an if any database table
> or column as a different collation?
> Best regards|||I'm not 100% sure what you're asking.
SERVERPROPERTY ( propertyname )
DATABASEPROPERTYEX( database , property )
and for columns...
sp_help [ [ @.objname = ] name ]
Brian Moran
Principal Mentor
Solid Quality Learning
SQL Server MVP
http://www.solidqualitylearning.com
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
news:8fea01c47888$8e764ee0$a501280a@.phx.gbl...
> Hello,
> How can i check server collation an if any database table
> or column as a different collation?
> Best regards

Check all existing collations in one database.

Hello,
Can you tell me, how can i get all collations that i have in one database. I
get the database collation but i need to verify if any table or field in the
current database have one different collation.
I've got one job that is returning the following error:
Server: Msg 457, Level 16, State 1, Procedure WsIBTLoadBatch, Line 20
Implicit conversion of char value to char cannot be performed because the
collation of the value is unresolved due to a collation conflict.
Thanks and best regars.
The following will list columns in tables and views that have a collation
other than the current database default:
SELECT
o.type,
USER_NAME(o.uid),
o.name,
c.name
FROM sysobjects o
JOIN syscolumns c ON c.id = o.id
WHERE
o.type IN('U', 'V') AND
c.collation <> DATABASEPROPERTYEX(DB_NAME(), 'COLLATION')
Hope this helps.
Dan Guzman
SQL Server MVP
"CC&JM" <CCJM@.discussions.microsoft.com> wrote in message
news:31B6222F-B334-4612-853E-D27298405704@.microsoft.com...
> Hello,
> Can you tell me, how can i get all collations that i have in one database.
> I
> get the database collation but i need to verify if any table or field in
> the
> current database have one different collation.
> I've got one job that is returning the following error:
> Server: Msg 457, Level 16, State 1, Procedure WsIBTLoadBatch, Line 20
> Implicit conversion of char value to char cannot be performed because the
> collation of the value is unresolved due to a collation conflict.
> Thanks and best regars.
|||Thanks Dan,
Best regards
"Dan Guzman" wrote:

> The following will list columns in tables and views that have a collation
> other than the current database default:
> SELECT
> o.type,
> USER_NAME(o.uid),
> o.name,
> c.name
> FROM sysobjects o
> JOIN syscolumns c ON c.id = o.id
> WHERE
> o.type IN('U', 'V') AND
> c.collation <> DATABASEPROPERTYEX(DB_NAME(), 'COLLATION')
>
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "CC&JM" <CCJM@.discussions.microsoft.com> wrote in message
> news:31B6222F-B334-4612-853E-D27298405704@.microsoft.com...
>
>

Check all existing collations in one database.

Hello,
Can you tell me, how can i get all collations that i have in one database. I
get the database collation but i need to verify if any table or field in the
current database have one different collation.
I've got one job that is returning the following error:
Server: Msg 457, Level 16, State 1, Procedure WsIBTLoadBatch, Line 20
Implicit conversion of char value to char cannot be performed because the
collation of the value is unresolved due to a collation conflict.
Thanks and best regars.The following will list columns in tables and views that have a collation
other than the current database default:
SELECT
o.type,
USER_NAME(o.uid),
o.name,
c.name
FROM sysobjects o
JOIN syscolumns c ON c.id = o.id
WHERE
o.type IN('U', 'V') AND
c.collation <> DATABASEPROPERTYEX(DB_NAME(), 'COLLATION')
Hope this helps.
Dan Guzman
SQL Server MVP
"CC&JM" <CCJM@.discussions.microsoft.com> wrote in message
news:31B6222F-B334-4612-853E-D27298405704@.microsoft.com...
> Hello,
> Can you tell me, how can i get all collations that i have in one database.
> I
> get the database collation but i need to verify if any table or field in
> the
> current database have one different collation.
> I've got one job that is returning the following error:
> Server: Msg 457, Level 16, State 1, Procedure WsIBTLoadBatch, Line 20
> Implicit conversion of char value to char cannot be performed because the
> collation of the value is unresolved due to a collation conflict.
> Thanks and best regars.|||Thanks Dan,
Best regards
"Dan Guzman" wrote:
> The following will list columns in tables and views that have a collation
> other than the current database default:
> SELECT
> o.type,
> USER_NAME(o.uid),
> o.name,
> c.name
> FROM sysobjects o
> JOIN syscolumns c ON c.id = o.id
> WHERE
> o.type IN('U', 'V') AND
> c.collation <> DATABASEPROPERTYEX(DB_NAME(), 'COLLATION')
>
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "CC&JM" <CCJM@.discussions.microsoft.com> wrote in message
> news:31B6222F-B334-4612-853E-D27298405704@.microsoft.com...
> > Hello,
> >
> > Can you tell me, how can i get all collations that i have in one database.
> > I
> > get the database collation but i need to verify if any table or field in
> > the
> > current database have one different collation.
> >
> > I've got one job that is returning the following error:
> > Server: Msg 457, Level 16, State 1, Procedure WsIBTLoadBatch, Line 20
> > Implicit conversion of char value to char cannot be performed because the
> > collation of the value is unresolved due to a collation conflict.
> >
> > Thanks and best regars.
>
>

Check all existing collations in one database.

Hello,
Can you tell me, how can i get all collations that i have in one database. I
get the database collation but i need to verify if any table or field in the
current database have one different collation.
I've got one job that is returning the following error:
Server: Msg 457, Level 16, State 1, Procedure WsIBTLoadBatch, Line 20
Implicit conversion of char value to char cannot be performed because the
collation of the value is unresolved due to a collation conflict.
Thanks and best regars.The following will list columns in tables and views that have a collation
other than the current database default:
SELECT
o.type,
USER_NAME(o.uid),
o.name,
c.name
FROM sysobjects o
JOIN syscolumns c ON c.id = o.id
WHERE
o.type IN('U', 'V') AND
c.collation <> DATABASEPROPERTYEX(DB_NAME(), 'COLLATION')
Hope this helps.
Dan Guzman
SQL Server MVP
"CC&JM" <CCJM@.discussions.microsoft.com> wrote in message
news:31B6222F-B334-4612-853E-D27298405704@.microsoft.com...
> Hello,
> Can you tell me, how can i get all collations that i have in one database.
> I
> get the database collation but i need to verify if any table or field in
> the
> current database have one different collation.
> I've got one job that is returning the following error:
> Server: Msg 457, Level 16, State 1, Procedure WsIBTLoadBatch, Line 20
> Implicit conversion of char value to char cannot be performed because the
> collation of the value is unresolved due to a collation conflict.
> Thanks and best regars.|||Thanks Dan,
Best regards
"Dan Guzman" wrote:

> The following will list columns in tables and views that have a collation
> other than the current database default:
> SELECT
> o.type,
> USER_NAME(o.uid),
> o.name,
> c.name
> FROM sysobjects o
> JOIN syscolumns c ON c.id = o.id
> WHERE
> o.type IN('U', 'V') AND
> c.collation <> DATABASEPROPERTYEX(DB_NAME(), 'COLLATION')
>
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "CC&JM" <CCJM@.discussions.microsoft.com> wrote in message
> news:31B6222F-B334-4612-853E-D27298405704@.microsoft.com...
>
>

Charset&collation

Hello,
How can I find out from SQL SRV2000 which characterset and collation is
used.
Thanks
-WillWilliam
SELECT SERVERPROPERTY('Collation') AS [Collation]
sp_helpsort
"William Stokes" <will@.operamail.com> wrote in message
news:OLTYuFdwGHA.4612@.TK2MSFTNGP02.phx.gbl...
> Hello,
> How can I find out from SQL SRV2000 which characterset and collation is
> used.
> Thanks
> -Will
>|||DATABASEPROPERTYEX and SERVERPROPERTY can show this. Note that default colla
tion for a database
can differ from the default for the instance.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"William Stokes" <will@.operamail.com> wrote in message news:OLTYuFdwGHA.4612@.TK2MSFTNGP02.ph
x.gbl...
> Hello,
> How can I find out from SQL SRV2000 which characterset and collation is us
ed.
> Thanks
> -Will
>|||Hi William
For the database level you can see this in the status column when using
sp_helpdb
For column level collations you can see it using sp_help for the table or in
the INFORMATION_SCHEMA.COLUMNS view,
For more information on a collation try:
SELECT name, description,
COLLATIONPROPERTY( name, 'CodePage' ) AS CodePage ,
COLLATIONPROPERTY( name, 'LCID' ) AS LCID,
COLLATIONPROPERTY( name, 'ComparisonStyle' ) AS ComparisonStyle
FROM ::fn_helpcollations()
John
"William Stokes" wrote:

> Hello,
> How can I find out from SQL SRV2000 which characterset and collation is
> used.
> Thanks
> -Will
>
>|||Cheers!
One more quoestion. If a DB instance collation sort order was setup as
"Binary" can it be changed afterwards to "Accent sensitive"?
Thanks
-Will
"John Bell" <jbellnewsposts@.hotmail.com> kirjoitti
viestiss:F3CB400B-1E1C-4935-BA2F-A812450BCA7C@.microsoft.com...[vbcol=seagreen]
> Hi William
> For the database level you can see this in the status column when using
> sp_helpdb
> For column level collations you can see it using sp_help for the table or
> in
> the INFORMATION_SCHEMA.COLUMNS view,
> For more information on a collation try:
> SELECT name, description,
> COLLATIONPROPERTY( name, 'CodePage' ) AS CodePage ,
> COLLATIONPROPERTY( name, 'LCID' ) AS LCID,
> COLLATIONPROPERTY( name, 'ComparisonStyle' ) AS ComparisonStyle
> FROM ::fn_helpcollations()
>
> John
> "William Stokes" wrote:
>|||Hi,
To change the collation server level we need to rebuild the master database
and it requires downtime.
http://msdn.microsoft.com/library/d.../>
ll_8w8p.asp
Thanks
Hari
SQL Server MVP
"William Stokes" <will@.operamail.com> wrote in message
news:OptCyOfwGHA.4576@.TK2MSFTNGP03.phx.gbl...
> Cheers!
> One more quoestion. If a DB instance collation sort order was setup as
> "Binary" can it be changed afterwards to "Accent sensitive"?
> Thanks
> -Will
> "John Bell" <jbellnewsposts@.hotmail.com> kirjoitti
> viestiss:F3CB400B-1E1C-4935-BA2F-A812450BCA7C@.microsoft.com...
>|||iHi
It can be changed, but you would need to change it at the database and for
each column that has a collation. See http://tinyurl.com/429qa and previous
posts such as http://tinyurl.com/om6b4
John
"William Stokes" wrote:

> Cheers!
> One more quoestion. If a DB instance collation sort order was setup as
> "Binary" can it be changed afterwards to "Accent sensitive"?
> Thanks
> -Will
> "John Bell" <jbellnewsposts@.hotmail.com> kirjoitti
> viestiss?:F3CB400B-1E1C-4935-BA2F-A812450BCA7C@.microsoft.com...
>
>|||Alternatively you can remove and re-install!!
John
"Hari Prasad" wrote:

> Hi,
> To change the collation server level we need to rebuild the master databas
e
> and it requires downtime.
> http://msdn.microsoft.com/library/d...
tall_8w8p.asp
> Thanks
> Hari
> SQL Server MVP
>
> "William Stokes" <will@.operamail.com> wrote in message
> news:OptCyOfwGHA.4576@.TK2MSFTNGP03.phx.gbl...
>
>

Charset&collation

Hello,
How can I find out from SQL SRV2000 which characterset and collation is
used.
Thanks
-WillWilliam
SELECT SERVERPROPERTY('Collation') AS [Collation]
sp_helpsort
"William Stokes" <will@.operamail.com> wrote in message
news:OLTYuFdwGHA.4612@.TK2MSFTNGP02.phx.gbl...
> Hello,
> How can I find out from SQL SRV2000 which characterset and collation is
> used.
> Thanks
> -Will
>|||DATABASEPROPERTYEX and SERVERPROPERTY can show this. Note that default collation for a database
can differ from the default for the instance.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"William Stokes" <will@.operamail.com> wrote in message news:OLTYuFdwGHA.4612@.TK2MSFTNGP02.phx.gbl...
> Hello,
> How can I find out from SQL SRV2000 which characterset and collation is used.
> Thanks
> -Will
>|||Hi William
For the database level you can see this in the status column when using
sp_helpdb
For column level collations you can see it using sp_help for the table or in
the INFORMATION_SCHEMA.COLUMNS view,
For more information on a collation try:
SELECT name, description,
COLLATIONPROPERTY( name, 'CodePage' ) AS CodePage ,
COLLATIONPROPERTY( name, 'LCID' ) AS LCID,
COLLATIONPROPERTY( name, 'ComparisonStyle' ) AS ComparisonStyle
FROM ::fn_helpcollations()
John
"William Stokes" wrote:
> Hello,
> How can I find out from SQL SRV2000 which characterset and collation is
> used.
> Thanks
> -Will
>
>|||Cheers!
One more quoestion. If a DB instance collation sort order was setup as
"Binary" can it be changed afterwards to "Accent sensitive"?
Thanks
-Will
"John Bell" <jbellnewsposts@.hotmail.com> kirjoitti
viestissä:F3CB400B-1E1C-4935-BA2F-A812450BCA7C@.microsoft.com...
> Hi William
> For the database level you can see this in the status column when using
> sp_helpdb
> For column level collations you can see it using sp_help for the table or
> in
> the INFORMATION_SCHEMA.COLUMNS view,
> For more information on a collation try:
> SELECT name, description,
> COLLATIONPROPERTY( name, 'CodePage' ) AS CodePage ,
> COLLATIONPROPERTY( name, 'LCID' ) AS LCID,
> COLLATIONPROPERTY( name, 'ComparisonStyle' ) AS ComparisonStyle
> FROM ::fn_helpcollations()
>
> John
> "William Stokes" wrote:
>> Hello,
>> How can I find out from SQL SRV2000 which characterset and collation is
>> used.
>> Thanks
>> -Will
>>|||Hi,
To change the collation server level we need to rebuild the master database
and it requires downtime.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/howtosql/ht_install_8w8p.asp
Thanks
Hari
SQL Server MVP
"William Stokes" <will@.operamail.com> wrote in message
news:OptCyOfwGHA.4576@.TK2MSFTNGP03.phx.gbl...
> Cheers!
> One more quoestion. If a DB instance collation sort order was setup as
> "Binary" can it be changed afterwards to "Accent sensitive"?
> Thanks
> -Will
> "John Bell" <jbellnewsposts@.hotmail.com> kirjoitti
> viestissä:F3CB400B-1E1C-4935-BA2F-A812450BCA7C@.microsoft.com...
>> Hi William
>> For the database level you can see this in the status column when using
>> sp_helpdb
>> For column level collations you can see it using sp_help for the table or
>> in
>> the INFORMATION_SCHEMA.COLUMNS view,
>> For more information on a collation try:
>> SELECT name, description,
>> COLLATIONPROPERTY( name, 'CodePage' ) AS CodePage ,
>> COLLATIONPROPERTY( name, 'LCID' ) AS LCID,
>> COLLATIONPROPERTY( name, 'ComparisonStyle' ) AS ComparisonStyle
>> FROM ::fn_helpcollations()
>>
>> John
>> "William Stokes" wrote:
>> Hello,
>> How can I find out from SQL SRV2000 which characterset and collation is
>> used.
>> Thanks
>> -Will
>>
>|||iHi
It can be changed, but you would need to change it at the database and for
each column that has a collation. See http://tinyurl.com/429qa and previous
posts such as http://tinyurl.com/om6b4
John
"William Stokes" wrote:
> Cheers!
> One more quoestion. If a DB instance collation sort order was setup as
> "Binary" can it be changed afterwards to "Accent sensitive"?
> Thanks
> -Will
> "John Bell" <jbellnewsposts@.hotmail.com> kirjoitti
> viestissä:F3CB400B-1E1C-4935-BA2F-A812450BCA7C@.microsoft.com...
> > Hi William
> >
> > For the database level you can see this in the status column when using
> > sp_helpdb
> >
> > For column level collations you can see it using sp_help for the table or
> > in
> > the INFORMATION_SCHEMA.COLUMNS view,
> >
> > For more information on a collation try:
> >
> > SELECT name, description,
> > COLLATIONPROPERTY( name, 'CodePage' ) AS CodePage ,
> > COLLATIONPROPERTY( name, 'LCID' ) AS LCID,
> > COLLATIONPROPERTY( name, 'ComparisonStyle' ) AS ComparisonStyle
> > FROM ::fn_helpcollations()
> >
> >
> > John
> >
> > "William Stokes" wrote:
> >
> >> Hello,
> >>
> >> How can I find out from SQL SRV2000 which characterset and collation is
> >> used.
> >>
> >> Thanks
> >> -Will
> >>
> >>
> >>
>
>|||Alternatively you can remove and re-install!!
John
"Hari Prasad" wrote:
> Hi,
> To change the collation server level we need to rebuild the master database
> and it requires downtime.
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/howtosql/ht_install_8w8p.asp
> Thanks
> Hari
> SQL Server MVP
>
> "William Stokes" <will@.operamail.com> wrote in message
> news:OptCyOfwGHA.4576@.TK2MSFTNGP03.phx.gbl...
> > Cheers!
> >
> > One more quoestion. If a DB instance collation sort order was setup as
> > "Binary" can it be changed afterwards to "Accent sensitive"?
> >
> > Thanks
> >
> > -Will
> >
> > "John Bell" <jbellnewsposts@.hotmail.com> kirjoitti
> > viestissä:F3CB400B-1E1C-4935-BA2F-A812450BCA7C@.microsoft.com...
> >> Hi William
> >>
> >> For the database level you can see this in the status column when using
> >> sp_helpdb
> >>
> >> For column level collations you can see it using sp_help for the table or
> >> in
> >> the INFORMATION_SCHEMA.COLUMNS view,
> >>
> >> For more information on a collation try:
> >>
> >> SELECT name, description,
> >> COLLATIONPROPERTY( name, 'CodePage' ) AS CodePage ,
> >> COLLATIONPROPERTY( name, 'LCID' ) AS LCID,
> >> COLLATIONPROPERTY( name, 'ComparisonStyle' ) AS ComparisonStyle
> >> FROM ::fn_helpcollations()
> >>
> >>
> >> John
> >>
> >> "William Stokes" wrote:
> >>
> >> Hello,
> >>
> >> How can I find out from SQL SRV2000 which characterset and collation is
> >> used.
> >>
> >> Thanks
> >> -Will
> >>
> >>
> >>
> >
> >
>
>

Character set, Sort Order, Unicode Collation

Please, a command/script to see how I installed my Sql
Server (Character set, Sort Order, Unicode Collation), I
was looking for them at Knowledge Base, but couldn't find
anything.
ThanksThis should do it:
select serverproperty('collation')
Regards,
Paul Ibison|||Hi,
Add on , Execute the below procedure to get the charecter set and sort
order. This procedure will work for all versions.
sp_helpsort
--
Thanks
Hari
MCDBA
"Robert Duval" <r.duval@.discussions.microsoft.com> wrote in message
news:1ddf001c45512$bfedc6e0$a601280a@.phx.gbl...
> Please, a command/script to see how I installed my Sql
> Server (Character set, Sort Order, Unicode Collation), I
> was looking for them at Knowledge Base, but couldn't find
> anything.
> Thanks

Character set, Sort Order, Unicode Collation

Please, a command/script to see how I installed my Sql
Server (Character set, Sort Order, Unicode Collation), I
was looking for them at Knowledge Base, but couldn't find
anything.
ThanksHi,
Add on , Execute the below procedure to get the charecter set and sort
order. This procedure will work for all versions.
sp_helpsort
Thanks
Hari
MCDBA
"Robert Duval" <r.duval@.discussions.microsoft.com> wrote in message
news:1ddf001c45512$bfedc6e0$a601280a@.phx
.gbl...
> Please, a command/script to see how I installed my Sql
> Server (Character set, Sort Order, Unicode Collation), I
> was looking for them at Knowledge Base, but couldn't find
> anything.
> Thanks

Character set, Sort Order, Unicode Collation

Please, a command/script to see how I installed my Sql
Server (Character set, Sort Order, Unicode Collation), I
was looking for them at Knowledge Base, but couldn't find
anything.
Thanks
Hi,
Add on , Execute the below procedure to get the charecter set and sort
order. This procedure will work for all versions.
sp_helpsort
Thanks
Hari
MCDBA
"Robert Duval" <r.duval@.discussions.microsoft.com> wrote in message
news:1ddf001c45512$bfedc6e0$a601280a@.phx.gbl...
> Please, a command/script to see how I installed my Sql
> Server (Character set, Sort Order, Unicode Collation), I
> was looking for them at Knowledge Base, but couldn't find
> anything.
> Thanks