select serverproperty('productversion')

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

Question Posted / madhu

Answer Posted / madhu

Is This Answer Correct ?

11 Yes

9 No

Please Help Members By Posting Answers For Below Questions

Explain how does the report manager work in ssrs?

958

What is unique key constraint?

1064

In which files does sql server actually store data?

908

What is the difference between deallocate cursor and close cursor?

1263

Describe triggers features and limitations?

992

Why main is user defined function?

1014

What encryption security is available in sql azure?

101

What extended events?

1007

what is raid and what are different types of raid configurations? : Sql server database administration

1048

How check triggers in sql server?

997

Where are SQL server users names and passwords are stored in sql server?

1273

How to join two tables in a single query in ms sql server?

995

In which tcp/ip port does sql server run? Can it be changed?

992

How sql server executes a statement with nested subqueries?

1032

How do I determine how many instances of sql server are installed on a computer?

1008