Got it. Works perfectly.

Thanks for the help.

Robert

Thanks, learn something new every day.

AFAIK?? This is a new one for me, what does this acronym mean?

I have been running HT on W2003 for a while now without any issues or degradation, probably due to the number of small transactions.  It is supporting an ERP so there...

Really nice work.

The only thing I noticed is when using the xp_generatekey '256' function it does not provide a long enough key for the xp_aesencrypt as I get an error...

Hi all,

I have experienced a similar slowdown in EM performance. Removed replication from our server and the database is performing fine for our users, but not while trying to...

SQLBill, when you open Crystal reports, open a blank report and select your ODBC connection and within that you can then select the stored proc that you want to use.

Works...

I will have to try it. Once the data is safe the Repair_Allow_Data_Loss works fine, it doesn't appear as if data is lost, but I going to test some...

I have not tried it as this is a fairly complex data model, foreign keys, cascading updates and deletes, etc. Data loss would be a bad thing. I...

Yes, I get the same error. Doesn't matter if I use a script or I use EM. Have you seen this before??