December 20, 2009 at 9:52 am
Hi,
As far as I know to view the db collation we use:
SELECT DATABASEPROPERTYEX('DBNAME', 'Collation') SQLCollation
But how to view the current server collation? is it just view the right click master db properties to check? Thanks a lot
Best regards,
Wallace
December 20, 2009 at 11:34 am
select serverproperty('collation')
---------------------------------------------------------------------
December 20, 2009 at 2:17 pm
As you said you can also get this information from the server properties in Management Studio.
Gethyn Elliswww.gethynellis.com
December 20, 2009 at 6:25 pm
Thanks a lot
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply