would you look at that, I post and within minutes have the answer! 🙂

Basically, you have to grant permissions on ALTER TRACE and VIEW SERVER STATE. These can be accessed...

Get a backup of the database and run the following

select * from information_schema.routines where routine_name ='NAME OF YOUR PROC'

I'd also suggest some source control, we use Subversion and it's quite...

they probably use a key to encrypt the data (datakey), which is stored with the encrypted data, and a master key to encrypt the datakey. They probably used a data-iv...

thanks guys, that was exactly what I looking for.

as far as i know, there isn't a native way to do this for SQL Server, unless you count the CLR in 2005. You'd either use that to decrypt it...

Got the latest HP service pack applied, and now we're monitoring the server to see if anything... no, I won't tempt fate!

Thanks for...

we've applied the service pack, but we are running an HP box... I'll disable the ILO in the morning.

Thanks for the reply, really appreciate it, was starting to tear bits...

thanks, that worked. Much appreciated.

It seems I've found (a) the culprit. I've posted this in case it helps anyone else.

From

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=381890&SiteID=1

SQL server uses local group for ACLs. When server is installed the groups...

Thanks, both of you. I can now pick the acccounts and I'm printing off the best practice doc as we speak.

Unfortunately, even though the setup now allows me to select...

Thanks very much, this seems to be exactly what I was looking for (but couldn't find). Very much appreciated, to everyone, for helping.

Sorry if that wasn't clear.

I'm referring to virtual memory.

I prefer to use pastel colours that are light, instead of white. I use a medium-light pink on VS (nice contrast to the colour coding too), and and eggshell on...

Well Mike C, you are right, I must apologise for attributing the slave comment. I misquoted you. Classic AND ironic, always the sweetest way. As for the rest, it all...

The eugenicists were never scientists, it's a philosophy. And are you truly comparing those who do research into the brain using open, standard scientific methods and publish their results in...