I have a problem that in a database (named DDS) i can change or delete records in all tables but there is one which i can't. There isn't any primary or foreigh keys(There is one dependency, a view). So could you please tell me that is there any way that while designing a database in SQL Server we can lock a table and is there any way to remove that lock and change the values of a field. There are two constraints on this table as:
ALTER TABLE [dbo].[tblGlob] DROP CONSTRAINT [DF_tblGlob_BYDEFT]
ALTER TABLE [dbo].[tblGlob] DROP CONSTRAINT [DF_tblGlob_SetValue]
(these two fields BYDEFT & SETVALUE have data type as bit.)
Even if i delete these constaints, still i can't change the data in this table. I am trying to change a field named company_address. I can't even delete a record from this table.
My login has all permissions.
Here is the error i get:- " The row values updated/deleted either donot make row unique or they alter multiple rows(2 rows)"