Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. Database & SysAdmin
  3. Database
  4. How to find the sql servers on network [modified]

How to find the sql servers on network [modified]

Scheduled Pinned Locked Moved Database
databasesysadminalgorithmstutorial
23 Posts 11 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • R Rajesh R Subramanian

    We need the big red NO PROGRAMMING QUESTIONS IN THE LOUNGE banner back in place!


    Nobody can give you wiser advice than yourself. - Cicero .·´¯`·->ßRÅhmmÃ<-·´¯`·.

    V Offline
    V Offline
    Vasudevan Deepak Kumar
    wrote on last edited by
    #6

    This is misleading: Got a Programming Question? Click here!

    Vasudevan Deepak Kumar Personal Homepage
    Tech Gossips
    A pessimist sees only the dark side of the clouds, and mopes; a philosopher sees both sides, and shrugs; an optimist doesn't see the clouds at all - he's walking on them. --Leonard Louis Levinson

    M M P 3 Replies Last reply
    0
    • M Malcolm Smart

      aswini wrote:

      I have to find all the sql servers running on network. i am searching in google,

      Your SQL servers are running on the google network? No wonder you can't find them. What we did is keep them all on our own network, label them with a big sticker saying 'SQL SERVER'. Piece of cake to find them then. Also, put them somewhere prominent, like a rack, or a desk. We did have one, a small one hidden away in a cupboard, took somebody over a day to find that one. Also, if they go out at night, put a collar on them with a bell - make them much easier to track down in the morning.

      "More functions should disregard input values and just return 12. It would make life easier." - comment posted on WTF

      V Offline
      V Offline
      Vasudevan Deepak Kumar
      wrote on last edited by
      #7

      Malcolm Smart wrote:

      put a collar on them with a bell

      Bell the cat?

      Vasudevan Deepak Kumar Personal Homepage
      Tech Gossips
      A pessimist sees only the dark side of the clouds, and mopes; a philosopher sees both sides, and shrugs; an optimist doesn't see the clouds at all - he's walking on them. --Leonard Louis Levinson

      M 1 Reply Last reply
      0
      • V Vasudevan Deepak Kumar

        This is misleading: Got a Programming Question? Click here!

        Vasudevan Deepak Kumar Personal Homepage
        Tech Gossips
        A pessimist sees only the dark side of the clouds, and mopes; a philosopher sees both sides, and shrugs; an optimist doesn't see the clouds at all - he's walking on them. --Leonard Louis Levinson

        M Offline
        M Offline
        Mustafa Ismail Mustafa
        wrote on last edited by
        #8

        I agree, but you would expect someone with some web page reading skills would recognize that this is linked.

        "Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning." - Rick Cook "There is no wealth like knowledge, no poverty like ignorance." Ali ibn Abi Talib "Animadvertistine, ubicumque stes, fumum recta in faciem ferri?"

        V 1 Reply Last reply
        0
        • V Vasudevan Deepak Kumar

          Malcolm Smart wrote:

          put a collar on them with a bell

          Bell the cat?

          Vasudevan Deepak Kumar Personal Homepage
          Tech Gossips
          A pessimist sees only the dark side of the clouds, and mopes; a philosopher sees both sides, and shrugs; an optimist doesn't see the clouds at all - he's walking on them. --Leonard Louis Levinson

          M Offline
          M Offline
          Mustafa Ismail Mustafa
          wrote on last edited by
          #9

          ...or the cow. Or indeed the server as the case may be.

          "Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning." - Rick Cook "There is no wealth like knowledge, no poverty like ignorance." Ali ibn Abi Talib "Animadvertistine, ubicumque stes, fumum recta in faciem ferri?"

          1 Reply Last reply
          0
          • A aswini

            Hi.. All... I am working on a database project.. I have to find all the sql servers running on network. i am searching in google, unfortunately i am not getting the logic or code about how to proceed .. Thanks in ADVANCE..

            Aswini

            modified on Wednesday, December 05, 2007 7:36:03 AM

            V Offline
            V Offline
            Vasudevan Deepak Kumar
            wrote on last edited by
            #10

            aswini wrote:

            sql servers running on network.

            Your SQLServers are running. And you are still searching. You have run very fast to catch them.

            Vasudevan Deepak Kumar Personal Homepage
            Tech Gossips
            A pessimist sees only the dark side of the clouds, and mopes; a philosopher sees both sides, and shrugs; an optimist doesn't see the clouds at all - he's walking on them. --Leonard Louis Levinson

            1 Reply Last reply
            0
            • V Vasudevan Deepak Kumar

              This is misleading: Got a Programming Question? Click here!

              Vasudevan Deepak Kumar Personal Homepage
              Tech Gossips
              A pessimist sees only the dark side of the clouds, and mopes; a philosopher sees both sides, and shrugs; an optimist doesn't see the clouds at all - he's walking on them. --Leonard Louis Levinson

              M Offline
              M Offline
              Malcolm Smart
              wrote on last edited by
              #11

              Didn't it say 'Post Here' before - which was misleading. Click here is now obvious I'd have thought.

              "More functions should disregard input values and just return 12. It would make life easier." - comment posted on WTF

              V 1 Reply Last reply
              0
              • M Mustafa Ismail Mustafa

                I agree, but you would expect someone with some web page reading skills would recognize that this is linked.

                "Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning." - Rick Cook "There is no wealth like knowledge, no poverty like ignorance." Ali ibn Abi Talib "Animadvertistine, ubicumque stes, fumum recta in faciem ferri?"

                V Offline
                V Offline
                Vasudevan Deepak Kumar
                wrote on last edited by
                #12

                Mustafa Ismail Mustafa wrote:

                but you would expect someone with some web page reading skills would recognize that this is linked.

                Even with big colored banners, we encounter real dumb persons dumping sh*t all around. How do you expect a little text without any adoration to help out a color-blind myopic persons? This is where 'Web Page Accessibility Guidelines' comes into play. Isn't it? :-D

                Vasudevan Deepak Kumar Personal Homepage
                Tech Gossips
                A pessimist sees only the dark side of the clouds, and mopes; a philosopher sees both sides, and shrugs; an optimist doesn't see the clouds at all - he's walking on them. --Leonard Louis Levinson

                M 1 Reply Last reply
                0
                • M Malcolm Smart

                  Didn't it say 'Post Here' before - which was misleading. Click here is now obvious I'd have thought.

                  "More functions should disregard input values and just return 12. It would make life easier." - comment posted on WTF

                  V Offline
                  V Offline
                  Vasudevan Deepak Kumar
                  wrote on last edited by
                  #13

                  /* Just posted this part of another thread on this topic */ Even with big colored banners, we encounter real dumb persons dumping sh*t all around. How do you expect a little text without any adoration to help out a color-blind myopic persons?

                  Vasudevan Deepak Kumar Personal Homepage
                  Tech Gossips
                  A pessimist sees only the dark side of the clouds, and mopes; a philosopher sees both sides, and shrugs; an optimist doesn't see the clouds at all - he's walking on them. --Leonard Louis Levinson

                  1 Reply Last reply
                  0
                  • V Vasudevan Deepak Kumar

                    Mustafa Ismail Mustafa wrote:

                    but you would expect someone with some web page reading skills would recognize that this is linked.

                    Even with big colored banners, we encounter real dumb persons dumping sh*t all around. How do you expect a little text without any adoration to help out a color-blind myopic persons? This is where 'Web Page Accessibility Guidelines' comes into play. Isn't it? :-D

                    Vasudevan Deepak Kumar Personal Homepage
                    Tech Gossips
                    A pessimist sees only the dark side of the clouds, and mopes; a philosopher sees both sides, and shrugs; an optimist doesn't see the clouds at all - he's walking on them. --Leonard Louis Levinson

                    M Offline
                    M Offline
                    Mustafa Ismail Mustafa
                    wrote on last edited by
                    #14

                    Vasudevan Deepak K wrote:

                    Even with big colored banners, we encounter real dumb persons dumping sh*t all around.

                    That sounds like the banners that they set up here at the voting centers.

                    Vasudevan Deepak K wrote:

                    How do you expect a little text without any adoration to help out a color-blind myopic persons?

                    Uh.. Super-webpage man comes to the rescue?

                    Vasudevan Deepak K wrote:

                    This is where 'Web Page Accessibility Guidelines' comes into play. Isn't it?

                    That and a dash, just a sprinkling mind you, of common sense. Alas, there's a worldwide shortage!!

                    "Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning." - Rick Cook "There is no wealth like knowledge, no poverty like ignorance." Ali ibn Abi Talib "Animadvertistine, ubicumque stes, fumum recta in faciem ferri?"

                    1 Reply Last reply
                    0
                    • V Vasudevan Deepak Kumar

                      This is misleading: Got a Programming Question? Click here!

                      Vasudevan Deepak Kumar Personal Homepage
                      Tech Gossips
                      A pessimist sees only the dark side of the clouds, and mopes; a philosopher sees both sides, and shrugs; an optimist doesn't see the clouds at all - he's walking on them. --Leonard Louis Levinson

                      P Offline
                      P Offline
                      Pawel Krakowiak
                      wrote on last edited by
                      #15

                      This is not a programming question' (unchecked by default). Then after you check it and click Post Message a JavaScript dialog pops up and asks 'Are you sure this is not a programming question? [Yes/No]'. This would be annoying for everyone, but it still might work. ;P Although knowing trolls it probably wouldn't.

                      Kind regards, Pawel Krakowiak Miraculum Software[^]

                      V 1 Reply Last reply
                      0
                      • P Pawel Krakowiak

                        This is not a programming question' (unchecked by default). Then after you check it and click Post Message a JavaScript dialog pops up and asks 'Are you sure this is not a programming question? [Yes/No]'. This would be annoying for everyone, but it still might work. ;P Although knowing trolls it probably wouldn't.

                        Kind regards, Pawel Krakowiak Miraculum Software[^]

                        V Offline
                        V Offline
                        Vasudevan Deepak Kumar
                        wrote on last edited by
                        #16

                        Pawel Krakowiak wrote:

                        JavaScript dialog pops up

                        and preferably a show 'Web Page Modal Dialog', which normally takes age to load? ;)

                        Vasudevan Deepak Kumar Personal Homepage
                        Tech Gossips
                        A pessimist sees only the dark side of the clouds, and mopes; a philosopher sees both sides, and shrugs; an optimist doesn't see the clouds at all - he's walking on them. --Leonard Louis Levinson

                        1 Reply Last reply
                        0
                        • A aswini

                          Hi.. All... I am working on a database project.. I have to find all the sql servers running on network. i am searching in google, unfortunately i am not getting the logic or code about how to proceed .. Thanks in ADVANCE..

                          Aswini

                          modified on Wednesday, December 05, 2007 7:36:03 AM

                          N Offline
                          N Offline
                          NormDroid
                          wrote on last edited by
                          #17

                          Using a sql ping method, if you want to offshore this project to my company, we will provide you with an class and documentation to do this. For this module we'll charging £250, (include source and documentation). Drop me an email if you're intested. :)

                          WPF - Imagineers Wanted Follow your nose using DoubleAnimationUsingPath

                          1 Reply Last reply
                          0
                          • R R Giskard Reventlov

                            If you are too stupid to understand where programming questions go then, plainly, you're too stupid to program. Uninstall everything from your pc and try to get your money back... you're going to need it.

                            home articles for dummies

                            N Offline
                            N Offline
                            NormDroid
                            wrote on last edited by
                            #18

                            :laugh: :laugh: :laugh: And what he is trying to do is so simple: Please subscribe to to reveal code... public static void SQLPing(string ip) { xsdkjwej lwkejwkl klwjeqlkwejlq ql;kwejqwkl jqeejkqwejqlkejqw;lkj lkjk qw;ek;k; lqwke ;lqkw;lkeql;w kql;wke qwl;ekqw;lekq;lwekq;keq ql;ekq;l ke lr'w;e ww'er;lwe'; lw';erlw' kdfl;sd sd;flk sdl;fkslk9eiwqe0 ;sdlklkas as kasd;lkas;l .,m.,cmzx,.czm owqkpemkqw;le oqwei 0-eiqw; kq ql;wka;sldk a;sldkal;dkal;dk l';asld' ;ald'adla'dla';dlas'dla'ld a'dl as }

                            WPF - Imagineers Wanted Follow your nose using DoubleAnimationUsingPath

                            R 1 Reply Last reply
                            0
                            • A aswini

                              Hi.. All... I am working on a database project.. I have to find all the sql servers running on network. i am searching in google, unfortunately i am not getting the logic or code about how to proceed .. Thanks in ADVANCE..

                              Aswini

                              modified on Wednesday, December 05, 2007 7:36:03 AM

                              P Offline
                              P Offline
                              Pete OHanlon
                              wrote on last edited by
                              #19

                              Find your central servers and then grab the network cables and follow them round the building. If you have to punch your way through walls, then so be it, but be really determined and follow them all the way round. You might have to crawl through some really tight spaces to follow this, but it's worth it. Ultimately you will come to some PCs. What you have to do is take the top off each one and look really hard at the hard drive (it's called the hard drive because you have to look hard and not because it hangs around on street corners looking to pick fights). Take a look and see if you can see the 1s and 0s that correspond to the SQL Server installation. Real programmers can tell what software you have installed just by looking at the 1s and 0s, no matter how fragmented a drive is. If you see the pattern, SQL Server is installed. Sometimes you might have to tunnel outside the building, but if you have to then go ahead. Another method is to stand and shout very loudly, "Here Sql Server. Come on boy.". Remember to pat your knees very loudly to get its attention. All the Sql Server puppies will come bounding towards you. Alternatively, you could always read the bit that says you shouldn't post programming questions in the lounge.

                              Deja View - the feeling that you've seen this post before.

                              My blog | My articles

                              modified on Wednesday, December 05, 2007 4:35:28 AM

                              M Z 2 Replies Last reply
                              0
                              • N NormDroid

                                :laugh: :laugh: :laugh: And what he is trying to do is so simple: Please subscribe to to reveal code... public static void SQLPing(string ip) { xsdkjwej lwkejwkl klwjeqlkwejlq ql;kwejqwkl jqeejkqwejqlkejqw;lkj lkjk qw;ek;k; lqwke ;lqkw;lkeql;w kql;wke qwl;ekqw;lekq;lwekq;keq ql;ekq;l ke lr'w;e ww'er;lwe'; lw';erlw' kdfl;sd sd;flk sdl;fkslk9eiwqe0 ;sdlklkas as kasd;lkas;l .,m.,cmzx,.czm owqkpemkqw;le oqwei 0-eiqw; kq ql;wka;sldk a;sldkal;dkal;dk l';asld' ;ald'adla'dla';dlas'dla'ld a'dl as }

                                WPF - Imagineers Wanted Follow your nose using DoubleAnimationUsingPath

                                R Offline
                                R Offline
                                Rajesh R Subramanian
                                wrote on last edited by
                                #20

                                That would require the .NET framework 4.2 Gamma and Windows OMG version[^] installed. You may use the following call instead: GetALLSQLserversMama(LOLZ H@x0R){ return RandomInt(); }


                                Nobody can give you wiser advice than yourself. - Cicero .·´¯`·->ßRÅhmmÃ<-·´¯`·.

                                1 Reply Last reply
                                0
                                • P Pete OHanlon

                                  Find your central servers and then grab the network cables and follow them round the building. If you have to punch your way through walls, then so be it, but be really determined and follow them all the way round. You might have to crawl through some really tight spaces to follow this, but it's worth it. Ultimately you will come to some PCs. What you have to do is take the top off each one and look really hard at the hard drive (it's called the hard drive because you have to look hard and not because it hangs around on street corners looking to pick fights). Take a look and see if you can see the 1s and 0s that correspond to the SQL Server installation. Real programmers can tell what software you have installed just by looking at the 1s and 0s, no matter how fragmented a drive is. If you see the pattern, SQL Server is installed. Sometimes you might have to tunnel outside the building, but if you have to then go ahead. Another method is to stand and shout very loudly, "Here Sql Server. Come on boy.". Remember to pat your knees very loudly to get its attention. All the Sql Server puppies will come bounding towards you. Alternatively, you could always read the bit that says you shouldn't post programming questions in the lounge.

                                  Deja View - the feeling that you've seen this post before.

                                  My blog | My articles

                                  modified on Wednesday, December 05, 2007 4:35:28 AM

                                  M Offline
                                  M Offline
                                  Mustafa Ismail Mustafa
                                  wrote on last edited by
                                  #21

                                  :laugh: I had to get up and talk a walk outside the office because I laughed so hard :laugh: I remain your padawan!

                                  "Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning." - Rick Cook "There is no wealth like knowledge, no poverty like ignorance." Ali ibn Abi Talib "Animadvertistine, ubicumque stes, fumum recta in faciem ferri?"

                                  1 Reply Last reply
                                  0
                                  • P Pete OHanlon

                                    Find your central servers and then grab the network cables and follow them round the building. If you have to punch your way through walls, then so be it, but be really determined and follow them all the way round. You might have to crawl through some really tight spaces to follow this, but it's worth it. Ultimately you will come to some PCs. What you have to do is take the top off each one and look really hard at the hard drive (it's called the hard drive because you have to look hard and not because it hangs around on street corners looking to pick fights). Take a look and see if you can see the 1s and 0s that correspond to the SQL Server installation. Real programmers can tell what software you have installed just by looking at the 1s and 0s, no matter how fragmented a drive is. If you see the pattern, SQL Server is installed. Sometimes you might have to tunnel outside the building, but if you have to then go ahead. Another method is to stand and shout very loudly, "Here Sql Server. Come on boy.". Remember to pat your knees very loudly to get its attention. All the Sql Server puppies will come bounding towards you. Alternatively, you could always read the bit that says you shouldn't post programming questions in the lounge.

                                    Deja View - the feeling that you've seen this post before.

                                    My blog | My articles

                                    modified on Wednesday, December 05, 2007 4:35:28 AM

                                    Z Offline
                                    Z Offline
                                    Zoltan Balazs
                                    wrote on last edited by
                                    #22

                                    I really hope they don't have wireless lan, because then he must fly around. ;P

                                    Network integrated solutions | Flickr A practical use of the MVC pattern

                                    1 Reply Last reply
                                    0
                                    • A aswini

                                      Hi.. All... I am working on a database project.. I have to find all the sql servers running on network. i am searching in google, unfortunately i am not getting the logic or code about how to proceed .. Thanks in ADVANCE..

                                      Aswini

                                      modified on Wednesday, December 05, 2007 7:36:03 AM

                                      J Offline
                                      J Offline
                                      Jeffrey Walton
                                      wrote on last edited by
                                      #23

                                      Open SQL Manager.

                                      1 Reply Last reply
                                      0
                                      Reply
                                      • Reply as topic
                                      Log in to reply
                                      • Oldest to Newest
                                      • Newest to Oldest
                                      • Most Votes


                                      • Login

                                      • Don't have an account? Register

                                      • Login or register to search.
                                      • First post
                                        Last post
                                      0
                                      • Categories
                                      • Recent
                                      • Tags
                                      • Popular
                                      • World
                                      • Users
                                      • Groups