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

How to find tables without indexes?

1081

What is CTE in SQL

937

How to delete existing rows in a table?

1146

What part does database design plays a role in performance of an sql server-based application?

971

What is the chart in report?

158

What is difference between materialized view and view?

905

What information is maintained within the msdb database?

968

What are a scheduled jobs or what is a scheduled tasks?

897

Does order by actually change the order of the data in the tables or does it just change the output?

1130

What is the difference between getdate and sysdatetime?

994

What is the use of =,==,=== operators?

1001

Define indexes?

1035

How to define and use table alias names in ms sql server?

1119

What are the main differences between #temp tables and @table variables and which one is preferred?

1074

What is spid in sql server profiler?

1092