Hey chaps,

Thanks a lot i was able to expand the tables. Used the command "dbcc opentran" and killed the id's.

Thanks a lot.

I have two tables eno and eid in my emp table. I have inserted some values where eno is a primary key. So, the table looks like this

eno ...

Hi,

I have created a table

CREATE TABLE emp(eno int identity(1,1), eid int)

Inserted values

INSERT INTO emp VALUES (1)

INSERT INTO emp VALUES (2)

INSERT INTO emp VALUES (3)

INSERT INTO emp VALUES (3)

INSERT INTO...

Where the active directory is there and what is meant by DC's. Can you just elucidate it further more.

Where the active directory is there and what is meant by DC's. Can you just elucidate it further more.

I'm using default windows account to log in to SQL Server 2005