>Hi All, I have a problem where my dev server installation of SQL 2000 has a different default language to my production server, the dev is 'British' which is what I want, and the production's 'us_english'. A problem arises when on of my SP's receives a date as a varchar, e.g. '13\10\06', obviously it bombs, I don't have time to rewrite the C# code that uses these SP's and in any case if the language is set to 'british' there isn't a problem. As a workaround I've inserted "set dateformat dmy" in the problem SP's but I would like to sync the server settings. What I've tried so far is: exec sp_configure 'default language',23 (the british id) followed by 'reconfigure', this is supposed to make the setting permanent, I've also tried exec sp_defaultlanguage 'groupthatusestheapp','british', they both report that the setting has been changed but when one of the users attempt to use the app they receive an invalid date error (unless my workaround is in my place) please help if you can, thanks

Try to put: Language=British in your connection string. But I suggest you to use ANSI datetime format:
'YYYYMMDD HH:MM:SS', SQL Server will convert it no metter what are the current date format settings.