How to determine the service pack currently installed on
SQL Server?
Answer Posted / pavit
So many ways:
1.) right click on the server name and then click on
properties. From there you can see all the Server details
including sp.
2.) In Query Analyzer window type select @@version and
execute
3.) in Query Analyzer type xp_msver
4.) so so so so so so so
| Is This Answer Correct ? | 1 Yes | 4 No |
Post New Answer View All Answers
What are a database and a data warehouse?
Define Joins?
What are the different types of backups avaialabe in sql server 2005?
Explain stored procedure?
What is candidate key with example?
What are the two authentication modes in sql server?
How to drop an existing user defined function in ms sql server?
What are system databases into sql server (2005/2008)?
How to add additional conditions in SQL?
What is store procedure? How do they work?
What is a scheduled job or what is a scheduled task?
How can we improve performance by using SQL Server profiler?
Difference between report and query parameter. Why do we need different type of parameter?
What is explicit mode in sql server?
i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.