aruram,

have you checked SQL's errorlog and NT event log?

Have you tried updateusage with COUNT_ROWS option?

Check this article from Microsoft:

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

Brett,

Can you, please, try to run your xp_cmdshell '...' from QA again and post the exact error message?

I also sent you a private message with more questions.

Brett,

First of all, let's try to execute the command successfully from Query Analyzer.

This is from BOL:

"When xp_cmdshell is invoked by a user who is a member of the sysadmin fixed...

What's the Windows account under which your SQL Server is running? Does it have permissions to see your source and destination servers and folders?

Try:

UPDATE OutstandingInvoices

SET Status = 'Cleared'

FROM ClearedInvoices C INNER JOIN OutstandingInvoices O ON C.InvoiceNumber = O.InvoiceNumber

The main point of the question was to bring the database up as quickly as possible. Then the answer is correct - the attach (single file attach in this case)...

Neil,

Instead of "running" the view in the Enterprise Manager try to use SQL Query Analyzer. After you've created the view open Query Analyzer and run

SELECT * from <YourViewName>

Query Analyzer doesn't...

Run rebuild master utility. Then if you have a backup of your master you can restore it, otherwise you'll have to re-configure your server and re-attach all DBs.

First of all, Microsoft doesn't recommend to backup to compressed folders (with no clear explanation why)!

On one of our servers we had to compressed the backup folders couple month ago when...

Copy data files from SQL Server CD to a harddrive and make sure that Read-Only attribute is unchecked.

See http://support.microsoft.com/default.aspx?scid=kb;en-us;273572 for details

Check this article from MSDN about logins transfer:

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

HOW TO: Transfer Logins and Passwords Between Instances of SQL Server

It's up to you to decide if you want to transfer master/model/msdb...

With restore you have to remember that you can only restore the full backup for master, model, msdb.

The idea is that the data in system databases are pretty stable and...

Both master and msdb have simple recovery model. It means that you can't backup transaction logs for those DBs (I'm wondering how it was working before). The maintenace plan wizard...