I agree that this is a perfect topic to continue, love to look at the history without having to search related stuff up.

But here is another twist to this for everyone to think about. What about those situations that you cannot use any OLE automation or xp_cmdshell solutions? My company locks everything down due to strict security regulations and audit compliancy, so using something in the SQL Server TSQL scope is not necessarily a solution.

We really need to potentially think outside the box on solutions and look to expand our thoughts on other opportunities within SQL Server, maybe calling CLR, SSIS or something on those lines. I am really attempting to get creative here and not just stick with TSQL so any other thoughts are definitely welcome.

Thanks and love the posts

Ron...