SQL Server Performance Forum – Threads Archive

Alter

after Altering the space for the database already created , what can be done inorder to refect in the database .
b’cos i altered the space and it’s replecting only in that .MDF file but not in the database taskpad view Thanks in advance

---

Try sp_helpdb ‘<ur DB name>’ and see what it shows .

---

Have you exited and reopened Enterprise Manager?
Anyway I wouldn’t rely on its informations ans rather execute the sp’s directly in QA and see what they return. —
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Ich unterstütze PASS Deutschland e.V. http://www.sqlpass.de)

---

You need to refresh the content when you want to see new values, EM will not update readily. As suggested by Frank if you need more admin information then QA is best bet. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

---

]]>