Did restarting db server help?

It looks like the restore process is yet not finished updating information about the restored user database in master db.

This gentleman had the same issue and was able to resolve. It might be helpful for you...

http://www.sqlservercentral.com/Forums/Topic288705-149-1.aspx

Again, what do you expect from the query?

As a best practice, you should script out your indexes. Drop them before the load, perform your load and then recreate them. When you talk about millions or rows, keeping...

Did you try to use gmail SMTP?

this thread may be helpful...

http://www.sqlservercentral.com/Forums/Topic690626-146-1.aspx

Navnish

try this one....

http://support.microsoft.com/kb/312839

Navnish

Do you have an option to install Outlook client only?

Navnish

IO subsystem of your box might be saturated and could not handle the load of DBCC CHECKDB on this large database. CHECKDB generates tonnes of IO very quickly and you...

See if this helps.

http://support.microsoft.com/kb/319701

Thanks

Navnish

It updates both the indexes.