Is the Default collation SQL_Latin1_General_CP1_CI_AS in SQL server
2000?It depends on the system locale. If the system locale is US, then yes. If something else than US,
the default is a Windows collation matching your system locale.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"jsully79" <jms02360@.yahoo.com> wrote in message
news:1175128706.768591.229530@.n59g2000hsh.googlegroups.com...
> Is the Default collation SQL_Latin1_General_CP1_CI_AS in SQL server
> 2000?
>|||Hi
"jsully79" wrote:
> Is the Default collation SQL_Latin1_General_CP1_CI_AS in SQL server
> 2000?
>
The default collation is set when you install SQL Server, the value/type
will depend on whether SQL Server had already been installed see
http://msdn2.microsoft.com/en-us/library/aa224256(sql.80).aspx
John
Showing posts with label collation. Show all posts
Showing posts with label collation. Show all posts
Thursday, March 22, 2012
Default Collation
Is the Default collation SQL_Latin1_General_CP1_CI_AS in SQL server
2000?
It depends on the system locale. If the system locale is US, then yes. If something else than US,
the default is a Windows collation matching your system locale.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"jsully79" <jms02360@.yahoo.com> wrote in message
news:1175128706.768591.229530@.n59g2000hsh.googlegr oups.com...
> Is the Default collation SQL_Latin1_General_CP1_CI_AS in SQL server
> 2000?
>
|||Hi
"jsully79" wrote:
> Is the Default collation SQL_Latin1_General_CP1_CI_AS in SQL server
> 2000?
>
The default collation is set when you install SQL Server, the value/type
will depend on whether SQL Server had already been installed see
http://msdn2.microsoft.com/en-us/library/aa224256(sql.80).aspx
John
2000?
It depends on the system locale. If the system locale is US, then yes. If something else than US,
the default is a Windows collation matching your system locale.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"jsully79" <jms02360@.yahoo.com> wrote in message
news:1175128706.768591.229530@.n59g2000hsh.googlegr oups.com...
> Is the Default collation SQL_Latin1_General_CP1_CI_AS in SQL server
> 2000?
>
|||Hi
"jsully79" wrote:
> Is the Default collation SQL_Latin1_General_CP1_CI_AS in SQL server
> 2000?
>
The default collation is set when you install SQL Server, the value/type
will depend on whether SQL Server had already been installed see
http://msdn2.microsoft.com/en-us/library/aa224256(sql.80).aspx
John
default collation
hello,
how can I change the default collation (case-sensitive --> case-insentive)
of my instance?
regards,
uwe
I'm fairly sure you must reload the data.
http://support.microsoft.com/default...&Product=sql2k
Look for the section titled:
"Transfer a database from one collation in SQL Server 2000 to a different
collation in SQL Server 2000"
According to this article, the task is more difficult if the columns have
explicit collation (and I believe that's going to be the case even if the
column collation matches the database collation).
This process can be time-consuming. If your database is large, don't run
the copy process on your own workstation. Use WTS to do this or schedule a
job on the database server, so you don't copy all the bits over the network
to your PC and then back to the server.
"Uwe Muench" <uwe.muench@.fh-furtwangen.de> wrote in message
news:newscache$h1wjvh$w4m$1@.news.ghb.fh-furtwangen.de...
> hello,
> how can I change the default collation (case-sensitive --> case-insentive)
> of my instance?
> regards,
> uwe
>
how can I change the default collation (case-sensitive --> case-insentive)
of my instance?
regards,
uwe
I'm fairly sure you must reload the data.
http://support.microsoft.com/default...&Product=sql2k
Look for the section titled:
"Transfer a database from one collation in SQL Server 2000 to a different
collation in SQL Server 2000"
According to this article, the task is more difficult if the columns have
explicit collation (and I believe that's going to be the case even if the
column collation matches the database collation).
This process can be time-consuming. If your database is large, don't run
the copy process on your own workstation. Use WTS to do this or schedule a
job on the database server, so you don't copy all the bits over the network
to your PC and then back to the server.
"Uwe Muench" <uwe.muench@.fh-furtwangen.de> wrote in message
news:newscache$h1wjvh$w4m$1@.news.ghb.fh-furtwangen.de...
> hello,
> how can I change the default collation (case-sensitive --> case-insentive)
> of my instance?
> regards,
> uwe
>
default collation
hello,
how can I change the default collation (case-sensitive --> case-insentive)
of my instance?
regards,
uweI'm fairly sure you must reload the data.
http://support.microsoft.com/defaul...5&Product=sql2k
Look for the section titled:
"Transfer a database from one collation in SQL Server 2000 to a different
collation in SQL Server 2000"
According to this article, the task is more difficult if the columns have
explicit collation (and I believe that's going to be the case even if the
column collation matches the database collation).
This process can be time-consuming. If your database is large, don't run
the copy process on your own workstation. Use WTS to do this or schedule a
job on the database server, so you don't copy all the bits over the network
to your PC and then back to the server.
"Uwe Muench" <uwe.muench@.fh-furtwangen.de> wrote in message
news:newscache$h1wjvh$w4m$1@.news.ghb.fh-furtwangen.de...
> hello,
> how can I change the default collation (case-sensitive --> case-insentive)
> of my instance?
> regards,
> uwe
>
how can I change the default collation (case-sensitive --> case-insentive)
of my instance?
regards,
uweI'm fairly sure you must reload the data.
http://support.microsoft.com/defaul...5&Product=sql2k
Look for the section titled:
"Transfer a database from one collation in SQL Server 2000 to a different
collation in SQL Server 2000"
According to this article, the task is more difficult if the columns have
explicit collation (and I believe that's going to be the case even if the
column collation matches the database collation).
This process can be time-consuming. If your database is large, don't run
the copy process on your own workstation. Use WTS to do this or schedule a
job on the database server, so you don't copy all the bits over the network
to your PC and then back to the server.
"Uwe Muench" <uwe.muench@.fh-furtwangen.de> wrote in message
news:newscache$h1wjvh$w4m$1@.news.ghb.fh-furtwangen.de...
> hello,
> how can I change the default collation (case-sensitive --> case-insentive)
> of my instance?
> regards,
> uwe
>
Default Collation
Is the Default collation SQL_Latin1_General_CP1_CI_AS in SQL server
2000?It depends on the system locale. If the system locale is US, then yes. If so
mething else than US,
the default is a Windows collation matching your system locale.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"jsully79" <jms02360@.yahoo.com> wrote in message
news:1175128706.768591.229530@.n59g2000hsh.googlegroups.com...
> Is the Default collation SQL_Latin1_General_CP1_CI_AS in SQL server
> 2000?
>|||Hi
"jsully79" wrote:
> Is the Default collation SQL_Latin1_General_CP1_CI_AS in SQL server
> 2000?
>
The default collation is set when you install SQL Server, the value/type
will depend on whether SQL Server had already been installed see
http://msdn2.microsoft.com/en-us/library/aa224256(sql.80).aspx
Johnsql
2000?It depends on the system locale. If the system locale is US, then yes. If so
mething else than US,
the default is a Windows collation matching your system locale.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"jsully79" <jms02360@.yahoo.com> wrote in message
news:1175128706.768591.229530@.n59g2000hsh.googlegroups.com...
> Is the Default collation SQL_Latin1_General_CP1_CI_AS in SQL server
> 2000?
>|||Hi
"jsully79" wrote:
> Is the Default collation SQL_Latin1_General_CP1_CI_AS in SQL server
> 2000?
>
The default collation is set when you install SQL Server, the value/type
will depend on whether SQL Server had already been installed see
http://msdn2.microsoft.com/en-us/library/aa224256(sql.80).aspx
Johnsql
Wednesday, March 21, 2012
Defalult collation
Hello there
Is there a way to know which is the default collation on each server?Check out the SERVERPROPERTY function.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Roy Goldhammer" <roy@.hotmail.com> wrote in message news:Opt6VSHPGHA.2088@.tk2msftngp13.phx.
gbl...
> Hello there
> Is there a way to know which is the default collation on each server?
>|||Thankes Tiber
Now if my server is connected to another servers, how can i get server
properties of other servers?
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uGJEbKIPGHA.3840@.TK2MSFTNGP14.phx.gbl...
> Check out the SERVERPROPERTY function.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Roy Goldhammer" <roy@.hotmail.com> wrote in message
> news:Opt6VSHPGHA.2088@.tk2msftngp13.phx.gbl...|||You can use the OPENQUERY function:
SELECT *
FROM OPENQUERY(TIBWORK, 'SELECT SERVERPROPERTY(''Edition'')')
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Roy Goldhammer" <roy@.hotmail.com> wrote in message news:OvFvgqPPGHA.3936@.TK2MSFTNGP10.phx.
gbl...
> Thankes Tiber
> Now if my server is connected to another servers, how can i get server
> properties of other servers?
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote i
n
> message news:uGJEbKIPGHA.3840@.TK2MSFTNGP14.phx.gbl...
>|||Start Enterprise Manager, right click the server, click Properties, look for
Server collation
Milan
"Roy Goldhammer" <roy@.hotmail.com> wrote in message
news:Opt6VSHPGHA.2088@.tk2msftngp13.phx.gbl...
> Hello there
> Is there a way to know which is the default collation on each server?
>sql
Is there a way to know which is the default collation on each server?Check out the SERVERPROPERTY function.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Roy Goldhammer" <roy@.hotmail.com> wrote in message news:Opt6VSHPGHA.2088@.tk2msftngp13.phx.
gbl...
> Hello there
> Is there a way to know which is the default collation on each server?
>|||Thankes Tiber
Now if my server is connected to another servers, how can i get server
properties of other servers?
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uGJEbKIPGHA.3840@.TK2MSFTNGP14.phx.gbl...
> Check out the SERVERPROPERTY function.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Roy Goldhammer" <roy@.hotmail.com> wrote in message
> news:Opt6VSHPGHA.2088@.tk2msftngp13.phx.gbl...|||You can use the OPENQUERY function:
SELECT *
FROM OPENQUERY(TIBWORK, 'SELECT SERVERPROPERTY(''Edition'')')
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Roy Goldhammer" <roy@.hotmail.com> wrote in message news:OvFvgqPPGHA.3936@.TK2MSFTNGP10.phx.
gbl...
> Thankes Tiber
> Now if my server is connected to another servers, how can i get server
> properties of other servers?
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote i
n
> message news:uGJEbKIPGHA.3840@.TK2MSFTNGP14.phx.gbl...
>|||Start Enterprise Manager, right click the server, click Properties, look for
Server collation
Milan
"Roy Goldhammer" <roy@.hotmail.com> wrote in message
news:Opt6VSHPGHA.2088@.tk2msftngp13.phx.gbl...
> Hello there
> Is there a way to know which is the default collation on each server?
>sql
Subscribe to:
Posts (Atom)