>>>I'm thinking there is no way to achieve your goal. You need to insert a record in order to get the ID. You can not get the ID without inserting.
>>
>>Why? I can do that with native tables and using a GUID as a key. There should be a way with int too, just not found yet:)
>>Cetin
>
>You can not get an ID with AutoInc fields in native either without an attempt to insert (or hacking DBF), I'm thinking this is the case here in SQL Server as well.
>
>In other words, it's an internal thing hard to get.

And BTW with IDENTITY (don't know autoinc as I don't use but probably there is a trick) I can set an ID explicitly to a value I pass that I might get from IDs table. It's tricky,expensive and trying to keep away.
Cetin