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 >> DB Administration
  2. Suggest New Category

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

Question Posted / guest


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

Answer / guest

The global variable @@Version stores the build number of the
sqlservr.exe, which is used to determine the service pack
installed.
eg: Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17
2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation
Enterprise Edition on Windows NT 5.0 (Build 2195: Service
Pack 3)

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More DB Administration Interview Questions

what is difference between user managed backup and rman backup?

1 Answers   CTS,

How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?

1 Answers  

What is a correlated sub-query? : sql server DBA

0 Answers  

now one user in online.now i want drop him..how do u drop him?

4 Answers   Wipro,

Why would you use sql agent? : sql server DBA

0 Answers  

What are the steps you will take to improve performance of a poor performing query?

0 Answers  

How would you determine the time zone under which a database was operating?

2 Answers  

What is transparent data encryption? : sql server DBA

0 Answers  

If we issue alter database begin backup. What happens to database?

2 Answers  

How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.

4 Answers  

You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?

3 Answers  

what is the use of ocr?

0 Answers   Oracle,

For more DB Administration Interview Questions Click Here
Categories