Web forum is in read-only mode. Login as active registered customer for write access
  Forum Search   New Posts New Posts

Structure transactions

 Post Reply Post Reply
Author
Hugo Logmans View Drop Down
New Member
New Member
Avatar

Joined: 18 Feb 2011
Posts: 3
Post Options Post Options   Quote Hugo Logmans Quote  Post ReplyReply Direct Link To This Post Topic: Structure transactions
    Posted: 18 Feb 2011 at 9:39am
Hi,

do you know you can use transactions on structure updates in SQL Server? This way you can be sure the complete script is executed, or nothing. Saves me time in having partially updated databases when something went wrong. It's only a few lines to be added to the script, but you could do that by default for SQL Server connections because it is supported from version 2000 onward.

Best regards,

Hugo Logmans
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down