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

Does index speed up select statements?

0 Answers  

What is Schema? and why we use schemas?

4 Answers  

Explain Normalization and DE normalization

0 Answers   iNautix,

How to create a user to access a database in ms sql server using "create user" statements?

0 Answers  

How to enforce security in sql server? : sql server security

0 Answers  




in how many ways we can use count()

2 Answers  

What is bit data type?

0 Answers  

Explain the difference between HTTP and HTTPS in database?

0 Answers   Wipro,

Explain a join?

0 Answers  

what is unique and xaml nonclustered index

0 Answers  

how many types of store procedre in sqlserver 2000?

2 Answers   ATI,

Why main is user defined function?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories