CREATE TABLE #temp

(

ID int PRIMARY KEY,

Name varchar(900)

CONSTRAINT UN_Name UNIQUE(Name)

);

The #temp table created with 900 bytes, but

CREATE TABLE #temp

(

ID int PRIMARY KEY,

Name varchar(1000)

CONSTRAINT UN_Name UNIQUE(Name)

);

if i try to create table with 1000 bytes, it shows the below error... But the temp table created and 3 rows were inserted.... Then what is the maximum length can we use? Please any one give explanation for this....

Warning! The maximum key length is 900 bytes. The index 'UN_Name' has maximum length of 1000 bytes. For some combination of large values, the insert/update operation will fail.

nice question....