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