Hi,
I am writing very basic query.
The same query is executing properly in new database.
use Finance
alter table tblFin
Add ComPurpose Varchar(100);
Error:
Cannot find the object "tblFin" because it does not exist or you do not have permissions.
Note: If i manually try to create column by right clicking on Table and then from design option Add column, Column gets added properly.