hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.

0 Answers  

---

Can a rule be bound to any column of any data type?

0 Answers  

---

Explain syntax for disabling triggers?

0 Answers  

---

Other than truncate statement, which other command can by-pass the trigger on the tables?

0 Answers  

---

Explain log shipping and mention its advantages.

0 Answers  

---

---

What is row_number function?

0 Answers  

---

What are the two authentication modes in sql server?

0 Answers  

---

Department ----------- salary Deptname 1000 A 3000 A 2000 B 3000 B 4000 C 5000 C select the deptname where salary >=5000 result should be: Deptname --------- C please post only executed query in SQL server 2005 Asked By: Md. Niyaz

3 Answers  

---

how many triggers you can have on a table? : Sql server database administration

0 Answers  

---

Why do we use sql limitations? Which constraints can we use while making a database in sql?

0 Answers  

---

What happens if null values are involved in datetime operations?

0 Answers  

---

What structure can you implement for the database to speed up table reads?

0 Answers  

---