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

Does partitioning improve performance sql server?

485


What are commonly used odbc functions in php?

536


What is sql service broker?

586


What is the sql server agent?

582


explain extended properties

560






What is multi-statement table-value user-defined function?

534


What are the properties of the transactions?

612


How to optimize stored procedure optimization?

517


What is the primary use of the model database?

619


How to loop through returning rows?

574


How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?

1629


What are the purposes of floor and sign functions?

538


How to create function without parameter in sql server?

558


What is the server name for sql management studio?

473


What is a DBMS, query, SQL?

575