I have a stored procedure that has several functions in it.
Two of them are:
Truncate a table
Insert to that same table.
I truncate (rather than) because I thought that was the best way to get the index (seed) back to the number 1.
I need to assign a DataBase Role the ability to truncate to they may execute this Store Procedure.
Execute As Self looks like it may work BUT, I can't seem to get it working in 2000 (MSSQL 7).
If I can't use Execute As Self, maybe I just am not using correctly, which other permission is the best to grant.
I would really appreciate your help,