“Invalid object name” in SQL Server Management Studio (SSMS)

In this video we will show SCCM admins how to get rid of the invalid object name error that is caused by not being connected to the Configuration Manager (CM) database.

You know the error, we have all seen it!

Msg 208, Level 16, State 1, Line 1

Invalid object name ‘dbo.v_R_System’.

 

This video will show you how to set your SQL server default database to be the CM database.

Comments
pingbacks / trackbacks
  • […] database. You can start using it right away! This also means that you no longer get the error, “Invalid object name,” that you would see in SQL Server Management Studio […]

Leave a Comment