Database Discussion Boards

Re: How to find the sql servers on network

Mustafa Ismail Mustafa4-Dec-07 21:27

Mustafa Ismail Mustafa

4-Dec-07 21:27

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

Re: How to find the sql servers on network

Vasudevan Deepak Kumar4-Dec-07 21:33

Vasudevan Deepak Kumar

4-Dec-07 21:33

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? Big Grin | :-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

Re: How to find the sql servers on network

Mustafa Ismail Mustafa4-Dec-07 21:39

Mustafa Ismail Mustafa

4-Dec-07 21:39

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!!

Re: How to find the sql servers on network

Malcolm Smart4-Dec-07 21:33

Malcolm Smart

4-Dec-07 21:33

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

Re: How to find the sql servers on network

Vasudevan Deepak Kumar4-Dec-07 21:35

Vasudevan Deepak Kumar

4-Dec-07 21:35

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

Re: How to find the sql servers on network

Pawel Krakowiak4-Dec-07 21:41

Pawel Krakowiak

4-Dec-07 21:41

How about a checkbox under the Text field which says '[x] 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. Poke tongue | ;-P

Although knowing trolls it probably wouldn't.

Kind regards,
Pawel Krakowiak

Miraculum Software[^]

Re: How to find the sql servers on network

Vasudevan Deepak Kumar4-Dec-07 21:46

Vasudevan Deepak Kumar

4-Dec-07 21:46

Pawel Krakowiak wrote:
JavaScript dialog pops up

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

Re: How to find the sql servers on network

Malcolm Smart4-Dec-07 20:57

Malcolm Smart

4-Dec-07 20:57

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

Re: How to find the sql servers on network

Vasudevan Deepak Kumar4-Dec-07 21:26

Vasudevan Deepak Kumar

4-Dec-07 21:26

Malcolm Smart wrote:
put a collar on them with a bell

Bell the cat?

Re: How to find the sql servers on network

Mustafa Ismail Mustafa4-Dec-07 21:28

Mustafa Ismail Mustafa

4-Dec-07 21:28

...or the cow.

Or indeed the server as the case may be.

Repetition

R. Giskard Reventlov4-Dec-07 21:07

R. Giskard Reventlov

4-Dec-07 21:07

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

Re: Repetition

NormDroid4-Dec-07 21:52

NormDroid

4-Dec-07 21:52

And what he is trying to do is so simple:

Please subscribe to to reveal code...

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

WPF - Imagineers Wanted
Follow your nose using DoubleAnimationUsingPath

Re: Repetition

Rajesh R Subramanian4-Dec-07 22:13

Rajesh R Subramanian

4-Dec-07 22:13

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){<br />
return RandomInt();<br />
}

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

Re: How to find the sql servers on network

Mustafa Ismail Mustafa4-Dec-07 21:10

Mustafa Ismail Mustafa

4-Dec-07 21:10

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

Re: How to find the sql servers on network

Vasudevan Deepak Kumar4-Dec-07 21:28

Vasudevan Deepak Kumar

4-Dec-07 21:28

aswini wrote:
sql servers running on network.

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

Re: How to find the sql servers on network

NormDroid4-Dec-07 21:48

NormDroid

4-Dec-07 21:48

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.
Smile | :)

WPF - Imagineers Wanted
Follow your nose using DoubleAnimationUsingPath

Re: How to find the sql servers on network [modified]

Pete O'Hanlon4-Dec-07 22:03

Pete O'Hanlon

4-Dec-07 22:03

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

Re: How to find the sql servers on network

Mustafa Ismail Mustafa4-Dec-07 22:38

Mustafa Ismail Mustafa

4-Dec-07 22:38

I had to get up and talk a walk outside the office because I laughed so hard Laugh | :laugh:

I remain your padawan!

Re: How to find the sql servers on network

Zoltan Balazs4-Dec-07 22:59

Zoltan Balazs

4-Dec-07 22:59

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

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

Re: How to find the sql servers on network

Jeffrey Walton4-Dec-07 23:51

Jeffrey Walton

4-Dec-07 23:51

Open SQL Manager.

Please help me put this in a pivot selection??? Using SQL 2005

Support1234-Dec-07 19:25

Support123

4-Dec-07 19:25

Hi all, i have the following...

