create table test_identity
(ti_Seq_Num int NOT NULL,
  ti_Ref_Num int NOT NULL)
go
alter table test_identity add ti_Seq_Num1 int identity
alter table test_identity drop ti_Seq_Num with no datacopy
exec sp_rename 'test_identity.ti_Seq_Num1', ti_Seq_Num
go
create proc slp_add_test_identity(@ti_Ref_Num int)
as
begin
  insert test_identity (ti_Ref_Num) values (@ti_Ref_Num)
end
go
exec slp_add_test_identity 1
go
reorg rebuild test_identity
go
exec slp_add_test_identity 2
go