You could always try running the query below and see how much free space is returned.

SELECT SUM(unallocated_extent_page_count) AS [free pages] ,

(...

Perfect!!!

Thanks!!!

Ok Thanks

The index that I am testing with is only 63 KB.

Thanks for the reply...

Would you happen to have the code for this?

This is what I was hoping to use with the backup devices

DECLARE csrBackups CURSOR FOR

SELECT name FROM sys.sysdevices

OPEN csrBackups

DECLARE...

Perfect!!!

Thanks Ken