How to find the sql servers on network [modified]

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

Rajesh R Subramanian · modified on Wednesday, December 05, 2007 7:36:03 AM

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Ã<-·´¯`·.

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

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

R Giskard Reventlov · modified on Wednesday, December 05, 2007 7:36:03 AM

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

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

Hi, I have a question. Do you program? I really mean that, because I must be forgiven for doubting this ability in you. Why you ask? Simply because: "Posting Guidelines: The Lounge is rated PG. If you're about to post something you wouldn't want your kid sister to read then don't post it. Do not post programming questions (use the programming forums for that) and please don't post ads." Now, that this point is cleared up, would you please post your question in the correct forum where we would be absolutely delighted to help in any way we can

"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?"

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

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

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?"

Mustafa Ismail Mustafa

...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?"

Vasudevan Deepak Kumar · modified on Wednesday, December 05, 2007 7:36:03 AM

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

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

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

Vasudevan Deepak Kumar

/* 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

Mustafa Ismail Mustafa

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?"

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[^]

Vasudevan Deepak Kumar

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

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

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

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

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

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

Rajesh R Subramanian

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Ã<-·´¯`·.