Let me know if I have this right.  Are you trying to add a login that is refered as the actual server?  If so you...

We have the same random problem just in a different scenario, it will show as mm/dd/yyyy then one day a new object is created and it shows as yyyy-dd-mm.  But...

san43 do you want to run the job manually for one night or will it be permanent? My comments were if it is just temporary.

If it is continual then you...

Is it sql 2000 or 2005?  If 2000 then since you don't want the 8pm job to run disable the job for the night (remember to enable after that run...

PerfectDisk by Raxco is a good one.  If you have big disks (at least 1 terabyte and above) then you will notice a 20%-25% faster defragmenation time.  If your drives are smaller...

It won't cause a problem running it while SQL Server is up.  You don't have to stop the services.  But again like John said your data and log files would...

Using disk defragment tools does help with database performance, but you should never run it during production hours on a production database.  The disk I/O goes up significantly when an application like...