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