Will check.... Is 'auto close' good or bad?

Thanks for the note..... Space does not seem to be an issue (14 GB free). I'm left with the feeling that it's a memory problem and I can't...

OK, to wrap it up, I'll identify fragmented tables using DBCC SHOWCONTIG (Scan Density); then drop and recreate any clustered index (or create a new clustered index)(without...

By unload/reload I mean the data is actually moved around and defragmented. I don't know of any utility, DBCC or otherwise, that will do this for table data, not...

But does the data actually get re-loaded so that if there was a table scan it would be efficient?

Thanks for your replies. We are having a lot of trouble getting email off that server - I am working with MS tech support as we speak.

How...

Thanks for your help. I found that the script generated by my M Plan caused a syntax error because I named my Operator Jim's Operator - the quote mark...

To All:

Thank You!

Only 1 instance of SQL Server and Outlook is NOT running. Maybe I should set the Delivery option in the mail profile to <None> instead of Personal Folders.....?

Ignorance is my only defense - Should I avoid Personal Folders, if so, how do I remedy this?

Tried xp_sendmail and get 'Mail sent.' message, but did not receive email (Lotus Notes email).

You guys are great! We're still beginners, using EM mostly. Will try using QA more, and 'with recovery' next time!

Thanks John! I deleted the database and will try a new restore! Never found the pid.....

Hi John,

I ran from Master and get the following - database is still marked 'Loading' -

File 'Changepoint' was only partially restored by a database or file restore. The entire file...

Can't do anything with the database:

Server: Msg 927, Level 14, State 2, Line 1

Database 'Cptrain' cannot be opened. It is in the middle of a restore.