Hi!

I have a stored procedure (SQL 2000) in which i make an insert in a table. Some of the columns in the table are:
ID (int)
FileName (varchar)
[Time] (datetime)

The problem is that "ID" is the primary key, and configured as "Identity". Whenever I make an insert, the value of this field is automatically generated. I want to return the number that is generated at insert, but I don't know how to!? I hope someone can help me! Great forum btw...

/M