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

What is the recovery model?

928

How to create a large table with random data for index testing in ms sql server?

977

What is the use of floor function in sql server?

1022

What is the difference between Clustered and Non-Clustered Index?

1008

Can a table be moved to different filegroup?

917

What is the difference between sql server 2000 object owner and sql server 2005 schema? : sql server database administration

939

What are the source of constraints?

855

How do I connect to sql server database?

946

Do you know what are acid properties of transaction?

907

how do you test proper tcp/ip configuration windows machine? : Sql server database administration

995

How to write a query with a full outer join in ms sql server?

998

What the different components in replication and what is their use?

912

How to delete an existing row with delete statements in ms sql server?

1017

What are system databases into sql server (2005/2008)?

952

What are scheduled tasks in sql server?

1008