sql server mseq: Violation of PRIMARY KEY
constraint 'PK__tablename__182C9B23'.
Cannot insert duplicate key in object 'tablename'.
The statement has been terminated.

The error that you are getting is related to the violation of "PRIMARY KEY"
constraint. To know what primary key is defined on the table run the
following statment.

sp_pkeys <table name>

Make sure that you are inserting non duplicate values in the primary key.

ex:

create table t(idd int primary key)

insert into t values (1)
insert into t values (2)
insert into t values (3)
insert into t values (3) --error

in above case 4th insert into will fail because of duplication of primary
key value.

--
Vishal Parkar
vgparkar@yahoo.co.in | vgparkar@hotmail.com