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

how to select 5 to 7 rows from a table, which contains 10 rows?

21 Answers   IBM,

what is an sql server?

1 Answers  

We create an index to fast the search. How it fast the query? Do we write any special keyword with query?

3 Answers  

Consider the table T1 it consits A,2,3,4 consider another table t2 it contain 1,2a,3a,4a now i need o get the upadted answer

3 Answers  

Explain how to maintain a fill factor in existing indexes?

0 Answers  




Explain the different types of backups available in sql server? : sql server database administration

0 Answers  

What action plan is preferred if sql server is not responding?

0 Answers  

How to insert data with null values?

0 Answers  

What is the command dbcc checkdb used for?

0 Answers  

How to get a list of columns in a view using the "sp_columns" stored procedure?

0 Answers  

Determine when an index is appropriate?

0 Answers  

How to update multiple rows with one update statement in ms sql server?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories