to match up with an excel spreadsheet showing us the data translations.

Long story but we are using a query to populate a table then doing a data dump from the...

Thanks everyone!

thanks phil!

AWESOME

Thanks leo!

using this query gives me the correct listing of all the date fields in my DB.

select tbl.name as 'Table', c.name

as 'Column Name', t.name as 'Type'

from sys.columns as c...

I saw those also..

they don't give me the correct results...maybe it's because we transferred old data into the system.

(I think) I need a way to find all date fields in...

ahh...thanks Gail

I think you mean Db requests..

not sure if I understand your question,, but you could switch ip addresses, that will re-direct traffic to a different server..

set define off

('('Kôjee p'Ofoire')')

ummm what?

...you could always capture a trace..

http://support.microsoft.com/kb/834849

query(s) that use temp tables?

Got it thanks John!

I spoke too soon..

when I run

I get

Cannot alter the user 'SVCREMOTE', because it does not exist or you do not have...