>Michael
>
>Select @@identity

Doesn't work, returns null if you have an uniqueidentifier column but don't have an identity column. Try this:

create table dum (bz uniqueidentifier, c varchar(10))
insert into dum (c) values ('zz')
select @@identity

I'm getting a null returned (MSDE 2000).