Results 1 to 3 of 3
  1. #1
    Join Date
    May 2006
    Posts
    38

    Question Unanswered: Loop Through SQL Server Instance ?

    Hi,

    Is it possible to loop through dynamically through all sql instances in a particular environment ?

    Thanking you in advance.

    Regards,
    Ranjit

  2. #2
    Join Date
    Dec 2002
    Posts
    1,245
    Quote Originally Posted by RanjitSHans
    Hi,

    Is it possible to loop through dynamically through all sql instances in a particular environment ?
    So you dynamically finding all SQL Servers and the connecting through (insert ADO or DMO here)? Or do you mean looping through a list of servers provided by another source.

    The former can be a bit tricky; lots of ways to "hide" a SQL Instance (google SQL Recon). The latter should be relatively trivial.

    Regards,

    hmscott
    Have you hugged your backup today?

  3. #3
    Join Date
    May 2006
    Posts
    38

    Lightbulb loop through dynamically through all sql instances

    Hi hmscott .. Yup ..I wanted the former ..
    Thanks so much for the sql recon .. It did rack up my grey cells to dig further .. It seems they will be coming out with a command line version in the near future ..

    Just wondering about "lots of ways to "hide" a SQL Instance" .. the one I can think of being a newbie is change the default port of sql server ..any other ? ..

    Thanks,
    Ranjit.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •