Wyfccc thanks for some great ideas.

I will looking into the Log Parser tool but if its executable needs to be on each server. It may not be worth using...

That problem has bitten me more a than a few times. I have yet to develop an approach to handle all jobs. For database backups, missing a backup could be...

Download the zip package under the Resources heading.

The one under Additional Resources does not work. Sorry

The SQL Overview package is missing a Truncate SQL statement for the table Jobs.

To add this to the package

1) Add an Execute SQL Task named "Truncate Jobs"...

Nice list of stored procedures. You pointed out a few I was unaware of.

Thanks for sharing the info

Nice script, except to convert bytes to gigabytes you need to divide it by 1073741824 Bytes

See http://www.123marbella.net/en/free-bandwith-calculator.html

It will be interesting to see how this game develops. Databases of sorts are used all the time in games to provide flexibility to the game design. Working so long...

Yes I agree with Rudy Panigas. This article is about free tools for a DBA. This does not mean tools with trial versions. Please refrain from adding responses with...

Great list.

Cumulative Hotfix 6 is available

http://support.microsoft.com/kb/946608/en-us

I found the package was missing the log used file size it was suppose to collect. The value being stored was NULL. It has been fixed in the package attached...

The attachment to this reply has been removed

Steve,

I get similar results using the SQLCMD. Most of those SQL Express instances are from Visual Studio installations on desktops. I just delete them from the table because I don’t...

Justin,

"OLE DB Source" can only connect to a one server at a time.

The Foreach Loop container is used to retrive the server values from the variable SQL_RS.

The server...

It is great to see the potential for this package’s capability has mushroomed.

In part two, I address how to handle the differences between SQL Server 2000 and 2005 when retrieving...

Corrections to error trapping instructions

1) Before setting connection to ADO.SQL_Overview, change ConnectionType

Here is the correction:

Under "Create OnError Event Handler"

- Settings - Double Click on Icon

General

* Name: Capture Errors...