Deploying Scripts To Multiple Instances

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Joey Doherty » Deploying Scripts To Multiple Instances

18 posts, Page 2 of 2

««1 2

Deploying Scripts To Multiple Instances

Rate Topic

Display Mode

Topic Options

Author

Message

Rudy Panigas

Posted Thursday, February 07, 2008 9:05 AM

Old Hand

Group: General Forum Members
Last Login: Yesterday @ 1:52 PM
Points: 306, Visits: 1,016

Hello Joe and everyone else,

I would like to thanks you for the article. Read this when it first came out and have since modified it for my need. Here are the modifications I made.

- Create table with contains Servers Name, Type (Prod or Development), Version number (2000 /2005) and Owner of the system (Finance, account, etc). This will all me to specify which systems I want to do remote execution on. So if I only want to run code against the development SQL 2000 servers only I can. Also, as new server come to our network I would just add it's info into this table and it done.

- Enhanced the error handling for server(s) that already have a link connection

- Made my server trusted by all the other servers so that passwords and ids are not needed for connection. My main server is completely locked down on all levels, don't need someone to connect and then have full access to the other servers.

- Made a generic version of the code so that I execute anything I need on the remote server. This works for my SSRS report page. I use this code to produce several reports which include:
1) Job failures report on all servers, production only and / or development onhly
2) SQL Error log analysis report

I can send you my updated code if you like.

Thanks,

Rudy

Post #452801

dustin.jones

Posted Friday, October 10, 2008 2:04 PM

SSC Rookie

Group: General Forum Members
Last Login: Wednesday, January 07, 2009 12:32 PM
Points: 46, Visits: 61

this was a great starting point for me to create my solution. I used the script as a model and added some needed customizations.

Post #584229

jmisc

Posted Monday, December 15, 2008 12:52 PM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, February 17, 2011 2:37 PM
Points: 3, Visits: 37

Joe - Good basic script for dynamic Linked Servers...an auxilary post I have put up is remote RECONFIGURE capability as:

[linked-server].master.dbo.RECONFIGURE does not work.

Any ideas appreciated!

thnx Jay

Post #619908

Joe Yanul

Posted Tuesday, February 24, 2009 7:40 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, March 06, 2009 12:40 PM
Points: 3, Visits: 19

Hi. This is really a great post and is something I would like to implement.
Rudy, is thewre anyway you can send me your updated code that you mentioned..it sounds like enhancements I could use..thanks

Post #663492

Rudy Panigas

Posted Tuesday, February 24, 2009 8:35 AM

Old Hand

Group: General Forum Members
Last Login: Yesterday @ 1:52 PM
Points: 306, Visits: 1,016

Hello Joe,

Have a look at an article I created here called "Managing many SQL Servers?" and see if this works for you. Code is also provided.

Thanks,

Rudy

Post #663573

Joe Yanul

Posted Tuesday, February 24, 2009 8:48 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, March 06, 2009 12:40 PM
Points: 3, Visits: 19

Hi again Rudy..I'am new on using this forum...is there an easy way to get to your article?....I've serached and cannot seem to locate it...thanks for your assistance!

Post #663589

Rudy Panigas

Posted Tuesday, February 24, 2009 8:52 AM

Old Hand

Group: General Forum Members
Last Login: Yesterday @ 1:52 PM
Points: 306, Visits: 1,016

Ok, just copy "Managing many SQL Servers?" (without the quotes) and paste it into the Search window (above and to the right) and clcik Go and then on the results screen click on articles.

Rudy

Post #663595

Joe Yanul

Posted Tuesday, February 24, 2009 9:17 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, March 06, 2009 12:40 PM
Points: 3, Visits: 19

Boy that was a "Dah" on my part....somehow I did that the first time and it came up empty...obviously a "user error'!. I found it fine now..thanks alot for your assistance!

Post #663626

« Prev Topic | Next Topic »

18 posts, Page 2 of 2

««1 2

Permissions