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  

---

Do you know the isolation level that sql server support?

0 Answers  

---

Explain the dbcc pintable command when would you use it?

0 Answers  

---

If suppose in a table ship(name,year),find ship name having first and last name(i.e having space in between) ex: SAINT LOUIS,JET LAKE.

4 Answers  

---

What is the sql server 2000 version number?

0 Answers  

---

How to get a list of all tables with "sys.tables" view in ms sql server?

0 Answers  

---

What do you understand by recursive stored procedure?

0 Answers  

---

What happens if you add a new index to large table?

0 Answers  

---

What is normalization and its forms?

4 Answers   Challenger Financial,

---

what is the basic diffrence betn a col declared in char(1) and in varchar(1)

2 Answers  

---

How to generate the Reports for the Database? I need an Example for it.Will we manually do this or else any script is there? Please let me know ASAP...

1 Answers   Cognizant,

---

Can a table have 2 foreign keys?

0 Answers  

---