• Truncate does not fail for me...?

    CREATE TABLE [dbo].[CustomerMaster](

    [CustomerId] [int] IDENTITY(1,1) NOT NULL,

    [CustomerCode] [varchar](30),

    [CustomerName] [varchar](200),

    [CreatedDate] [datetime],

    [ContactNo] [varchar](20)

    CONSTRAINT [PK_CustomerId] PRIMARY KEY CLUSTERED

    (

    [CustomerId] ASC

    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

    ) ON [PRIMARY]

    GO

    CREATE TABLE [dbo].[CustomerDocuments](

    [DocAttachmentId] [int] IDENTITY(1,1) NOT NULL,

    [CustomerId] [int] NOT NULL,

    [DocumentType] [varchar](5),

    [DocumentName] [varchar](200) NULL,

    CONSTRAINT [PK_CustomerDocs] PRIMARY KEY CLUSTERED

    (

    [DocAttachmentId] ASC

    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

    ) ON [PRIMARY]

    insert into [CustomerMaster] (CustomerCode, customerName, CreatedDate, ContactNo)

    values ('ABC','ABC','1/1/10','0000000')

    insert into CustomerDocuments (CustomerID, DocumentType, DocumentName)

    values ('1','123','123')

    insert into CustomerDocuments (CustomerID, DocumentType, DocumentName)

    values ('1','456','456')

    select * from CustomerDocuments

    select * from CustomerMaster

    TRUNCATE TABLE CustomerDocuments

    TRUNCATE TABLE CustomerMaster

    SELECT IDENT_CURRENT( 'CustomerMaster' )

    drop table CustomerDocuments

    drop table CustomerMaster