Hello there,
I've a Problem with the MSSQL Execute SQL Action.
I want to execute a sql script (a database restore script), but I can't execute this script, because, there is an unhandled exception.
The path of the sqlcmd.exe is right. I don't know where my failure is.
Can you help me?
You can see my options in the attached screenshots.
Thanks a lot.
Regards,
Patrick
Screenshots.zip (96.704 KB)
angus
(Angus Gratton)
July 17, 2007, 1:54am
2
Hi Patrick, Do you get any output from the action in the log? There may be some output from sqlcmd.exe to explain the exception. Regards, Angus
Hello Angus,
Thank you for your answer.
Unfortunately, there is no log for this action.There is only this unhandled win32 excption.
I don't know, what I shoud do.:( Do you have any tips for me?
Thanks.
Regards,
Patrick
Hi there,
So I've found my problem. My SQLExpress Server was corrupt. I've it reinstalled - so I could use the finalbuilderaction 'MSSQL Execute SQL' without any problems.
Thanks for your help.
Regards, Patrick
angus
(Angus Gratton)
July 19, 2007, 1:42am
5
Hi Patrick, Glad to hear you got it working. Regards, Angus