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
What is SQL Azure Fabric?
define and explain the differences between clustered and non-clustered indexes.
Do comments need to go in a special place in sql server 2005?
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?
Mention the differences between local and global temporary tables.
I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration
Explain cursor as data base object?
Differentiate sql server reporting services vs. Crystal reports?
Explain what is lock escalation?
How can we call UDF(User Define Function) using C# code in ASP.net ?
What is table join?
What is named calculation? : sql server analysis services, ssas
Is sql server difficult to learn?
What is your recommendation for a query running very slow? : sql server database administration
Why should one not prefix user stored procedures with ‘sp_’?