Nice article Randy!!

Anthony,

great article! Very cool to see a positive use of the sp_OA stored procedures.

Your article inspires me to do something I've wanted to do for quite a...

Thanks for all of the responces on the article. I'll have to look into the schema.ini option I'll let you know if I find anything out on it.

I wish...

Glad it could help!

-Zach

My specific problem was that the problem began on the same day that I installed a second instance on 3 seperate servers.  The default instance on all 3 boxes stopped...

Thanks for the reply Chris.  If I get it figured out I'll post it.

Thanks again,

Zach

Chris, thanks for the suggestion. I had actually already run the sp_purge_jobhistory before posting and it did not help.  Any other ideas?

I would really hate to recreate all the jobs (thanks...

not sure how to run a DTS package through code, but you could create a job for it and use sp_start_job.  All the proc does though is fires the job,...

In the past I have been at a company that had a NAS device.  The NAS had the ability to snapshot the attach resources.  In doing this it also did...