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

List all types of constraints in sql server?

511


what are the three command line utilities and what are their primary functions?

101


Can group functions be mixed with non-group selection fields in ms sql server?

534


Which tcp/ip port does the sql server run on? How can it be changed?

521


What is candidate key with example?

508






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

616


what is package and it uses and how can u call a package

1554


Is it possible to have clustered index on separate drive from original table location?

511


What is the difference between web edition and business edition?

89


How many databases instances are there in sql server 2000?

575


How does index makes search faster?

595


What structure can you implement for the database to speed up table reads?

704


What is the parse query button used for?

600


What is the advantage of sql server?

534


Why we use functions in sql server?

513