Can't change the contents of a table in SQL Server2005

Last Post 23 Feb 2013 06:59 AM by gunneyk. 2 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
Ayyaz Mirza
New Member
New Member

--
20 Feb 2013 11:08 PM
Hi,
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:

USE [DSS]
GO
ALTER TABLE [dbo].[tblGlob] DROP CONSTRAINT [DF_tblGlob_BYDEFT]

USE [DSS]
GO
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)"
Regards!
Ayyaz
rm
New Member
New Member

--
21 Feb 2013 04:45 AM
It's not permission issue but syntax related, can you post your t-sql statement?
gunneyk
New Member
New Member

--
23 Feb 2013 06:59 AM
And the entire DDL for the table as well.
You are not authorized to post a reply.

Acceptable Use Policy