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 ?

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

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...

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"...

Overall summary:

Final result: Failed: see details below

Exit code (Decimal):...

Thanks for your replay, here is the answer:

I need to change the default collation on the server ( it need to be SQL_Latin1_General_CP1_CI_AS ), so I tried to rebuild it...

I got the same error for SQL server 2008R2