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)

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  

---

Which types of backups you can take in Oracle? 2. A database is running in NOARCHIVELOG mode then which type of backups you can take? 3. Can you take partial backups if the Database is running in NOARCHIVELOG mode? 4. Can you take Online Backups if the the database is running in NOARCHIVELOG mode?

11 Answers  

---

How can you rebuild an index?

6 Answers  

---

how can you initialize log miner?

0 Answers   Oracle,

---

---

Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

0 Answers  

---

what is a crs resource?

0 Answers   Oracle,

---

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

2 Answers   IBM,

---

How would you extract DDL of a table without using a GUI tool?

0 Answers  

---

what r the types of backup?

5 Answers   CSC,

---

What is RAID and what are different types of RAID configurations?

1 Answers  

---

Compare and contrast TRUNCATE and DELETE for a table.

7 Answers  

---