Phil Factor is constantly complaining about this as well. I heard a fix is in for a Sat deployment, but we'll see.

The responses are pretty funny. Actually chuckled out loud.

For the OP, the emails get sent within a minute or two. It's a process that runs every minute, so worse case...

Keep in mind that denying permission might result in errors and then phone calls.

Why do you want to prevent this? They don't take up much space.

Please drop examples of issues in here. It's not that we don't want to fix this, but it's a complicated problem, especially when trying to render different types of code...

We're a long way from needing bigint, but if anything were to get that large, this would be it.

The tlog backup won't matter. If there isn't much happening, it's a tiny file. Better to have it than not.

As far as space, I'd agree you need 3-6 months of...

I don't have time to test, and perhaps this works better in 2005/2008, but I know that a NOT IN() or a has resulted in a table scan before...

I think lots of people Google, but lots of them don't know a) how to search and b)there are too many results.

I've seen people try to search, and the terms...

BTW, it's good to be back, and I have no idea what happened in this thread, but it certainly has a lot more posts.

Paul, I missed that one in the article, but as an FYI, when you write something, you do want to focus on the topic, and not get too distracted on...

I don't think it matters here, what is backed up and restored. If you back up the publisher last, that should ensure all changes are in the backup.

I'm not sure what you mean by server types. Do you mean subsystems installed? Do you have a list of what you are looking for?

These aren't "registered" with your...

Do you know what horizontal partitioning is? This sounds like an interview question. If you give us some thoughts, or what you think (or don't understand), we can help. It's...

Bi-directional is a type of transactional replication. Do some research on that. You can use merge, which gives you more control over collisions, but also it is more complex.

Snapshot will...

I think it's good to get away and recharge. Not sure about 4 weeks, but perhaps that's cultural. It's been a long time since I've taken this much time away,...