Just an update, I have rewritten the script to find all sql servers on a particular subnet...

I'm using the AdventureWords DB.

I've checked it out thoroughly, but still can't come up with the right query.

lonny.lappin (5/5/2011)

---

The article is great and everything ran the first time without any problems. However, I only received a list of 5 computers back. We have hundreds of...

A security ID...

I found the SQLServerCentral thread from a MSDN forum:

http://social.msdn.microsoft.com/forums/en-US/transactsql/thread/d1dbb675-ce11-4797-91f5-fa4940c3b27e/?prof=required

I'm not finding the your new code, but am very interested in seeing it. Could you please tell me where it can be found.

Thanks

t.holmes (4/20/2011)

---

HI,

Very interesting script, I am testing it in our test environment, however when running the last script within SSMS I get the following error:

Msg 14234, Level 16, State...

garshin_alexander (4/19/2011)

---

powershell script works fine after upgrade to version 2.0

sqlcmd -L list only brodcasting servers ,while this solution simply try to access every station that is up

and...

@Needy Info-318558

Try upgrading to PSv2, see above posts for link.

Try updating to PSv2. You can find the correct version for your OS here: http://support.microsoft.com/kb/968929

That is the minimum for the OS, but my question the PowerShell version. Run Get-Host from the ISE window.

@garshin_alexander

I can't seem to duplicate the error your seeing. What PS version are you using?

Haven't considered VLAN's, thanks.

@Michael.eklof -- This script pulls in all server names across all domains for me, please let me know if this is not the case for you.