This is great work! Thank you very much for sharing your work.

I ran into the "Arithmetic overflow error converting expression to data type int" on the dba_CheckFiles job and traced...

A Sounders fan too! This is unbearable 😛

Thanks for the advice Sean, though I'm a bit reluctant to take it from a Sporting KC fan 🙂 GO TIMBERS!

Thanks,

Tim - RCTID

Try the log files, there is a text file for each maintenance plan written. The file path may vary, mine is at C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Log

Tim

Thanks guys. Unfortunately as is often the case I have to process the data with the format I have, not the format I might want or wish to have at...

Great, thank you again for your help.

Tim

That works perfect! Thank you very much!

Tim

I ran into this same issue earlier this week and found this article very helpful in solving my problem, http://www.proteanit.com/b/2008/02/13/ssis-ftp-task-code-to-set-the-password/

It is using a Script task to set the...

Thanks for the question HESPO, good to see you again.

--TPET

My former co-worker who is a SAP Basis admin and former DBA just uses the title Currency Artist to avoid trying to explain what he really does. He has quite...

This glut of data is a double edged sword. It's fascinating and fun to play with and develop for, but what is the end product of it all? Especially all...

I'm doing it in BIDS.

Tim

That is the best news I've heard all night, as I drink a Sierra Nevada Torpedo.

I recently won an iPad. It has some nice SQL monitoring tools as well as email and Citrix so it works great as a tool. It also has Angry Birds,...

I primarily support internal finance systems. Since these are not order intake or revenue generating databases I'm going to assume that management would prefer less data loss with greater downtime,...