I worry if you're administering such a server! You will have to either remove builtin admins or make sure no-one can get added to the local admins of the...

I'd uninstall the sp and re-install, or just run it again, you might also have to go to 2187 to complete. I did have a sp not fully install once...

I have to be honest that for a production box I'd always prefer to stop the sql services first if I can.

to be honest I don't think you can, it's probably something to do with oledb. It's something I'm aware of but not thought much about. You could try setting a...

2 part naming in select lists has nothing to do with this. Issues specifically arise when stored procs are called without an owner e.g. exec myproc ...

we'll agree to disagree then! Everything I've ever learned in xxx years says raid 5 generates 4 io per write regardless of the number of spindles in the array.

I'm still surprised we're discussing this! David I agree - seen some strange things in 2000 too, will let you know if I find them in 2005.

If your code doesn't write then profiler won't show writes - I'm a little confused as to exactly what you're asking - you can always lift the execution code from...

you can use dml triggers which are database wide.

There wasa product I saw a demo of which used a sniffer to capture sql going to the server, so it didn't...

yeah raid 10 all the way. Raid 5 doesn't work that way that I know as it's extra is on the parity disk not the array. The more disks you...

if the table has a fillfactor this will remain unless you force it to 100%. This may give what appears a poor density. If you get values of 25%, 50%,...

sorry - if x32 what switches are in boot.ini

ok - this can happen - please give details of sql edition, o/s ( including sp's ) is this x32 or x64, how much memory, what are your memory settings...

you should save 50% space making this change unless somehow the columns have padded with white space. How are you measuring the size of the table?

I assume you're managing sql server through cluster administrator? If you take the service(s) offline you should be able to make your changes.

Agree that the error should be in the...