How to determine the service pack currently installed on
SQL Server?

Answer Posted / ramesh.l.v

SELECT SERVERPROPERTY('PRODUCTLEVEL')

Is This Answer Correct ?    15 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to handle error or exception in sql?

532


What is an execution plan? When would you use it?

578


How do you maintain database integrity where deletions from one table will automatically cause deletions in another table?

711


How do I determine how many instances of sql server are installed on a computer?

535


What is join and name different type of joins?

584






What is a bit datatype?

562


How to add code to the existing article (using improve article)?

593


How to filter out duplications in the returning rows in ms sql server?

636


Can we call future method from trigger?

514


How to update muliple row in single query?

613


Describe in brief sql server monitoring ways.

589


How do I create a trace in sql server?

518


Why would you use sql agent?

735


How to select some specific columns from a table in a query in ms sql server?

505


What happens if null values are involved in comparison operations?

545