Red Gate forums: SQL Multi Script 1

RE: Saving all scripts results

vagner.chagas — Thu, 09 May 2013 13:49:56 GMT

please, when this feature will be implemented ?

tnks
Vagner

RE: Method failed with unexpected error code 50

Brian Donahue — Mon, 04 Mar 2013 14:36:30 GMT

This seems to be a known issue. There was something similar a few years ago when adding more than one script on a shared drive - it's logged as bug SE-664.

Method failed with unexpected error code 50

davidsumlin — Sat, 02 Mar 2013 02:37:56 GMT

This is what is causing my problem:

Brand new installation. Licensed.

Add Script, and as soon as I do, the above error shows up in the script window, and the script Name has a red x next to it and I can't do anything, except Remove.

Problem is caused by trying to Add/Open any script...even "SELECT @@VERSION", so I know it's not the actual script itself.

Ahhh..... just figured it out.

My scripts are in a folder in "My Documents", but that's actually mapped to a corporate network folder. If I move the scripts locally, they work.

Is this a known issue?

RE: SQL Prompt in Multi Script - or Multi Script in SSMS!

Sarah — Thu, 28 Feb 2013 16:28:46 GMT

Thanks for your feedback.

This has already been logged as a feature request (SE-657)

I have added your interest in having such a feature.

SQL Prompt in Multi Script - or Multi Script in SSMS!

PCurd — Wed, 27 Feb 2013 13:14:25 GMT

Would be great if you could add the SQL Prompt features to Multi Script for those who have both products.

Or even better, can you add Multi Script into SSMS so I can run it from there with all the features SSMS has?

Thanks

RE: Feature requests

Brian Donahue — Wed, 13 Feb 2013 15:35:15 GMT

Hello Dov,
We have existing feature requests open already for 1 and 3 (SE-673, SE-637). I'm unclear on 2 and 4.

If you could clarify, that would be great.

I suspect (4) may already be available from SQL Server (@@DB_NAME, @@SERVERNAME) but I'm not sure what you want to do with the variable.

Feature requests

Dov Ochert — Tue, 12 Feb 2013 08:52:08 GMT

I am only testing this tool but some features are missing:

1. I run long scripts, I need the execution end time or duration.
2. When executing I want to know what Databases started execution.
3. copy result set with headers
4. It would be great if you can define a parameter (@redgateDB) that at runtime would be replaced with the server.database

RE: Enhancement Requests: 1.1.0.34

RajK — Mon, 11 Feb 2013 07:15:33 GMT

I hope your day is off to a good start? I am sending you an update in regards to this issue. Thank you very much for your feedback in regards to this issue.

I have raised a JIRA issue for the enhancement requestion you have reported and have organised for you to be notified when this is fixed. This issue is now being triaged by development for a future sprint. The JIRA number (SE-681) that will ensure you get an automatic update.

Thanks for your patience and feedback in this investigation, This is really appreciated.

Enhancement Requests: 1.1.0.34

PDinCA — Thu, 07 Feb 2013 20:21:13 GMT

The Distribution List shows the instance and database.

Please add the login, say in parentheses:

Code:

DEV.master (sa)

Please make it easier to CHANGE the Authorization for a database in the List, on the main page, instead of having to remove from the list, change the authentication in the tree-list and re-add the DB(s).

Let us color the script background - white is so harsh!

Integrate SQL Prompt somehow.

Thanks. These will make an indispensable tool even better...

RE: Scheduling Multi Script jobs

CDBA — Tue, 04 Dec 2012 17:34:07 GMT

Really, is it so difficult to add scheduling feature? MultiScript is a fantastic tool but we will have to move away from it since we cannot schedule our scripts and produce saved results on daily basis (outside of business hours). I.e. I have 100+ SQL Servers and I need daily maintenance/backup status report at 6AM, thus by the time when everybody is at the office, DBA has a report which backup failed and what errors we found in error logs. I have no time to view logs manually, neither run the scripts during business hours.

RE: MultiScript for PowerShell

Brian Donahue — Wed, 26 Sep 2012 15:39:20 GMT

We have a long-standing request to be able to automate multiscript ( SE-627 ). It doesn't look likely for implementation anytime soon.

MultiScript for PowerShell

paul.price — Mon, 24 Sep 2012 21:05:31 GMT

Love the tool so far, but I'm trying to move much of tool set over to PowerShell (from SQL) code. Any chance PowerShell could be added to MultiScript, or perhaps a separate tool?

RE: Create script for copying master database structure

stanori — Tue, 11 Sep 2012 19:59:31 GMT

You could try using our SQL Compare tool to generate a deployment script and deploy to each of your remote servers. There is a command line version of SQL Compare that you can use to create a batch job to do this automatically.

RE: Create script for copying master database structure

apisano — Tue, 11 Sep 2012 19:48:50 GMT

Is there a better way of creating the script for propagating from a master db to several other databases when an update is made? If not, it seems to me that creating the script for this would become very time consuming for the database I am maintaining. It contains a combination of over 500 tables and views.

RE: Create script for copying master database structure

stanori — Tue, 11 Sep 2012 19:33:02 GMT

Hi apisano,

Thanks for your post. It sounds like your script that you are specifying in Multiscript is attempting to add a new user object that already exists in the destination SQL Server database. This message is coming from the SQL Server itself as a result of the script.

To get the script working properly, you would need to manually edit the script to remove the entry that is making changes to this particular user object. Also, since this is the master database, this is a system DB, so you will need to be careful about what changes you are rolling into it.

Best Regards,
Steve