I've tested a few other scenarios:

When I create a Job that runs the Select SP in a TSQL Job Step, rather than within SSSI connecting to the Listener, the Job...

Chris, that is the kind of info I'm looking for. SOX seems to be primarily centered around all things financial.

The paper trail for code changes, etc, can you point...

Thanks for the response Kraig.

I'll see what I can find out from TPTP here at our Univ regarding Sox Compliance. Additionally, are there any other compliance and controls standards...

3 questions about a public university IT environment.

1) Do we 'have' to be SOX compliant? Most of what I read talks about corporations and businesses. What about a...

Everything is still working good, I've re-arranged my Task order to match yours as well.

One question, on our Insert Statement... The Select Portion...

SELECT

INPUT_TABLE.Key1,

INPUT_TABLE.Key2,

INPUT_TABLE.Key3,

'E' AS Action_Type,

GETDATE() AS Action_Date

FROM Input_Table INPUT_TABLE

WHERE NOT...

Ed, your Queries have passed my Test! They are so much simpler too.

I have to incorporate the same logic with an Instructor Field (actually there are 3 Instructor Fields...

Thanks for the Reply Ed.

I too use 3 'Tasks'. I'm not sure if the Order of the Tasks is ultimately important, but if it is, I have chosen to...

Ed, I ran into a snag on the 3rd Step of my testing...

Here is the Merge I'm using:

Merge Change_Table as Target

Using (Select Key1, Key2, Key3 From Input_Table) as Source (Key1,...

Ed, thanks for the Reply.

I've got the code you provided working with my tables and I'm testing it out :-)!

Thanks, I will update you with my results soon!

Thinking about this a little more, I may need to incorporate a Group By and record the number of records for a given combination, I'm not currently doing that.

I have successfully removed 1 data file where there were multiple data files within the same Primary File Group.

I inherited a DB that has 2 mdf's and 2 ldf's on...