Interested to Buy Any Domain ? << Click Here >> for more details...
can you any body tell me which service pack is installed in
the sql server?
- 3 Answers
- 5149 Views
- I also Faced
- E-Mail Answers
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
How do you run a trace?
Why do we use sql limitations? Which constraints can we use while making a database in sql?
What is a covered index?
Explain hostprotectionattribute in sql server 2005?
What is the difference between a clustered index and a non-clustered index?
Why are you getting errors when creating a new odbc dsn?
What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?
What is the difference between cube operator and rollup operator? : SQL Server Architecture
What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.
Where are full-text indexes stored?
What is the use of attributehierarchyvisible ? : sql server analysis services, ssas
what is package and it uses and how can u call a package
what is the difference between Delete and Truncate command in SQL
Which operator do you use to return all of the rows from one query except rows are returned in a second query?
What is a non-clustered index?
