1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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

Question Posted / guest

Answers were Sorted based on User's Feedback



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

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

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

Answer / manohari

SELECT @@VERSION

Is This Answer Correct ?    3 Yes 0 No

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

Answer / hari

Select serverproperty('product level')

Is This Answer Correct ?    0 Yes 2 No

Post New Answer

More SQL Server Interview Questions

What is data compression? : sql server database administration

0 Answers  

What do you mean by an execution plan? Why is it used?

0 Answers  

What do you understand by coalesce in sql server?

0 Answers  

What is a natural primary key?

0 Answers  

Can you tell me the difference between DELETE & TRUNCATE commands?

15 Answers  




Restore database SQL2000, SQL2012 Backup of base is created in Microsoft SQL Server 2000 - 8.00.2066, I can't restore on Microsoft SQL Server 2012 - 11.0.2100.60

3 Answers   IT Decisions,

What is a field name?

0 Answers  

Explain about analysis services?

0 Answers  

What are the characteristics of modern DBMS?

0 Answers   Ericsson,

how can ur insert the emp table

3 Answers   Wipro,

What is table level trigger?

0 Answers  

What is service broker? : sql server database administration

0 Answers  

For more SQL Server Interview Questions Click Here
Categories