August 8, 2006 at 12:03 am
Anybody able to give some hints on possible ways of finding out all of the collations used in multiple databases
MCT
MCITP Database Admin 2008
MCITP Database Admin 2008
MCITP Database Dev 2008
www.jnrit.com.au/Blog.aspx
August 8, 2006 at 12:44 am
Sure...a starting point would be to use the following select statement:
select
databasepropertyex('pubs', 'Collation')
A simple approach would be to use the sysdatabases system table and generate the above scripts for you to execute - just replace 'pubs' with the database name.
August 8, 2006 at 1:35 am
Paul thx for that. That gives me a good starting point. I will have to go and have a look at each of the DB's inidividually as well to check for any collation differences at the column level also.
MCT
MCITP Database Admin 2008
MCITP Database Admin 2008
MCITP Database Dev 2008
www.jnrit.com.au/Blog.aspx
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply