Scott,

I agree with the other participants that there is not enough information to provide the exact solution. The following script, however, may help you get started:

set nocount on

declare @table table...

While this may not be the most elegant solution, it does produce the desired result:

declare @table table (x int, y int, z int)

insert into @table (x, y, z)

select 1, 1,...

Here is a variation of the kill script that can be used on any database whether or not it is the current database. To use, set the @dbname variable to...