I do need help now , Thanks for any help.

Check out the metadata function COLUMNPROPERTY in SQL Server Books Online.
Its third argument can take a value 'IsIdentity' which would be what you are
looking for.

obtaining the ip address of connection
Use a stored procedure from a function
triggers
Anything better than TSQL?
Urgent! - time out errors while inserting into the dB