Thanks Antares, I was hoping that a query would be able to show me which tables are the top 10 tables based on the amount of space they occupy on...

I second what Antares said.  I see the error because there are two or more rows that have the info that you are deleting.  So if you query a table...

I am sorry to change the subject, but how do you span a table across multiple file/filegroups?   Thanks in advance.

A big thank you to everyone for your informative responses.  I removed the builtin\admin account and added the NT Authority\System as was said in this document from Microsoft. 

http://support.microsoft.com/default.aspx?scid=kb;en-us;263712

After...

I would like to see where Microsoft says that SQL Server does not use more than 2GB. Thank you.

Thank you!

Thank you very much!

I resert the Proxy account in the sql server agent properties page (and the checkbox is off).  Thanks for your help!

Thank you everyone, that is the exact info I needed! 

Thank you very much Steve.  So, if I understand you correctly, on RAID 5 (which is what we have), then the data is spread across all drives?

Hi Steve,

They are combined to be one drive to Windows.  As far as windows is conncerned, its drive D:  In what instances does the data get stored across all 4...

Hi everyone, thanks for your help.  I am not sure what you mean by

"Make sure your domain administrator have changed her last name first in windows user account. "

Her username...

Thanks Dan, I have made the change so that all databases will run in that mode...for now.  Are there any performance issues or any other issues that might come up...

Hi all, sorry for the delay in my response as I am having trouble getting to this site for some reason.

The delay occurs when I reboot the server.  I have not...

Thanks Allen for the help.

"Why not? As long as you restore last full backup and backups of transaction logs with non-recovery option, you should be able to restore last transaction...