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...

can you any body tell me which service pack is installed in
the sql server?

Answer Posted / bharathi

SELECT @@VERSION

Running the above SELECT statemet will give you the version
of SQL server and its SP

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is SQL Azure Fabric?

110


define and explain the differences between clustered and non-clustered indexes.

1194


Do comments need to go in a special place in sql server 2005?

856


A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?

960


Mention the differences between local and global temporary tables.

1043


I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration

1088


Explain cursor as data base object?

1040


Differentiate sql server reporting services vs. Crystal reports?

200


Explain what is lock escalation?

1064


How can we call UDF(User Define Function) using C# code in ASP.net ?

6884


What is table join?

1113


What is named calculation? : sql server analysis services, ssas

980


Is sql server difficult to learn?

919


What is your recommendation for a query running very slow? : sql server database administration

1045


Why should one not prefix user stored procedures with ‘sp_’?

1046