You could look at:
- data compression
- dropping unused indexes
- deleting data that is no longer needed
- dropping, or truncating, temp tables that are no longer needed
- archiving old data to another database, on another drive
Be careful before deleting or dropping anything.
The above can only provide temporary relief, if any at all. Eventually, you will likely need more disk space.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]