You can specify exactly which table to return, by default it will return all three options.

To return the second table as you have specified run the following:

DBCC SHOW_STATISTICS(Table, Index) WITH...

Olla Hallengren has created some awesome maintenance scripts, you can check it out here: http://ola.hallengren.com/%5B/url%5D

You'll need to schedule the sp's via SQLcmd using the windows task scheduler.

Rich

Sorry it was late and my last post wasn't very clear.

Assume we have the following fictional backup strategy going on:

The database in FULL recovery mode.

Daily Full backups at 00:00

Daily differential...

I have never heard of an auto archive function. There is no way that microsoft would be able to implement something that audits every table in every user database that...

Yes it's true, I've had it mentioned to me several times by an MCM that as of 2005 transaction logs will not break the log chain. Nice feature.

Check if you have any open transactions and how long they have been open for. You may find that there is some dubious code somewhere that is leaving transactions open....

chris.s.powell (7/27/2010)

---

Is this a full backup being taken? If so, try running a transaction log backup five minutes prior, this will shrink the log file, which will make the...

I'm guessing I know the answer to this already, but here goes....

Have you been backing up your binaries folder? If you have been then you could pull all your logs...

We tend to use scripts where I work as you can micro manage things easier. For example with the index recbuilds in maintenance plans it's generally an all or nothing...

You might like to look into the EXECUTE AS clause in your stored procedure where you would run under an account with high level permissions. You would then grant EXECUTE...

A 4GB file is really excessive, my immediate thoughts would be that they may be backup files.

There are some really good text editors out there and as one person...

You would need to assign the DROP DATABASE permission as a minimum.

This link to Books Online should tell you everything that you need to know.

Rich

hxkresl (7/17/2010)

---

I expanded the SQL Server Agent logs and found "An idle CPU condition has not been defined - OnIdle job schedule will have no effect".

Is it possible...

Do you have DBMail set up on your server?

If you do then take a look at the stored procedure sp_send_dbmail in BOL. You may need your DBA to grant permissions...