>>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.
If it's not broken, fix it until it is.
My Blog