SELECT Distinct DocGroup.Owner , DocGroup1.Document_Group as Grp1, DocGroup2.Document_Group as Grp2,<br />
	DocGroup3.Document_Group as Grp3, DocGroup4.Document_Group as Grp4,<br />
	DocGroup5.Document_Group as Grp5, DocGroup6.Document_Group as Grp6,<br />
	DocGroup7.Document_Group as Grp7, DocGroup8.Document_Group as Grp8,<br />
	DocGroup9.Document_Group as Grp9, DocGroup10.Document_Group as Grp10,<br />
	DocGroup11.Document_Group as Grp11, DocGroup12.Document_Group as Grp12,<br />
	DocGroup13.Document_Group as Grp13, DocGroup14.Document_Group as Grp14,<br />
	DocGroup15.Document_Group as Grp15, DocGroup16.Document_Group as Grp16<br />
	FROM Document DocGroup LEFT JOIN Document DocGroup1<br />
	ON DocGroup.Owner = DocGroup1.Owner AND DocGroup1.Document_Group = '1' LEFT JOIN Document DocGroup2<br />
	ON DocGroup.Owner = DocGroup2.Owner AND DocGroup2.Document_Group = '2' LEFT JOIN Document DocGroup3<br />
	ON DocGroup.Owner = DocGroup3.Owner AND DocGroup3.Document_Group = '3' LEFT JOIN Document DocGroup4<br />
	ON DocGroup.Owner = DocGroup4.Owner AND DocGroup4.Document_Group = '4' LEFT JOIN Document DocGroup5<br />
	ON DocGroup.Owner = DocGroup5.Owner AND DocGroup5.Document_Group = '5' LEFT JOIN Document DocGroup6<br />
	ON DocGroup.Owner = DocGroup6.Owner AND DocGroup6.Document_Group = '6' LEFT JOIN Document DocGroup7<br />
	ON DocGroup.Owner = DocGroup7.Owner AND DocGroup7.Document_Group = '7' LEFT JOIN Document DocGroup8<br />
	ON DocGroup.Owner = DocGroup8.Owner AND DocGroup8.Document_Group = '8' LEFT JOIN Document DocGroup9<br />
	ON DocGroup.Owner = DocGroup9.Owner AND DocGroup9.Document_Group = '9' LEFT JOIN Document DocGroup10<br />
	ON DocGroup.Owner = DocGroup10.Owner AND DocGroup10.Document_Group = '10' LEFT JOIN Document DocGroup11<br />
	ON DocGroup.Owner = DocGroup11.Owner AND DocGroup11.Document_Group = '11' LEFT JOIN Document DocGroup12<br />
	ON DocGroup.Owner = DocGroup12.Owner AND DocGroup12.Document_Group = '12' LEFT JOIN Document DocGroup13<br />
	ON DocGroup.Owner = DocGroup13.Owner AND DocGroup13.Document_Group = '13' LEFT JOIN Document DocGroup14<br />
	ON DocGroup.Owner = DocGroup14.Owner AND DocGroup14.Document_Group = '14' LEFT JOIN Document DocGroup15<br />
	ON DocGroup.Owner = DocGroup15.Owner AND DocGroup15.Document_Group = '15' LEFT JOIN Document DocGroup16<br />
	ON DocGroup.Owner = DocGroup16.Owner AND DocGroup16.Document_Group = '16'

This is taking 4ever to load... would it help to put this in a pivot table?? i have been trying but i cant seem to do it (i only have an example of where count is used in a pivot table??)

Thank you in advance.

"Many of life's failures are people who did not realize how close they were to success when they gave up." Thomas A. Edison

modified on Wednesday, December 05, 2007 7:35:23 AM

SQL Express Connection String Frustration

Raziaar4-Dec-07 19:04

Raziaar

4-Dec-07 19:04

The following connection string works for me:

"Data Source=.\\SQLEXPRESS;database=master;Integrated Security=True;Connect Timeout=5;User Instance=True"

However, when I try to navigate to any other database on the SQLEXPRESS server, for instance MyCompany, it doesn't work. The database is located in a directory that is one back from where the master directory is located, and I don't know how to direct it there.

master is located in SQLEXPRESS\Databases\System Databases\

But the database I want is located in SQLEXPRESS\Databases\

How would I accomplish that? Nothing I do seems to work. I've tried the |DataDirectory| thing I've found on many websites, but that doesn't work... because I'm not trying to point to a database on the computer I'm using, I'm trying to point to one on the SQL Server.

modified on Wednesday, December 05, 2007 1:30:30 AM

Re: SQL Express Connection String Frustration

pmarfleet4-Dec-07 19:35

pmarfleet

4-Dec-07 19:35

Attach the database in your instance of SQL Express, then change the database name in your connection string from 'master' to the name of your database.

Paul Marfleet

"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush

Re: SQL Express Connection String Frustration

Raziaar4-Dec-07 19:48

Raziaar

4-Dec-07 19:48

Thanks for the reply Paul. I have the file attached to my instance of SQL express, but it doesn't seem to work.

C# keeps giving me an error exception that I catch and read the contents of when I do that.

Cannot open database "mycompany" requested by the login. The login failed.
Login failed for user 'BlahBlah\BlahBlah'.

I think it's because when I attach to the instance of SQL express, it isn't attaching the database in the same location as the master and other system databases are in... as noted in my initial post.

Re: SQL Express Connection String Frustration

Mike Dimmick4-Dec-07 21:13

Mike Dimmick

4-Dec-07 21:13

You're confused by how Management Studio is presenting the information. The master database and the other system databases are placed under System Databases in the tree to keep them out of the way of your user databases, to both reduce noise and to slightly reduce the risk of accidental damage. As far as the server itself is concerned there is no separation, there is only a single namespace for all databases.

If you cannot log on to a database that is loaded into SQL Server but can log on to other databases, it typically means that you don't have permissions in that database. I haven't got space or time for a full treatment here, but basically your Windows user account or SQL Server logon has to have a logon to the server (under SQLEXPRESS\Security\Logons) and then a user account has to be mapped (under SQLEXPRESS\Databases\yourdb\Security\Users). The exact permissions for what you can do depends on the server roles that the logon is a member of, and the database roles that the user is a member of.

I also note you're using User Instances. This effectively creates a private instance of SQL Server just for this user. My understanding is that you cannot then see databases loaded by the parent instance, only ones loaded into the private instance using AttachDBFilename. I suspect that you want to remove the User Instance parameter from the connection string.

DoEvents: Generating unexpected recursion since 1991

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.