SQL Enterprise... rollback

[bunmiA]

I tried adding columns to a table on a database manually. Unfortunately the database doesnt have a lot of free space, and on saving the columns, it was slowly running out of space. I made the decision to end the (sql enterprise) task via task manager. I am now unable to get into enterprise... I am assuming it is trying to rollback?<>?. can anyone tell me what happens next. will the database still be intact..

thanks

 

[fhlee]

Hi,
First of all, I don't think you can end a service from your TaskManager. I think you ended the SQLMgr which is the control part of the SQL server --you end a service from the ControlPanel.Administration.Services

Therefore, I think your SQL server is still trying to add your column. Even if you ended the service half-way, it will automatically roll-back (auto-recover). So don't panic. However, having very little space will cause the process to be very slow.

regards,
- JOseph
===============

 

[bunmiA]

how can I end it properly so that it rolls back?....