Subscribe

RSS Feed (xml)

Powered By

Skin Design:
Free Blogger Skins

Powered by Blogger

Saturday, May 10, 2008

Which command using Query Analyzer will give you the version of SQL server and operating

Which command using Query Analyzer will give you the version of SQL server and operating
system?

Ans:

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY
('edition')

2 comments:

Amelia said...

Awesome blog. I have found so many helping post that shares information about the a number of queries that I am searching. Above query is also a nice one but I have already tried it and is aware of it. Thanks.
sap erp download

Amelia said...

Awesome blog. I have found so many helping post that shares information about the a number of queries that I am searching. Above query is also a nice one but I have already tried it and is aware of it. Thanks.
sap erp download