Resume SP if create index failes

[tJoe]

I have an SP that creates an index on a temp table.

create unique clustered index #i_tmp on #test(ID1, ID2)

In the case that we get a duplicate record, I would rather the procedure ignore the create index statement and continue running rather than cause the entire sp to fail.

Is there a way to do this?

 

[PDreyer]

proc code...
exec ('create index...')
more proc code...

But if uniqueness is not important, why not just create a non unique index?