Multiscript and open transactions

Single-click script execution on multiple SQL Servers.

Moderators: JonathanWatts, Anu Deshpande, dlkj, Colin Millerchip, Michelle Taylor

Multiscript and open transactions

Postby ROOYEVAAR » Wed Apr 07, 2010 9:36 am

Hello,

I use multiscript to run several stored procedure change scripts on databases.
I now run into the problem that a mistake has been made in the script, the closing COMMIT statement is missing. Multiscript just finished the script without any message, but obviously nothing happend, because the transaction is rolled back.

It would be nice if Multiscript would check if there are any open transactions after processing the script, like the SQL mgt studio does.

Any chance this could be implemented in a future update?
ROOYEVAAR
 
Posts: 5
Joined: Wed Apr 07, 2010 9:31 am

Postby Anu Deshpande » Thu Apr 08, 2010 11:31 am

Many thanks for your post.

Can you kindly let me know the setting that you configure that would check if there are any open transactions after processing the script?

And also can you let me know the SQL Server Management Studio version?

After knowing above details I can than raise the feature request accordingly.
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
Anu Deshpande
 
Posts: 692
Joined: Mon Apr 20, 2009 3:53 pm
Location: Cambridge

Postby ROOYEVAAR » Thu Apr 08, 2010 11:34 am

As far as I know, there is no setting to check for open transactions in the MultiScript application, that's the point.
I'm using MSSQL 2005 and 2008, and if you run a script there with an unfinished transaction, you get a warning when you try to close the query screen.
ROOYEVAAR
 
Posts: 5
Joined: Wed Apr 07, 2010 9:31 am

Postby Anu Deshpande » Thu Apr 08, 2010 11:35 am

I wanted to know about settings you make in SSMS.
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
Anu Deshpande
 
Posts: 692
Joined: Mon Apr 20, 2009 3:53 pm
Location: Cambridge

Postby ROOYEVAAR » Thu Apr 08, 2010 12:20 pm

None really, this is default I guess.
If you do a BEGIN TRANSACTION
UPDATE sometable SET someColumn=1

and you leave out the commit, you should get a warning when you close the screen.
ROOYEVAAR
 
Posts: 5
Joined: Wed Apr 07, 2010 9:31 am

Postby Anu Deshpande » Thu Apr 08, 2010 1:00 pm

Oh I see what you are saying!

I have logged this feature in our internal tracking system whose tracking id is SE-653.

I will update you as soon as it is incorporated in a release.

Kindly let us know if you have any issues or questions regarding the product,I'll like to help.
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
Anu Deshpande
 
Posts: 692
Joined: Mon Apr 20, 2009 3:53 pm
Location: Cambridge

Postby gs_fnz » Thu Jul 14, 2011 12:45 am

Hi, has there been any movement on getting this feature working? Has it been released yet?
gs_fnz
 
Posts: 1
Joined: Thu Jul 14, 2011 12:42 am


Return to SQL Multi Script 1

Who is online

Users browsing this forum: No registered users and 0 guests