We use both IsValid (default is 0) and IsDeleted (for soft deletes).

We use this in an update trigger to perform additional processing on affected child keys:

insert into @IntermediateData

select ROW_NUMBER () OVER (order by D.FOLDER_KEY),

...

Yes, it is odd. If there is anyway to keep the functionality in the app without requiring SA, we can update the code.

SA impersonation may not be acceptable either, but...

I used Lowell's procedure and it worked as advertised.

However, it does require creating the procedure in the master database AND setting TRUSTWORTHY ON.

Is this correct?

I was not able to get...

Thanks for the reply George and Lowell.

With the dbcreator role, I was able to create and access the newly created database.

Also, I was able to attach a database that I...