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

Answer Posted / madhu

select serverproperty('productversion')

Is This Answer Correct ?    11 Yes 9 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is 1nf 2nf and 3nf?

495


Does a server store data?

504


How to change the ownership of a schema in ms sql server?

563


What number aggregate functions are accessible there in sql?

595


What is the maximum row of a size?

580






Explain what is dbcc?

597


What is a non equi join?

544


Does any body please help me what question's have asked for SSRS in the interview?

1675


What is unpivot?

576


Write a sql query to display the current date?

639


What is self contained scalar sub query?

542


How do I make a resultset scrollable?

519


What are the advantages of passing name-value pairs as parameters?

665


What are the features of Embedded SQL

681


How do you know if sql server is running on your local system?

548