SQL Server Advanced Queries
Thursday, April 14, 2011
How to get the default collation? just a single query command.
Easy to do
SELECT
dtb
.
collation_name
AS
[Collation]
,
dtb
.
name
AS
[DatabaseName2]
FROM
master
.
sys
.
databases
AS
dtb
WHERE
(
dtb
.
name
=
'master'
)
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment