Not that special really, but it will be in the near future, when I've finished upgrading it 

http://www.4projects.com/GeneralImages/SysIntegAvailSec.gif

Sorry to those of you that think...

that would be telling

lol

You could well be right, maybe i'm just spoilt with our setup

It's nice to hear that the worth of DBA's is becoming more apparent, I personally hate the idea of moving IT to different countries because it's cheaper, in the long run its...

I messaged Steve too, he's replied saying thanks so i'm guessing they're working on it.

Probably just a poorly web server in the farm.

I'm guessing that you're rebuilding the indexes using a maintenance plan, I've seen this sort of thing before when I used to use them.

I've come to despise maintenance plans over...

I'm just about to head off home for the evening but if no-one has filled in the process by tomorrow morning i'll post it then.

Mike

I've seen them in this forum before (earlier in this thread for instance ).

If you want to attract their attention then you should...

ah, so you want to encrypt the actual physical files rather than the data.

That's already possible in the OS, just login as the account that SQL is running under and...

You can't do it directly but should be able to encrypt information comming in from a web server or application fairly simply though.

I know SQL 2000 has some inbuilt encryption...

The FTS for SQL only does files inside SQL Server, however, if you use sharepoint then i think you can set it up to do files in the OS.

I have...

Hi Andy,

Sorry for not getting back to you yesterday, I got called home for an emergency.

Anyway, I'm glad you got your first problem sorted but unfortunately I don't know about...

Also, can I confirm that you're connecting as a SYSADMIN to SQL to test xp_cmdshell works.

If not, then have you enabled it for non-sa users and set the proxy account...

You haven't installed any other MDAC stuff have you, i know it's a shot in the dark but it would probably let you and may cause similar problems.

In the meantime,...

sorry, just noticed you're on datacentre.

Will have a look and see if I come up with anything, were on EE so it might be different (can't see why though)