What is the best way to find out what attachments are in a database?
Here is what I need. I want to be able to either look at a view or run a agent that will list me all the attachements in the database? It would be nice if I could tell the attachement type (xls, doc, etc).
Is this possible?