Jeffrey Williams (12/9/2008)
You can check the column 'lob_data_space_id' in the table sys.tables. If there is a value there, then you have LOB data in the table.
Woohoo! That's what I was lookin' for! :w00t:
I also use a combination of SQL 2005 provided maintenance tasks and custom scripts.
Thanks for the tip!
Alan