Invalid object name sys files

It only takes a minute to sign up. Connect and share knowledge within a single location that is structured and easy to search. I connect database with Visual Studio When I am trying to execute a query then it shows the following error:. I'd guess the problem is your SQL Server login does not have it's "default database" properly set.

You can either change the default database of your login, or you can specify the database in the connection string. Sign up to join this community. The best answers are voted up and rise to the top. Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Learn more. Asked 3 years, 10 months ago. Please Sign up or sign in to vote. See more: C. Copy Code. Posted Feb pm Arjunwalmiki. Add a Solution. Vedat Ozan Oner Feb am.

Top Rated Most Recent. Accept Solution Reject Solution. Dear All thank you for support before query not work SQL. Posted Feb am Arjunwalmiki. Use this.. Posted Feb pm V Arjunwalmiki Feb am.

V Feb am. Look at my new solution ie. Posted Feb pm Mehdi Gholam. Posted Feb pm Basmeh Awad. Posted Feb pm King Fisher. Tables; this query is not working. If the issue still persists, then it could be due to IntelliSense Cache not refreshed. Please click here for a fix. Post a Comment. Fix: Immediately I changed the database name to the database where my table exists , the error is gone.

Tweet Share Share Share Share.