Thank you Tracey.

Hi - could you tell me how to change the DB owner by right-ckicking the DB in SSMS please? I've looked at the Options (SQL Sever Standard) tab as The_SQL_DBA...

Are you using SQL Server 2005? If so, do as Andrew suggested and read up on the datatypes. VARCHAR(MAX) in 2K5 can hold up to 2GB of data....

Do you think that maybe this line in the error message might hold a clue?

'Cannot send mails to mail server. Mailbox name not allowed. The server response was: Sorry,...

I don't think it's so subtle a difference. If a login is disabled, as rbarryyoung said, it can't do anything at all. If it's enabled, you can chose...

Do you mean why use domain accounts for the SQL Server services rather than the local system account? If so, it's because the local service account can't access...

Hi,

Why don't you do a daily SQL Server backup for your principle database(s), which won't break your log chain, then backup the .BAK file with BEX. The log backups...