my problem is tempdb tempdb(dbname) 77752.95 MB(db size) 25345.03 MB (unallocated size) suppose i increased temp db size 10 gb . after increase the temp db showing 87 gb (dbsize) 25346.03MB(unallocated size)--unallocated size is showing same .please clarify.

1 Answers  

---

what is the Enterprise manager(2000) and management studio (2005)?

2 Answers  

---

what are different types of backups available in sql server? : Sql server database administration

0 Answers  

---

What is self contained sub query?

0 Answers  

---

How can we check the sql server version?

0 Answers  

---

---

hi, i have a table called names and field name select * from names name a b c d i want to display like this name a,b,c,d how it is possible Regards Baiju

4 Answers  

---

What is hot add cpu in sql server 2008?

0 Answers  

---

How to create a testing table with test data in ms sql server?

0 Answers  

---

Explain trigger and trigger types?

0 Answers  

---

Explain the categories of stored procedure?

0 Answers  

---

Explain different isolation levels?

4 Answers  

---

system date format is "yy-mm-dd" "select getdate()" ----> 2009-01-24 20:03:28.513 if i write "select dateadd(dd,2,getdate()) ".it returns "2009-01-26 19:59:38.340"...my question is dat could it be possible to retrive da date in da format "26 jan 2009 ...."??

8 Answers  

---