How to find the sql servers on network [modified]
-
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.
modified on Wednesday, December 05, 2007 4:35:28 AM
: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?"
-
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.
modified on Wednesday, December 05, 2007 4:35:28 AM
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
-
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
Open SQL Manager.