Home / SQLDBManager Plus Troubleshooting / SQL Server Monitoring / Custom SQL Query - Invalid Object Name

Custom SQL Query - Invalid Object Name


8. While adding a custom SQL Query i am getting an error "Query : - Got Invalid object name"

Reason1 : The table name mentioned in the query is wrong
Solution  : Verify the sql table names mentioned in the query. Also execute the query in SQL Server Management Studio and check if you are able to get the output

Reason2 : Database name and schema name are not mentioned in along with table name
Solution  : Mention the database name and schema name along with the table names in the SQL query. For ex: select * from MESQLDBM.dbo.Alert

If this problem persists, send a screen shot of the error message from the SQL Server > Query tab and Support Information File ( Support tab > Support Information File link ) to sqldbmanagerplus-support@manageengine.com .




 RSS of this page