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 index, cluster index and nonclustered index?
How to modify an existing user defined function?
How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?
Explain system rowset functions?
What are the differences between clustered and non-clustered index?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
Can you insert NULL in unique column?
How to connect to a sql server using odbc_connect()?
How to delete multiple rows with one delete statement in ms sql server?
What is the difference between rank and dense_rank?
What are the characteristics of modern DBMS?
What is hot add cpu in sql server 2008?
Determine how to use the inserted and deleted pseudo tables?
Explain timestamp datatype?
Define msdb database?