-- create the table to start
-- create table SneakyIdentity(rowid bigint identity PRIMARY KEY)
-- drop table SneakyIdentity

-- insert bumps "next identity row" but the rollback prevents the row from getting saved
begin transaction
insert into SneakyIdentity DEFAULT VALUES
rollback transaction

-- IN USP, this would actually be an OUTPUT parm so wouldn't need to declare here...
declare @uid bigint								
select @uid = Scope_Identity()
select @uid Retval

-- the table stays empty
select * from SneakyIdentity