Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Collation Checker Expand / Collapse
Author
Message
Posted Saturday, September 22, 2007 1:11 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, November 22, 2013 8:54 AM
Points: 1,108, Visits: 204
Comments posted to this topic are about the item Collation Checker
Post #401463
Posted Monday, October 15, 2007 1:44 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, October 10, 2013 3:32 AM
Points: 7, Visits: 26
just a small correction.

this script gave errors on our dev server, because we have dbs with '.' in the name.

so we had to change the script in the dynamic sqls part so that @dbname changed to '[' + @dbname +']'

thanks for the script :)
and keep up the good work
Post #410716
Posted Monday, October 15, 2007 3:33 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, November 22, 2013 8:54 AM
Points: 1,108, Visits: 204
thanks kselich, I've never seen a database with a . in the name before, so I didn't consider that. I'll make the change on the script.

Paul
Post #410739
Posted Monday, October 15, 2007 3:58 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, June 29, 2010 7:07 AM
Points: 1, Visits: 25
Hi, thanks for the script!!

I have to keep any database off-line so the script gave me an error
so i put an additional condition in 2 where clauses relatives to sysdatabase table to avoid the problem:

'version is not null'

maybe is not the smartest way but it works...

bye
Post #410748
Posted Monday, October 15, 2007 8:21 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, April 27, 2011 4:25 AM
Points: 96, Visits: 31
Hi, I've already rated this as excellent, though (adding to what kselic said) surrounding the dbnames with [] is mandatory because you can have dbnames with various issues, like 'REGISTER DATABASE' (contains space...).
A last couple suggestion:
1 add to #database_collations_by_column table a column named 'tablename', both in insert and in last select so you can tell not only column name but also in which table it is, to ease searching for problems in a db...
2 change from varchar(100) to sysname the column type in those #tables...
But anyway very useful, I've found a few columns that will create problems in some not distant future.
Thanks
Gigi
Post #410851
Posted Monday, October 15, 2007 8:52 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, November 22, 2013 8:54 AM
Points: 1,108, Visits: 204
Thanks for the suggestions Luigi and Matteo. I'll make the suggested changes. I'll post it later in the week , as the scripts need to be checked by the administrators again before it get republished.

Paul
Post #410867
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse