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

Custom SQL Query - Invalid Object Name

Tags:  

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 .


Post a comment

Your Name or E-mail ID (mandatory)


Note: Your comment will be published after approval of the owner.





 RSS of this page