simple fix exec [database name].[object owner].[stored procedure name]

you must reference the database name in either the connection string or command text. Otherwise SQL will use the default database which...

Yes, that error occurs when your database collation is set to case sensitive.

Msg 208, Level 16, State 1, Line 1

Invalid object name 'SYS.DM_DB_INDEX_USAGE_STATS'.

To resolve, just CTRL+SHIFT+L to convert the text...

Thank you all. I really appreciate your feedback and will work with your suggestions.