Also, you can use SETUSER to run this for any login, and then REVERT back to your user. Add a script around that and you can easily get all permissions.

It's going to be a huge mess in any case. The dump of permissions for objects for users is a huge amount of data, and it's impossible to read. It's...

On the log files not shrinking, there is a script on this site (Forcibly shrink[/url]) that cycles through transactions and clears the virual files, moving them to the beginning and...

First, the sp_ issue is a problem, and you could avoid it. spXXX is fine.

Many people choose a standard for procedures (usp, USP_, sp), but I rarely see tables prefixed....

Michael,

First you need to clarify 32bit v 64bit as so many systems are moving to 64. Second, I think you are correct for 32 bit. Once you go with AWE...

I thought this was great, and I learned something when this came through.

I don't know how this is related to ACID, but it's a nice little loophole for logging things....

Never satisfied, are we Hugo?

I have changed it to "B is returned. A simple change that would be better: ..."

It hurts my eyes just to read those. I have the feeling I won't even be able to communicate with my grandkids if they start typing like that.

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