Interested to Buy Any Domain ? << Click Here >> for more details...
How to determine the service pack currently installed on
SQL Server?
- 4 Answers
- 10661 Views
- HCL, I also Faced
- E-Mail Answers
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
If a user does not have permission to a table, but has permission to a view created on it, will he be able to view the data in table?
What is table constraint?
Tell me about pre-defined functions of sql?
Can We Use Data-grids For Our Report In Ssrs?
How to create a Master database in SQL server ?
What are partitioned views and distributed partitioned views?
Can we return Data from 4(more than 1) tables in stored procedure?
What are the filtered indexes?
Why is sql server log file full?
Is foreign key a primary key?
What is outer join in sql server joins?
What are the advantages of partitioning?
What is store procedure? How do they work?
How to change the data type of an existing column with "alter table" statements in ms sql server?
how many bits ip address consist of? : Sql server database administration
