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

Answers were Sorted based on User's Feedback



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

Answer / madhu

select @@version

Is This Answer Correct ?    34 Yes 6 No

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

Answer / koti-khammam

exec xp_msver

Is This Answer Correct ?    11 Yes 9 No

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

Answer / madhu

select serverproperty('productversion')

Is This Answer Correct ?    11 Yes 9 No

Post New Answer

More SQL Server Interview Questions

What are audit control procedures?

0 Answers   Ernst Young, Thomson Reuters,


What are the types of database schema? : sql server analysis services, ssas

0 Answers  


How many types of Joins in SQL Server 2005?

9 Answers   CarrizalSoft Technologies, HCL,


What is row_number () and partition by in sql server?

0 Answers  


Questions on identity?

2 Answers   Infosys,






What is the importance of concurrency control?

0 Answers  


What is transaction server implicit?

0 Answers  


What program is used to store the data source file?

0 Answers  


How to insert new line characters into strings?

0 Answers  


two tables are there.1st table EMP has two columns ID and name and contains data 1,A 2,B 3,C 2nd table EmpSal has 2 columns ID and Salary Contains data -1,1000 2,5000 3,3000 Find name of employee having maximum salary ?

5 Answers   CSE,


What is replication and database mirroring?

0 Answers  


You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?

0 Answers  


Categories