From object explorer, click the tablename --> statistics, it shows all the statistics (index and _WA_).

Right click each statistics, it shows details about this statistics.

Thank you vyas. I read this post. MDAC on my server is 2.82.1830.

I am wondering what the possible root cause?

I will try to export...

check this..."Managing User Access"

http://www.sybase.com/detail?id=1011503

Congratulations! I thought you were a MVP already 🙂

This link may help.

http://www.sqlservercentral.com/articles/Administering/unmarksuspect/137/

Any error message from errorlog? Check why it is suspect.

Back up to local disk, then copy over to the network. The local backup is handy whenever there is a need for recovery. It is faster than restoring...

Free some disk space for log file and try DBCC DBRECOVER (dbname)

Please refer to:

http://msdn2.microsoft.com/en-us/library/aa937568(SQL.80).aspx

or BOL search "Insufficient Disk Space".

check this post:

http://www.sqlservercentral.com/Forums/Topic359308-338-1.aspx#bm361850

Maintenance plan has a cleanup task to do such things. There is a bug. It has a fix now. http://support.microsoft.com/kb/933508

How do you plan a database backup?

This is an open question. Depends on how much s/he knows and how much considerations from both database and business perspectives.

Replication may be an option if you need only a portion of the tables rather than the whole database for reporting analysis.

Transactional replication require primary keys on tables to be...

Transaction log is 80 MB only? It is so small. Why bother to shrink it?

If it is full recovery mode, should have transaction log backup in...

Finally I found a recent KB for this.

Microsoft SQL Server 2005 Service Pack 2 issue: Cleanup tasks run at different intervals than intended

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

exec this stored procedure XP_fixeddrives and store the output into a table or a temp table. Then query your table.

CREATE TABLE x (drive char(1) PRIMARY KEY, FreeSpace int NULL)

INSERT...

using "select * into currentdatabase.dbo.droppedTable FROM RecoveredDatabase.dbo.dropppedtable" will get the data only. You may lose the index, constraint, or permission if any.

You can script out the table schema from...