Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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

Question Posted / rahul

Answer Posted / rahul

So many ways:
1.) right click on the server name and then click on
properties. From there you can see all the Server details
including sp.

2.) In Query Analyzer window type select @@version and
execute

3.) in Query Analyzer type xp_msver

Is This Answer Correct ?    4 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why truncate is ddl command?

1043

What are examples of triggers?

1060

Can the “if update (colname)” statement be used in a delete trigger?

980

What is difference between joins and subqueries?

1094

What is ddl and dml commands?

889

What is the importance of concurrency control?

1211

Define inner join? Explain with an example?

963

What is right outer join in sql server joins?

1158

What is sql server database?

986

What is logon trigger?

1070

How to loop through result set objects using odbc_fetch_row()?

952

Can a database be shrunk to 0 bytes, if not, why?

1080

What do you understand by SQL*Net?

998

What is the syntax for encrypting a column in SQL Server?

1103

Explain different types of lock modes in sql server 2000?

922