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 attribute hierarchy? : sql server analysis services, ssas

1020

Why SQL Agent is used?

1149

What is the difference between composite index and covering index?

952

How do you create a data source?

910

What is the difference between ddl,dml and dcl commands?

1112

What is the contrast between sql and mysql?

1110

What is pivot and unpivot?

1013

How you can minimize the deadlock situation?

1042

What are the rendering extensions of ssrs?

157

Why transaction is important?

975

What is indexing a document?

1033

Where is localdb stored?

942

How you can get the list of largest tables in a database?

1015

can SSRS reports Cache results?

147

How can I check that whether automatic statistic update is enabled or not?

1042