Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jbates99
Constraint Violating Yak Guru
396 Posts |
 Posted - 2011-12-02 : 11:23:00
|
| Hello everyone,Do the following commands have to be ran locally? select serverproperty ('productversion')select serverproperty ('edition')select serverproperty ('productlevel')If it's possible to extract this info via linked servers, I have not found a way.Thanks, john |
|
|
chris_cs
Posting Yak Master
223 Posts |
Posted - 2011-12-02 : 11:31:45
|
| If you want to get that information for a lot of servers you should investigate Powershell.----------------------------Junior DBA learning the ropes |
 |
|
|
jbates99
Constraint Violating Yak Guru
396 Posts |
Posted - 2011-12-02 : 12:09:46
|
| Thanks for your reply Chris.Are you referring to using CLR and Powershell? I have some 2005 instances - can Powershell reach out to those?John |
|
|
|
chris_cs
Posting Yak Master
223 Posts |
|
|
|
|
|
Polling Remote Servers