exec xp_msver

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

Question Posted / koti-khammam

Answer Posted / koti-khammam

exec xp_msver

Is This Answer Correct ?

11 Yes

9 No

Please Help Members By Posting Answers For Below Questions

How to add a new column to an existing table with "alter table ... Add" in ms sql server?

1010

How to convert a table data in XML format in sql server?

2540

What do you mean by data manipulation language?

1015

Explain hostprotectionattribute in sql server 2005?

1028

Do you know what is replace and stuff function in sql server?

1010

What is an indexing technique?

936

What is a full text index?

922

Explain what is the use of custom fields in report?

926

What is an indice?

1037

What are joins in sql and what are the different types of joins?

1013

How do you open a cluster administrator?

1051

What is the advantage of sql server?

1034

Explain important index characteristics?

1031

How you can find out if an index is useful to the optimizer?

939

What is the purpose of floor function?

1039