I encountered this error and post after I created a new 2008 R2 server, and restored a backup of a 2005 Database.
I then imported all users, maintainence plans etc, but I got this error as I had forgotten to change the default language from US English to British English.
After the migrate I had to :
- refresh statistics with : exec sp_udatatestats
- set default laguage with : EXEC sp_configure 'default language', 23
using the below code (I should link it but i forgot where I got it from) I changed all users language
declare @l table(sqlCmd nvarchar(max)) declare @sqlCmd nvarchar(max) insert @l select 'alter login ' + quotename(loginname) + ' with default_language = British;' from sys.syslogins where dbname = 'XXXXXXXXXXXX'
select top 1 @sqlCmd = sqlcmd from @l while (@sqlCmd is not null) begin print @sqlCmd exec(@sqlCmd) update @l set sqlCmd = null where @sqlCmd=sqlCmd set @sqlCmd = null
select top 1 @sqlCmd = sqlcmd from @l where sqlCmd is not null end