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 / pavit

Answer Posted / pavit

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

4.) so so so so so so so

Is This Answer Correct ?    1 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is pivot and unpivot?

998

What is row_number()?

972

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

2005

Can we perform backup restore operation on tempdb? : sql server database administration

975

What is 4nf in normalization form?

1008

What is subreport?

141

What is data source document?

1016

Tell about MOM Tool(Microsoft Operator Manager)?

1901

Detail about the hardware which is supported by SQL server?

1047

Can we use where clause in union?

1048

What are the mathematical functions supported by sql server 2005?

1047

What languages bi uses to achieve the goal?

989

List some major differences between triggers and stored procedures?

897

Where in ms sql server is ’100’ equal to ‘0’?

1068

What is the purpose of data source?

1020