Problems with the SHRINK Command

Problems with the SHRINK Command

 

  

Hello gurus,

My database is currently running on SQL Server 7.0 and
the size of the DB is around 12 GB out of which 3 to 4
GB is free space.

I have tried the SHRINK this database using the
Enterprise Manager as well as T-SQL, but no luck.

Is anybody experienced this problem and any work
around to this problem is highly appreciated?

Thanks


__________________________________
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
MS Sql Server LazyDBA home page