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 .
Uploading ....