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

Explain what is public role in sql server?

788


What are the different types of collation sensitivity?

752


Explain few examples of RDBMS?

767


What is the importance of three tier architecture?

816


Tell me what is difference between clustered and non clustered index?

713






What is dirty read?

809


Is sql server a database?

696


How do I know if localdb is running?

693


What are the difference between “where” and “having” clause in sql server?

747


What happens when unicode strings concatenate with non-unicode strings?

733


What is nonclustered index with included columns ?

709


How to create view in stored procedure sql server?

688


Write a query to include a constraint, to check whether the employee salary is greater than 5000?

1345


What do you think of this implementation? Can this be implemented better?

703


System requirements for sql server 2005 express edition?

729