Ha ha! Oops!

I got tripped up by poor reading. I would have sworn there were three columns being inserted into t2 and figured it would throw...

Thanks for the question!

Thanks for the question!

Ignacio A. Salom Rangel (8/23/2011)

---

skrilla99 (8/23/2011)

---

Express12 (8/23/2011)

---

We have over 150 instances of SQL Server installed on servers. I'd like to identify those instances installed on a VM and those...

You could also run systeminfo remotely from your local command line:

c:\>systeminfo /S serverName | find "System Model:"

Which could be readily put together in a batch for all servers.

I don't see...

As another option - this powershell script, found in the comments here:

http://blogs.metcorpconsulting.com/tech/?p=40

seems to work pretty well. It would need to be adapted to pull from your list of...

Bob - It looks like that does work for VMware also - if you are running on SQL...

Express12 (8/23/2011)

---

We have over 150 instances of SQL Server installed on servers. I'd like to identify those instances installed on a VM and those installed on physical machines.. Spiceworks...

Well, I got it wrong. And, I can appreciate some of the complaints.

But the question is a good one if it teaches, and this one reminds us that 'sp_'...

Assuming it is supported, is there any glaring reason not to do it?

Code base for Eval should be the same as full release, right? With just a license restriction?

-Dan

Interesting.

I would have thought there were no direct upgrade path from eval to anything else.

But, it looks like this has been supported since 2005. I suppose a test run...

Thomas Abraham (8/22/2011)

---

Thanks for the question!

I'm curious about the terminology though. The previously used "noise words" did a good job at conveying the meaning of what was being represented. Seems...

Thanks for the question!

-Dan

Added a vote for your's and for Paul's.

Thanks to you both for the amount of time you are putting into this.

-Dan

2005 SP4 x86 - Same issue

http://www.sqlservercentral.com/Forums/FindPost1162490.aspx

-Dan B