Cannot find the object because it does not exist or you do not have permissions. Error in SQL Server
sql-server
Solution
Are you sure that you are executing the script against the correct database? In SQL Server Management studio you can change the database you are running the query against in a drop-down box on one of the toolbars, or you can start your query with this:
USE SomeDatabase
Problem
I have a database and have a Sql script to add some fields to a table called "Products" in the database. But when i am executing this script, I am getting the following error: ``` Cannot find the object "Products" because it does not exist or you do not have permissions ``` Why is the error occurring and what should I do to resolve it?