March 15, 2009 at 11:42 pm
Hi All,
Have a small question, i want to get the version number of a db server. I can have several link servers. is there any systables where i can query the version no.
I am not talking about @@version here.
Thanx,
A.
March 16, 2009 at 5:27 am
Hello Amit
You can use OPENQUERY to get server properties from a linked server:
SELECT * FROM OPENQUERY(LinkedServerName, 'SELECT @@VERSION')
Greets
Flo
March 16, 2009 at 7:34 am
SQL Server has a function ServerProperty() that you can use to get this information. I know it is available from at least 2000 forward.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
March 17, 2009 at 11:58 am
PRINT @@VERSION
[font="Comic Sans MS"]+++BLADE+++[/font]:cool:
March 17, 2009 at 1:08 pm
SELECT @@servername 'Server Name',
substring(@@version,1,charindex('-',@@version)-1)
+convert(varchar(100),SERVERPROPERTY('edition'))+ ' '+
+convert(varchar(100),SERVERPROPERTY('productlevel'))'Server Version',
substring(@@version,charindex('-',@@version)+1,(charindex(')',@@version)+1)-charindex('-',@@version)) 'Version Number'
This will provide you with the version name and number of the database server.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply