April 1, 2009 at 3:28 am
Hi all,
I am trying to fetch, some SQL SERVER PROPERTIES on remote network machines (I have their names in a table).
I was trying do as below:-
(1)
SELECT 'SQL Server '
+ CAST(SERVERPROPERTY('MachineName') AS VARCHAR) + ' - '
+ CAST(SERVERPROPERTY('productversion') AS VARCHAR) + ' - '
+ CAST(SERVERPROPERTY('productlevel') AS VARCHAR) + ' ('
+ CAST(SERVERPROPERTY('edition') AS VARCHAR) + ')'
And then do a join of the above on the PCs Name (from) my local table.
But, as you can see, I need a “FROM CLAUSE” to complete the join.
Does anyone know from what system table the server properties are coming from?
Else, could you please suggest an alternative for getting remote servers information (having these server names locally)?
Thanks in advance!
(2)
--:::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
JOIN DwnLdbleSoftware_Tab ON MachineName = DwnLdbleSoftware_Tab.[PcName]
--:::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
April 1, 2009 at 8:26 am
These are constants, no from needed.
select serverproperty( 'servername')
, spid
from sysprocesses
The same as
select 1
, spid
from sysprocesses
Please post in the appropriate forum. Moved to 2005 admin
April 1, 2009 at 8:36 am
Thx Steve! I moved.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply