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

Explain indexed views and partitioned view with their syntax.

1146

How can you stop stored procedures from recompiling?

900

How to select an exiting database using mssql_select_db()?

992

What does ss stand for sexually?

1089

How do I open port 1433?

933

Can we take the full database backup in log shipping?

955

What is bulkcopy in sql?

949

What are the difference between “where” and “having” clause in sql server?

1076

What is awe?

1015

Why variables called the most powerful component of ssis?

1082

How is sql used in sql server?

1015

What are the transaction properties?

1023

Explain indexed views?

988

What is the importance of a recovery model?

1051

In what three ways is the return statement used in a stored procedure?

1009