Have you tried DBCC SHRINKFILE in single user mode? It might be possible that pending transactions and/or tasks are inhibiting the shrinkage.

Here is a script from the BOL that will defragment indices without going into single user mode:

/*Perform a 'USE <database name>' to select the database in which to run the...

This from the BOL:

Unlike DBCC DBREINDEX or any general index build, DBCC INDEXDEFRAG is an online operation, so it does not hold long-term locks that can block running queries or...

I use the following script for housekeeping:

use MyDb;

DBCC ShrinkDataBase(MyDb,10);

BACKUP LOG MyDb WITH TRUNCATE_ONLY;

DBCC SHRINKFILE(MyDb_log,1);

It shrinks the database, truncates the log, and shrinks the log.

You should use it only after a...

select convert(char(8),getdate(),112) as yyyymmdd

select convert(char(8),getdate(),108) as [hh:mm:ss]

select convert(char(8),getdate(),1) as [mm/dd/yy]

outputs

yyyymmdd

--------

20031218

(1 row(s) affected)

hh:mm:ss

--------

11:28:57

(1 row(s) affected)

mm/dd/yy

----------

12/18/03

(1 row(s) affected)

The options are almost endless. See BOL->"Cast...

You can check in two ways:

(1) Use the Enterprise Manager on the server and navigate to Management->Current Activity->Process Info to find out how many connections are still open to the...