I have two table "t1" & "t2" as below:

create table t1 (a int PRIMARY KEY, b varchar(30), tstamp timestamp,)
create table t2 (a int, b varchar(30))

When i try to use VS2005 IDE --> Server Explorer --> Connect to DB --> Execute the stored procedure named "test",
exception "Failed to enable constraints. One or more rows contain values violating non-null, unique,

or foreign-key constraints." is thrown.

SP "test" has a simple select statement as shown below

SELECT
    t1.tstamp
FROM
    t1
INNER JOIN
    t2
ON
    t1.a = t2.a

The exception occurs only if the column of Timestamp Datatype is included.

Is there any restriction for Timestamp Datatype.