Red Gate forums :: View topic - Multiscript and open transactions
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Multi Script 1
SQL Multi Script 1 forum

Multiscript and open transactions

Search in SQL Multi Script 1 forum
Post new topic   Reply to topic
Jump to:  
Author Message
ROOYEVAAR



Joined: 07 Apr 2010
Posts: 5

PostPosted: Wed Apr 07, 2010 9:36 am    Post subject: Multiscript and open transactions Reply with quote

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?
Back to top
View user's profile Send private message
Anu Deshpande



Joined: 20 Apr 2009
Posts: 691
Location: Cambridge

PostPosted: Thu Apr 08, 2010 11:31 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
ROOYEVAAR



Joined: 07 Apr 2010
Posts: 5

PostPosted: Thu Apr 08, 2010 11:34 am    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
Anu Deshpande



Joined: 20 Apr 2009
Posts: 691
Location: Cambridge

PostPosted: Thu Apr 08, 2010 11:35 am    Post subject: Reply with quote

I wanted to know about settings you make in SSMS.
_________________
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
ROOYEVAAR



Joined: 07 Apr 2010
Posts: 5

PostPosted: Thu Apr 08, 2010 12:20 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
Anu Deshpande



Joined: 20 Apr 2009
Posts: 691
Location: Cambridge

PostPosted: Thu Apr 08, 2010 1:00 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
gs_fnz



Joined: 14 Jul 2011
Posts: 1

PostPosted: Thu Jul 14, 2011 12:45 am    Post subject: Reply with quote

Hi, has there been any movement on getting this feature working? Has it been released yet?
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group