0

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

3
Contributors
6
Replies
18
Views
4 Years
Discussion Span
Last Post by ChrisHunter
0

Here is the DDL for this table:

USE [DSS]
GO
/****** Object:  Table [dbo].[tblGlob]    Script Date: 02/21/2013 14:09:40 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[tblGlob](
    [PrinterName] [varchar](50) NULL,
    [GlobalExpiry] [varchar](50) NULL,
    [DBSTATUS] [bit] NULL,
    [BYDEFT] [bit] NULL,
    [CompanyName] [varchar](200) NULL,
    [CompanyAddress] [varchar](200) NULL,
    [SettingName] [varchar](500) NULL,
    [SetValue] [bit] NULL,
    [Organization] [varchar](200) NULL,
    [Phone] [varchar](50) NULL,
    [MODIFIER] [varchar](50) NULL,
    [LAST_MODIFIED] [datetime] NULL,
    [OPERATION_TYPE] [varchar](50) NULL,
    [BankName] [varchar](500) NULL,
    [Logo] [image] NULL,
    [Email] [varchar](200) NULL,
    [Website] [varchar](200) NULL,
    [EmailServer] [varchar](500) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
SET ANSI_PADDING OFF

Ayyaz

Edited by ayyazm64

0

I am trying to change the data in one of the fields named company_Address manually right sitting on the table.

0

You need to be less vague about what you want to do. Do you want to insert net data, update existing data, delete data? What have you tried so far to solve the problem? and by that I mean what have you done other than create the table.

I will try to help you but I need to know what it is you actually want and see what you have already tried before I can

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.