sql server 2008 r2 - SQL statement runs fine in TEST, breaks on PROD -

sql server 2008 r2 - SQL statement runs fine in TEST, breaks on PROD -

i'm executing next query on test db, works well:

select table_name name, (select top 1 value fn_listextendedproperty (null, 'schema', 'dbo', 'table', [table_name], default, null) name = 'description') [description] information_schema.tables tb inner bring together fn_listextendedproperty (null, 'schema', 'dbo', 'table', default, null, null) prop on prop.objname collate database_default = tb.table_name collate database_default , prop.name = 'settingtable' , prop.value = '1' order table_name asc

when executing on production db, next error:

msg 102, level 15, state 1, line 3 wrong syntax near 'table_name'.

test db version: 10.50.1617.0

prod db version: 10.50.2550.0

any ideas?

turns out prod db running in sql server 2000 compatibility mode.. setting 2008 resolved issue, , sanity. replies!

sql sql-server-2008-r2