Is there a Query Analyzer

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • click37@gmail.com
    #1

    Is there a Query Analyzer

    in the market place that will run a query on multiple DBs across
    multiple servers? Without having to manually connect to each server?
    If so, can anyone provide a link for it.

    Thanks

    Tags: None
    • Josh Assing
      #2
      Re: Is there a Query Analyzer

      "it depends"

      I might be able to write you a custom program for free to do it if you give me
      more details.

      There's ways to send a query to an sql server via script; but it's not pretty.

      Tell us more about what you need to do; or email me off the NG if you want a
      mini app

      -j


      On 20 Feb 2007 14:04:44 -0800, click37@gmail.c om wrote:
      >in the market place that will run a query on multiple DBs across
      >multiple servers? Without having to manually connect to each server?
      >If so, can anyone provide a link for it.
      >
      >Thanks

      --- AntiSpam/harvest ---
      Remove X's to send email to me.

        Comment

        • click37@gmail.com
          #3
          Re: Is there a Query Analyzer

          Say I want to run this script:

          Select * from company

          I need it to run on DB1, DB2, DB3, DB4 and DB5

          DB1 and DB2 are located on Server1
          DB3 is on Server2
          DB4 and DB5 is on Server3

          The long and manual way I would have to do it, is copy the SQL smt.
          Connect to Server1, paste and run it on DB1, then DB2. Connect to
          Server 2, run it on DB3 and so on.

          Is there a way to configure the script that will allow me to run the
          query once, and it'll give me the results from all the DBs I want it
          to hit ?


          Thanks for helping.


          On Feb 20, 8:57 pm, Josh Assing <Xjo...@jAssing .comwrote:
          "it depends"
          >
          I might be able to write you a custom program for free to do it if you give me
          more details.
          >
          There'sways to send aqueryto an sql server via script; but it's not pretty.
          >
          Tell us more about what you need to do; or email me off the NG if you want a
          mini app
          >
          -j
          >
          On 20 Feb 2007 14:04:44 -0800, clic...@gmail.c om wrote:
          >
          in the market place that will run aqueryon multiple DBs across
          multiple servers? Without having to manually connect to each server?
          If so, can anyone provide a link for it.
          >
          Thanks
          >
          --- AntiSpam/harvest ---
          Remove X's to send email to me.

            Comment

            • Robert Klemme
              #4
              Re: Is there a Query Analyzer

              On 22.02.2007 16:04, click37@gmail.c om wrote:
              Say I want to run this script:
              >
              Select * from company
              >
              I need it to run on DB1, DB2, DB3, DB4 and DB5
              >
              DB1 and DB2 are located on Server1
              DB3 is on Server2
              DB4 and DB5 is on Server3
              >
              The long and manual way I would have to do it, is copy the SQL smt.
              Connect to Server1, paste and run it on DB1, then DB2. Connect to
              Server 2, run it on DB3 and so on.
              >
              Is there a way to configure the script that will allow me to run the
              query once, and it'll give me the results from all the DBs I want it
              to hit ?
              Whatever you do, you will have to at least once authenticate to each
              machine. With SQL 2005 Management Studio you can store credentials - or
              you use Windows authentication. Then no additional login is required.

              HTH

              robert

                Comment

                Previous template Next
                Working...