Answer / guest

The global variable @@Version stores the build number of the
sqlservr.exe, which is used to determine the service pack
installed.
eg: Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17
2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation
Enterprise Edition on Windows NT 5.0 (Build 2195: Service
Pack 3)

What is the difference between the 2 operating modes of database mirroring? : sql server DBA

0 Answers  

---

How can you control the amount of free space in your index pages? : sql server DBA

0 Answers  

---

i had backup last manday.now i need back monday to now ..how do get backup?

3 Answers   Infozech, Wipro,

---

How can we see the database version in os level

6 Answers   Oracle,

---

How would you determine who has added a row to a table?

4 Answers  

---

In what script is "snap$" created? In what script is the "scott/tiger" schema created?

0 Answers  

---

How would you force a log switch?

4 Answers  

---

How would you go about verifying the network name that the local_listener is currently using?

0 Answers  

---

Explain the use of setting GLOBAL_NAMES equal to TRUE.

1 Answers  

---

Name three advisory statistics you can collect.

1 Answers  

---

List out some of the requirements to setup a sql server failover cluster.? : sql server DBA

0 Answers  

---

Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit

0 Answers  

---