Thanks a lot friend....i found the issue, if the column is not null without any default value, it is throwing error, in this condition it is working fine.

USE [prgtest]

GO

/****** Object: Table [dbo].[Department] Script Date: 04/17/2012 15:49:39 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[Department](

[DeptNo] [int] NOT NULL,

[DeptName] [nvarchar](max) NOT NULL,

[EmpCount] [int] NOT NULL,

[Location] [nvarchar](max)...