Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Richard Branson
Yak Posting Veteran
84 Posts |
 Posted - 2005-05-27 : 14:03:28
|
| Hi Fellow Code WarriorsStupid Question!!!!Can you run updates and insert new records if the db properties say that the space availabe is 0.00MBI've been getting weird feedback (procedures that run for 30min now run for 2secs) from my db and I suspect that this is what causing the problemPlease help!!ThanksYou can't teach an old mouse new clicks. |
|
|
JimL
SQL Slinging Yak Ranger
1537 Posts |
Posted - 2005-05-27 : 14:19:54
|
| Think A minute You can run a trigger on a update for ether inserted or deleted so both must exist at the same time. YOU NEED ROOM!JimUsers <> Logic |
 |
|
|
Richard Branson
Yak Posting Veteran
84 Posts |
Posted - 2005-05-27 : 14:25:56
|
| The db was setup to have Unrestricted File GrowthIsn't it supposed to do that - Auto Grow?You can't teach an old mouse new clicks. |
|
|
|
ajthepoolman
Constraint Violating Yak Guru
384 Posts |
Posted - 2005-05-27 : 14:27:06
|
| Yeah but once the hardrive fills up that auto grow is out the window! :DAj |
|
|
|
Richard Branson
Yak Posting Veteran
84 Posts |
Posted - 2005-05-27 : 14:33:32
|
| Can I resize (make 'em smaller) my other dbs and use the "recovered" space on the full one?I'm grasping at straws!!You can't teach an old mouse new clicks. |
|
|
|
Richard Branson
Yak Posting Veteran
84 Posts |
Posted - 2005-05-27 : 15:08:41
|
| Dropped a couple of back up tables (out dated) and freed up 7GigsThanksYou can't teach an old mouse new clicks. |
|
|
|
Richard Branson
Yak Posting Veteran
84 Posts |
Posted - 2005-05-27 : 19:52:51
|
| It turns out that it had nothing to do with the space factor.There was something wrong with an underlying triggerBad Kitty!!!You can't teach an old mouse new clicks. |
|
|
|
|
|
|
Space Available