german database on engl. server

How ca i use a english database on a german SQL Server ?
Wher can I find some tips and trick about this config?
I have many problems with e.g. date format, with . and , and so one.

Thanks

Read about COLLATION in Books Online.

Thanks,|||

Change the collation of the database to an english collation.

Denny

|||

Hello,

thanks for your answers, but how can i change this? Which comand can i use ?

Must I rebuild the master db ... it is a production server !

Regards

Thanks

|||We had a similar problem with English server.

In order to use German date format , etc. You must change the default language of Login name in SQL Server database.

For example,

ALTER LOGIN <Login-name> WITH DEFAULT_LANGUAGE = German;

(the login-name is the name in web.config where in <appSettings> exists)

I hope this helps.

|||What do you mean with "English Database", the content is in general international in many cases. (Including the D-English words :-))

Jens K. Suessmeyer:

http://www.sqlserver2005.de