I don't think that's true. You don't need to grant a user rights to a table, if the table owner and the stored procedure owner are the same.

I need to...

Being clear helps in that perhaps there is something specific to what you are accessing.

In this case, I am surprised that you cannot grant select to these views. Perhaps there...

I assume you know how the script works and are not just running some random code on your server. There is a filter event for the duration, and you need...

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...