javiermorquecho
asked on
SQL 2005, DB with collation in "spanish"
Hi!
I ´ve a server with windows server 2008 on english. It has SQL 2005 on spanish.
I need a DB with collation in "spanish" but I cannot select that.
How I can to resolve that?
Thnx
I ´ve a server with windows server 2008 on english. It has SQL 2005 on spanish.
I need a DB with collation in "spanish" but I cannot select that.
How I can to resolve that?
Thnx
Or Modern_Spanish* in the collation dropdown
You have this many collations related to Spanish and choose any one of them in the dropdown while installing SQL Server or change it using ALTER DATABASE statement like
ALTER DATABASE ur_db_name COLLATE ur_collation_name
ALTER DATABASE ur_db_name COLLATE ur_collation_name
ASKER
OK. Making the ALTER TABLE exist the posibility to get a DB with some type of demage?
ASKER
Try setting / resetting collation of your master database and then try this.
And is there by any chance that you are at SP2 of your SQL Server 2005 and apply SP3 and check out..
And is there by any chance that you are at SP2 of your SQL Server 2005 and apply SP3 and check out..
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Have a look under Traditional_Spanish*