Yeah thanks very much for your help ... I've learnt plenty too.  I've gone ahead and deleted the logs so I hope the next post here is not "whatever you...

OK ... now we're getting somewhere 🙂  I used sp_spaceused to check every single table individually and finally found the REAL culprits (it was always going to be one of...

Hi chaps ... thanks for the info.  Scott, you are right, I ran both those commands and the rtblclassdefs shows as 56k.  Which makes me more confused than ever!  According to the other...

Thanks - I don't mean to doubt you, I just get nervous dicking with things I don't really understand!

I ran that command - it took about 1 second to complete...

should I be doing that to master or msdb?

Hi Zubeyir

I appreciate your help.  I ran the dbcc sqlperf (logspace) and have posted some of the results below ordered by log size.  Nothing really strikes me as significant though. ...

Hi Zubeyir

I get this error when I run that script:

Server: Msg 208, Level 16, State 6, Procedure fnTableSize, Line 31

Invalid object name 'dbo.fnTableSize'.

Server: Msg 208, Level 16, State 1, Line...

Thanks for the reply Zubehir.  No, I don't believe we are using APIs.