how to change collation on sysdiagram to default collation of database ?

Question

how to change collation on sysdiagram to default collation of database ?

farzad.jalali

Right there with Babe

Points: 727
More actions
September 15, 2014 at 9:29 am

#397343

I changed the default collation of a database and every table within that except sysDiagrams , which I can't even through the designer .
does anybody know how to do it ?

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

i_amhers Mr or Mrs. 500 Points: 554 More actions · Answer 1

Hi Farzad,

When you say a table doesn't have the right collation: do you perhaps mean the columns are showing the wrong collation? Columns will keep the collation after they have been created unless explicitly altered. At least I have had that experience before.

Regards,

Jeremy

farzad.jalali Right there with Babe Points: 727 More actions · Answer 2

I made the database with collation "A" and the columns of that table were automatically created by that collation too.

now I change the default collation on database to "B" but the column's collation are still in "A".

Cath Trimble SSCarpal Tunnel Points: 4201 More actions · Answer 3

Changing the database collation won't change the collation of columns in existing user defined tables.

Here's a link that explains: http://msdn.microsoft.com/en-GB/library/ms175835.aspx

farzad.jalali Right there with Babe Points: 727 More actions · Answer 4

well, you are right , but you can't change column's collation on "sysDiagrams" , look like SQl server consider it as special table.

any one know how to change the column's collation on this table (sysDiagrams) ?

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 5

Why do you need to?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

farzad.jalali Right there with Babe Points: 727 More actions · Answer 6

GilaMonster (10/2/2014)
Why do you need to?

it's a task's requirement which is assigned to me .

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 7

farzad.jalali (10/2/2014)
GilaMonster (10/2/2014)
Why do you need to?
it's a task's requirement which is assigned to me .

Ok, why reason did the person assigning to have?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

farzad.jalali Right there with Babe Points: 727 More actions · Answer 8

Dear GilaMonster,

before we continue this conversation , do you mind if I ask you that : do you know how to change the collation on that tables's column ?

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 9

Yes... By doing nothing.

Go have a look at the sysdiagrams table. Are there any columns in there that have a collation defined at all?

Hence why I'm wondering why someone has given you a completely pointless task.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass