I don't quite know how this works. It was surprising to me as well. i suspect this is some strange holdever from the past, perhaps some poorly designed behavior in...

Glad you liked it and learned.

Not that I've seen. Feel free to experiment and write this one up

We are doing work on a new site now. I've asked if this is in there, but I might suggest forwarding notifications with a rule to work and leaving the...

OK, you weren't clear in the explanation.

If you are loading data from staging to target, not updating,but new data, there shouldn't be many locks. You might have minor...

I'm not sure I'm ever going to forgive the PoSh builders for using -eq instead of = or ==. I just lost 30 minutes trying to debug a script that...

Ah, sorry, Rod. There are two places for subscriptions. You're looking at the ones for the forums. I assume those are the emails you're not getting? Nothing I've seen has...

Quick summary of what I'd do here.

Since I'm changing the timezone of server, all existing data will display incorrectly, while all new data is correct. Therefore, I need...

+1 one for the synonym. You could use a view as well for client access, but this is more of what a synonym is for.

the more complex your environment is, the less likely you'll have one screen to view it. However, you could have one screen that lets you know where things need investigation,...

SQL Audit will do this if you need this to be accurate and secure. Someone can turn it off, but that will be logged as well. However, as mentioned EE.

In hindsight, I should not have posted publicly and I apologize for that. I had ignored a few in a row, but was rather annoyed myself at the comment that...

I deleted the post from edwardwill as it was unprofessional and contained profanity. not sure why the filter here didn't catch things, but I removed it from here and from...