ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
Do you have a collection of Interview Questions and interested to share with us!!
Please send that collection to along with your userid / name. ThanQ
Google
 
Categories  >>  Software  >>  Databases  >>  SQL Server
 
 


 

 
 Oracle interview questions  Oracle Interview Questions
 SQL Server interview questions  SQL Server Interview Questions
 MS Access interview questions  MS Access Interview Questions
 MySQL interview questions  MySQL Interview Questions
 Postgre interview questions  Postgre Interview Questions
 Sybase interview questions  Sybase Interview Questions
 DB Architecture interview questions  DB Architecture Interview Questions
 DB Administration interview questions  DB Administration Interview Questions
 DB Development interview questions  DB Development Interview Questions
 SQL PLSQL interview questions  SQL PLSQL Interview Questions
 Databases AllOther interview questions  Databases AllOther Interview Questions
Question 
How to determine the service pack currently installed on 
SQL Server?
 Question Submitted By :: Swapna
I also faced this Question!!     Rank Answer Posted By  
 
  Re: How to determine the service pack currently installed on SQL Server?
Answer
# 1		 
The global variable @@Version stores the build number of 
the sqlservr.exe, which is used to determine the service 
pack installed.
 
Is This Answer Correct ?    4 Yes 0 No
Swapna
 
  Re: How to determine the service pack currently installed on SQL Server?
Answer
# 2		 
SELECT SERVERPROPERTY('PRODUCTLEVEL')
 
Is This Answer Correct ?    3 Yes 0 No
Ramesh.l.v
 
 
 
  Re: How to determine the service pack currently installed on SQL Server?
Answer
# 3		 
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 ?    2 Yes 0 No
Rahul
 
  Re: How to determine the service pack currently installed on SQL Server?
Answer
# 4		 
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 ?    0 Yes 0 No
Pavit
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
Advantages and Disadvantages of Cursor? Zenith10
what are default? Is there a column to which a default cant be bound?  1
Can you explain the role of each service?  1
write the query for taking database backup in sql Logica-CMG6
Different Types of Functions ? Satyam2
how to select a field with firstletter as capital and remaining are small letters  8
WHAT OPERATOR PERFORMS PATTERN MATCHING? CTS2
What is data integrity? Explain constraints? Thinksoft1
How to perfor If the table running time is taking 2hours and table is having 10 rows in it?  1
Write an SQL query if u want to select the data from one block which intern reflects in another block ? thanx,do reply Covansys1
What is a job?  3
From where can you change the default port?  3
how to get the rowid/rownumbes of a table in sqlserver IBM5
what is the out put of below queries? a. select * from Emp where null = null; b. select * from Emp where 1=1; Patni9
how to rename the table  3
What is the system function to get the current user's user id? HCL1
What are statistics, under what circumstances they go out of date, how do you update them? HCL2
Alternative way to DetDate() function?  4
Accidentally i deleted my table. How can i get that table?  4
How can I know what query is executing by by a particural user? (using sp id or any othe way.)  2
 
For more SQL Server Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us |   interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com