The issue with encryption is that many times the DBA can still get to the keys, or add themselves to the group that can access the keys for encryption/decryption.

Or they...

What you'd want to do is extract out the month and date using substring. Then you can cast this as a number, and sort appropriately.

So

Where cast( substring( field, 1,...

There's no way to do this other than logging the data. It doesn't magically exist anywhere in the server.

A server side trace, which you can template out from Profiler, will...

Your format is wrong.

select a

from tableA

inner join Table B

on a.x = b.x

WHERE a.y = 1

The joins come before the WHERE.

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