sql-serverssms

SQL Server Management Studio won't recognize a tables


enter image description here

This happens frequently to me, SQL Server doesn't recognize my tables.

I tried to refresh the database, also tried to refresh the intellisense. But nothing worked!

Could anyone help please?


Solution

  • Can you ensure that you are not running this against the "master" database? When setting up a user, if a default database is not specified, when you connect using SSMS it defaults to master.. change the db or use the use[your database] statement before you run any other queries.