I am using a sql squery to return the identity field when I fire a SQL query. My database is SQL server 7.0. But I am getting database error and I am not able to figure out where I am going wrong . Whether I should open the recordset in some different mode? Please let me know about it.<BR><BR>userid field is identity field.<BR><BR>strQuery = "SET NOCOUNT ON;insert into users( fields ) values ( values ); Select @@Identity as userid"<BR>objRS.open strQuery, objConn, 1,1,1<BR><BR>Response.Write objRS("userid")<BR><BR>I am trying different things but still is not working. So please let me know where I am going wrong.<BR>