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

What is scheduled job and how to create it?

725


What is the maximum length of an alert name?

770


What are the differences between union, intersect, and minus operators?

761


Which are the third-party tools used in sql server and why would you use them?

657


How to verify a login name with sqlcmd tool?

789






How many types of keys are there?

736


How you would rewrite the sql query to return the customerid sorted numerically?

755


List the different normalization forms?

709


Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .

1679


How to rename databases in ms sql server?

814


What does the automatic recovery do?

786


Mention the different authentication modes in sql server.

698


Write an sql query to find first weekday of the month?

664


What is the recursive stored procedure in sql server?

705


What do you understand by triggers and mention the different types of it?

669