Community and Support
            Knowledge Base Analytics Plus Importing Data Local Databases ServiceDesk Plus database

            Error: Invalid object name "Table name" when connecting to database



            Issue: One database connects and executes with the same credentials when the other one throws an error with the same credentials when executing/selecting a table from the list.
            Error: Invalid object name "Table name"






            The issue was, The working DB's tables work when 

                Select * from databasename.dbo.tablename

            while the one not working works only when you execute

                Select * from databasename.common.tablename


            Workaround: Asked customer to use custom query using "common"
            Updated: 05 Oct 2017 03:56 AM
            Helpful?  
            Help us to make this article better
            0 0