Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 sqlcmd.exe mixed in .net execution

Author  Topic 

staxmanade
Starting Member

1 Post

Posted - 2008-07-11 : 11:46:10
I'm having trouble trying to wrap a call to sqlcmd in a transaction.

I have an application that first makes a .net library call to execute some sql and when that completes I am using .net to start a sqlcmd process and passing in a script file to be executed.

I can get the first step wrapped in transaction, but can't figure out how to include the second step (sqlcmd call) so if the second step fails, I could rollback both the first and second steps.

Any thoughts?
   

- Advertisement -