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

Can sql servers linked to other servers?

552


Explain how dts is used to extract, transform and consolidate data?

589


What is impersonation? What are the different impersonation options available in ssas? : sql server analysis services, ssas

556


How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?

1588


How to see existing views in ms sql server?

554






Does windows server 2016 come with sql server?

507


you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration

539


What is model database? : SQL Server Architecture

578


What is the simplest way to create a new database in ms sql server?

542


What is faster join or union?

608


What is ddl command?

540


How do I delete a sql server database?

553


What is the difference between locking and multi-versioning?

542


what is bit datatype? : Sql server database administration

514


What are synonyms?

533