Home Forums SQL Server 2005 Administering How space is allocated for new objects in the data files? RE: How space is allocated for new objects in the data files?

  • MANY Thanks for your response. My local drive (H drive) is full. I want to detach this DB and put this in I drive. I tried to put the server in single user mode. I can put the DB in single user but don't want to take any chance.

    I tried sqlwb -m but perhaps this doesn't work in sql 2005. I used to do the same in sqlserver -m in sql 2000 and that was pretty ok. Pls lemme know how to do that...

    -M

    -MJ
    Please do not print mails and docx unless it is absolutely necessary. Spread environmental awareness.