Post reply

Want to run stored procedures to build maintenance database

  • May 13, 2015 at 12:45 pm

    #303858

    Hi Experts,

    Can you please suggest an easy and favorable mechanism to create all the maintenance scripts (SProcs) to my maintenance databases in an automated way?

    I have around 12 procedures which I don't want to consolidate in a single Proc and execute.

    Another problem which is coming to my mind is, I can';t use the below method to execute the proc, as I dont have RDP access to the servers.

    sqlcmd -i C:\MyFolder\MyScript.sql -o C:\MyFolder\MyOutput.txt

    I am thinking to ask for a central location where I can create a folder , dumping all my scripts and build the maintenance DB and creating all my procs, table, etc.

    Any thoughts, suggestion on this, would be helpful...

    Thanks.

  • May 13, 2015 at 1:01 pm

    #1797650

    you need to use Registered Servers and Central Management Server to help you administer your SQL servers.

    both of them allow you to run the same script across all the servers in a given group;

    For me, it's the absolute best way to make sure my maintenance scripts are the same across the enterprise.

    Registered server is local only to your isntnace of SSMS, but can be exported, and it saves credentials specific to each server. I believe they are SQL server only.

    Central Management Server allows other DBA's to to connect to the central server and get the same list of servers you set up;

    you can set up groups for SSRS/SAS/SQL/SSIS.,

    I use CMS to document all my instnace types, and to Administer scripts for SQL; i have not had the need to administer SSAS/RS/IS.

    the credentials are only windows pass through for whoever wants to run the queries.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply