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  

---

what is differencial backup?how to work?Anybody explai it?

2 Answers   HCL,

---

what information is maintained within the msdb database? : Sql server administration

0 Answers  

---

What are the tables in sql?

0 Answers  

---

WHAT OPERATOR PERFORMS PATTERN MATCHING?

2 Answers   CarrizalSoft Technologies, CTS,

---

---

Do you know what is user defined datatypes and when you should go for them?

0 Answers  

---

What are the 3 types of schema?

0 Answers  

---

What is the process of indexing?

0 Answers  

---

When would you use it?

0 Answers  

---

What is the maximum size of column in sql server?

0 Answers  

---

How to find the version of sql server? : sql server database administration

0 Answers  

---

What is statement level trigger?

0 Answers  

---