June 15, 2006 at 8:25 am
i posted this on the general 2005 forum, but thought I would post it here too:
Hi. I'm trying to change the default language used for my server to be from US English to British English. I'm using this:
exec sp_addlanguage 'British', 'English',
'January,February,March,April,May,June,July,August,September,October,
November,December',
'Jan,Feb,Mar,Apr,May,Jun,Jul,Aug,Sep,Oct,Nov,Dec',
'Monday,Tuesday,Wednesday,Thursday,Friday,Saturday,Sunday',
dmy,1
sp_configure 'default language', 1
reconfigure with override
However it errors complaining that it can't find sp_addlanguage.
I tried to look for it and couldn't find it either, so am wondering if the name has changed in 2005?
If I right click the server and choose properties, I can see the language being used, but can't edit it from there.
Any insight here is welcome!
Thanks in advance,
David
June 15, 2006 at 11:11 am
Looking 'sp_addlanguage' up in SQL 2005 Books Online I couldn't find a reference to it, however in 2000 Books Online (locally) it says that for SQL Server 2000 it was "Removed; no longer available. Remove all references to sp_addlanguage."
Therefore I would presume it was not reintroduced in 2005.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply