SELECT SERVERPROPERTY('PRODUCTLEVEL')

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

Question Posted / ramesh.l.v

Answer Posted / ramesh.l.v

Is This Answer Correct ?

15 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is set nocount on and what is set nocount off?

885

How can you find out which stored procedures are recompiling?

879

How does stuff differ from the replace function?

957

Describe and explain about SQL native client?

1039

How do I start sql server agent automatically?

915

What is a file group?

1018

can you implement data mining in SSRS?

140

How do I know if localdb is running?

891

What are the differences between stored procedure and view in sql server?

1159

Distinguish between commit and rollback?

899

What is exporting and importing utility?

1017

How do you rebuild an identity column?

895

What is 3nf normalization form?

1024

Explain where clause?

932

What is difference between stored procedure and user defined function?

1029