bobw1776 (11/30/2011)
I haven't read through the above replies to check, but has anyone received the below error ONLY when the SP is executed against a CS collated DB? e.g. "SQL_Latin1_General_CP1_CS_AS""
Msg 208, Level 16, State 1, Line 2
Invalid object name 'SYS.DM_DB_INDEX_PHYSICAL_STATS'. "
It runs fine on any other DB. It might be the solution to my failed indexing scripts, won't know until I get it running for a little bit.
Thanks,
Bobw
Bobw,
Hi,
Ask a question in general forum ---> http://www.sqlservercentral.com/Forums/
you got 'Invalid object name' error the DMV available on 2005 onwards.
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/