Just as Jeff had said sp_helpdb is what I would have used.

Hi Michael,

I know you already got your answer but I tried this statement and it worked just as well.

select *

from "Table name"

where tag like '% _b'

or tag like 'a_...

Nice site it's put together well!

Check your ole db destination table to see what data types are being used

Error: 0xC0202025 at Export Files, OLE DB Destination 1 [1778]: Cannot create an OLE DB accessor. Verify that the column metadata is valid.

I'm not 100 percent sure, but you may...

I've been working as a sql developer /junior dba for 16 months and constantly

look over BOL and read as many books as I can on when I'm off work or...

Absolutely... hilarious that made my day, well done Shaun.

Nice input dva2007, the group by clause is also a good way to remove duplicate values. Along with distinct.

Problem solved I decided to build an activex script that will move the excel

file to its directory while changing the name every month.