Hi,

Thanks for the reply.

I do not want to give direct select permissions to the table as it contains some sensitive information. By only having execute permissions on a stored procedure, this...

Thanks John.

Dave

We were recently forced to upgrade to SQL 2005 for some new servers that we were preparing. When we tried to order new SQL 2000 licences from Dell we were...

Hi

I've just looked at the following:

Encryptinizer from http://www.netlib.com

SecureDB (http://www.valyd.com)

DBEncrypt from http://www.appsecinc.com

We have ended up opting for SeureDB from valyd. It offered all the...

Hi,

The data is already in a separate database on the contingency server. The problem is that we need to keep the data for 7 years, and our contingency server will...

Hi,

I don't know if you have already sorted this out, but we are also currently having the same problems, most things I've found on the we point to a network...

hi,

If you know all the possible values of the parameter that will hold the database name you could have a set of IF statements at the beginning of the procedure like this:

If (@parameter...

I thought it might be because there were no events longer than 1500ms, so I set the filter to anything greater or equal to 1ms and ran the trace again...

I was filtering the trace for everything over 1500 ms, for the same reason (to reduce impact on the server) but one day when I started the trace there was...

thanks Mike,

I've just re-checked and I'm definitely logging the completed events, and we're running SQL 2000 standard with SP4

Where is the message logged about missing data? the SQL event log?

I'm reluctant...

thanks Rudy.

I've looked at most of the articles here and am currently evaluating a couple of third party options. I thought of SQL 2005, but there are no plans for us...

Amish / hot2use,

Thanks for your suggestions.

cheers

Dave