<peter.koch.larsen_at_gmail.com> wrote in message
news:1147252750.112378.67450_at_i40g2000cwc.googlegroups.com...
>
> But what if my transaction requires the creation or destruction of ten
> tables? This is what I wrote above, this is what the software does and
> this what caused it to fail: you can't abort it after having created
> the first five tables as those table alerady have been created.
>
Pardon my ignorance, but is it really possible to rollback a
CREATE TABLE in MS SQL Server??? I am not sure
how DDL affects your current transaction in MSSQL,
maybe it runs DDL autonomously, but afaik you can't
rollback DDL in MSSQL, too.
--
Vladimir M. Zakharychev
N-Networks, makers of Dynamic PSP(tm)
http://www.dynamicpsp.com
Received on Wed May 10 2006 - 06:06:15 CDT
