Still stumped. I ran the query provided, and it only shows 800MB free in the data file:
UsedSpaceMBUnusedSpaceMBType
26.969446.66Log
23448.25800.00Data
23475.2110246.66*** Total for all files ***
I get the extra space in the log file, that isn't what's bothering me.
Here's the second result set detailing each table:
TABLE_ROWSRESERVEDDATAINDEX_SIZEUNUSEDUSED_MBUSED_GB
320511169616169040368208165.64060.1618
27884199000980645688096.67970.0944
303652570725539248163255.73440.0544
1124114846446624160168047.32810.0462
13017433552333761601632.76560.0320
32013033080219764801062432.30470.0315
249922122801108056114411.99220.0117
1085428344706411211688.14840.0080
125866741662725610887.24220.0071
297684104404040244.00780.0039
2151616156816321.57810.0015
60195525281680.53910.0005
178927221616400.26560.0003
14582482008400.24220.0002
186721618416160.21090.0002
172020817616160.20310.0002
13541446424560.14060.0001
10372408240.07030.0001
21732161600.03130.0000
24332161600.03130.0000
7168800.01560.0000
15168800.01560.0000
18168800.01560.0000
13168800.01560.0000
39168800.01560.0000
1168800.01560.0000
2168800.01560.0000
000000.00000.0000
From that, it looks like the data is less than a Gig.
I looked for any odd data types, like char(8000), but all I saw were some char(6), char(10), etc...although I would think that those would fall under the RESERVED category anyway.
Forgot to mention in my first post, build 10.50.1600, no database snapshots, full text catalogs, etc...
Still stumped 🙁