ari wrote:
> hey all,
>
> does sql batch files allow you to have transactions? i'm trying to
> update 3 tables in a sql batch file and was wondering if this was a
> good idea or should i just use stored procedure?
>
> thanks,
> ari

"David Gugick" wrote:

> ari wrote:
> > hey all,
> >
> > does sql batch files allow you to have transactions? i'm trying to
> > update 3 tables in a sql batch file and was wondering if this was a
> > good idea or should i just use stored procedure?
> >
> > thanks,
> > ari
>
> Sure you can use transactions. Just add BEGIN TRAN / COMMIT TRAN /
> ROLLBACK to the batch where needed.
>
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com
>