Viewing 15 posts - 61 through 75 (of 117 total)
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...
June 3, 2008 at 10:18 am
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...
June 2, 2008 at 2:55 pm
Download the zip package under the Resources heading.
The one under Additional Resources does not work. Sorry
June 2, 2008 at 8:36 am
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"...
May 13, 2008 at 6:51 am
Nice list of stored procedures. You pointed out a few I was unaware of.
Thanks for sharing the info
May 9, 2008 at 6:00 am
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
May 7, 2008 at 5:42 am
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...
April 16, 2008 at 6:12 am
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...
April 10, 2008 at 11:56 am
February 27, 2008 at 9:22 am
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...
February 1, 2008 at 8:41 am
The attachment to this reply has been removed
January 22, 2008 at 8:50 am
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...
January 15, 2008 at 7:37 am
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...
January 14, 2008 at 10:15 am
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...
January 10, 2008 at 6:59 am
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...
January 8, 2008 at 9:09 am
Viewing 15 posts - 61 through 75 (of 117 total)