Sorry for the late reply, and thanks for the code. I was playing around with it, and it looks very useful. Unfortunately, though, it doesn't help in this case. Since...

That was going to be my next tack, if this dynamic SQL approach wasn't going to work (or was a bad idea). This trigger code is ultimately meant to enforce...

Thanks! That's exactly what I was looking for.

Ask me if this is extending this question too far, and I'll ask in another thread ....

When I tried to implement the following...

I like the idea of consistency across environments. Thanks for the help.

--=cf

Thanks for all of the assistance. I performed the maintenance over the weekend (switching some to SIMPLE then back to FULL where it made sense) and everything went great. I...

George,

You're right, the file isn't 99% unused, it's 99% used. I interpreted that backwards. I can see the need for the checkpoint now.

--=Chuck

This particular database can endure no more than an hour's worth of data loss. So the prior employee has hourly differentials running with a nightly backup, with the database running...

Right there in the error log. Thanks!

Login failed for user 'sa'. Reason: An attempt to login using SQL authentication failed. Server is configured for Windows authentication only. [CLIENT: <local machine>]

--=Chuck

Thanks for the reply. I think we're leaning that direction, more heavily than the multi-instance approach.

I know that estimating another person's environment is not a fair question, so maybe...

And so if I examine every Agent job, and none of them list a step which executes *.dstx file that resembles the "name" column from:

select suser_sname(ownersid), t.*

from...

So, I've been looking through my databases, and I was unable to find any SSIS packages until today. But now I'm a bit confused. I have been using the terminology...