I too am interested the responses to this one.

I do this by using sp_columns.

Look at sp_columns and sp_tables

In Cold Fusion this is literally about 3 lines of code.

That is a FACT!

Johnathan hit the "nail on the head" - beautiful!!

Thank you!

Thanks guys.

My round-a-bout approach was:

(DATEDIFF(day, [field to compare],GetDate) < 365)

This is a closed topic thanks to guarddata - he hit it right on the head.

No, it is not UNICODE. It is merely output from a previous stored procedure.

I am puzzled by this one!

The scripting works great; however, I am still missing something because I still do not get the data?

Sorry for being a pain. What am I missing?

I am using the Export/Import feature - it fails both ways.

I am not familiar with "detaching" a database.

However, I ONLY want to transfer a couple of tables and stored procedures.

...