I was looking at this script a month or so ago. Maybe you can make it work for your purposes? It sounds pretty close already.

http://www.sqlservercentral.com/scripts/T-SQL/95877/