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
What is scheduled job and how to create it?
What is the maximum length of an alert name?
What are the differences between union, intersect, and minus operators?
Which are the third-party tools used in sql server and why would you use them?
How to verify a login name with sqlcmd tool?
How many types of keys are there?
How you would rewrite the sql query to return the customerid sorted numerically?
List the different normalization forms?
Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .
How to rename databases in ms sql server?
What does the automatic recovery do?
Mention the different authentication modes in sql server.
Write an sql query to find first weekday of the month?
What is the recursive stored procedure in sql server?
What do you understand by triggers and mention the different types of it?