| Author |
Message |
ROOYEVAAR
Joined: 07 Apr 2010
Posts: 5
|
 Posted: Wed Apr 07, 2010 9:36 am Post subject: Multiscript and open transactions |
 |
|
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 |
|
 |
Anu Deshpande
Joined: 20 Apr 2009
Posts: 591
Location: Cambridge
|
| Posted: Thu Apr 08, 2010 11:31 am Post subject: |
|
|
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 |
|
|
ROOYEVAAR
Joined: 07 Apr 2010
Posts: 5
|
| Posted: Thu Apr 08, 2010 11:34 am Post subject: |
|
|
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 |
|
|
Anu Deshpande
Joined: 20 Apr 2009
Posts: 591
Location: Cambridge
|
| Posted: Thu Apr 08, 2010 11:35 am Post subject: |
|
|
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 |
|
|
ROOYEVAAR
Joined: 07 Apr 2010
Posts: 5
|
| Posted: Thu Apr 08, 2010 12:20 pm Post subject: |
|
|
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 |
|
|
Anu Deshpande
Joined: 20 Apr 2009
Posts: 591
Location: Cambridge
|
| Posted: Thu Apr 08, 2010 1:00 pm Post subject: |
|
|
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 |
|
|
gs_fnz
Joined: 14 Jul 2011
Posts: 1
|
| Posted: Thu Jul 14, 2011 12:45 am Post subject: |
|
|
| Hi, has there been any movement on getting this feature working? Has it been released yet? |
|
| Back to top |
|
|
|
