Out of space on 6.5 DB

Need to know how to shrink a 6.5 DB. When going inot Shrink dialog it won't let me change it to any amount less thatn what it is already set to.

DBCC won't let me do it bc I have to be in single mode.

Any other options? I know in 7/2K you can:
Backup Database dbname with truncate_only and then restore the bak file.Wow, you're looking for a history lesson here! I'd first try to blow out the log using:
DUMP TRANSACTION myDB WITH TRUNCATE_ONLYYou are correct, SQL 6.5 won't (actually can't) shrink a database unless that database is in single user mode.

-PatP|||I thought that in order to shrink a 6.5 database (device files and all, that is), was to create a new database smaller than the first, and try to import all the data in from the old.|||That's one way, but dumping the log is often enough, and if you can put the database into single user mode you can shrink them. In some ways, 6.5 would allow you to do things that 2000 can't do because the 6.5 device manager is so much "simpler minded" that it can do things that aren't possible in a more sophisticated environment.

-PatP