April 19, 2007 at 1:51 pm
I am currently in development of our "poor man's log shipping" solution and have hit a wall with the xp_cmdshell extended stored procedure. That wall is that the procedure returns only a 0 or a 1 as a return code and that is based upon the actuall success of calling the command statemtent alone and not based upon the return code of the application being called. What I am in search of is either a third party extended stored procedure(dll based) or other alternative which can be used within a stored procedure to call an external application via the command line and actually return the return codes from the application being called to SQL Server for interrogation of error codes. Anyone have suggestions?
April 19, 2007 at 4:53 pm
Scott,
This is not an answer to your question, but there is already a great custom log shipping solution here on SSC that may save you quite a bit of time and effort.
http://www.sqlservercentral.com/columnists/ckempster/customlogshipping.asp
April 19, 2007 at 7:33 pm
Ok, so this is a HUGE help! Wonder why my searches on here didn't bring that up? I will take a look at the solution and see if it takes a bite out of the struggles I am having with my current custom solution.
April 20, 2007 at 10:57 am
For what it's worth, I just implemented this solution around 6 weeks ago for a client. It was easy to taylor to their needs and it has been running great since.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply