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