This is a great tool, but i found two errors:

1.- The values of bit columns are changed by True and False values.

2.- In some cases, the values NULL are changed...

I hope to explain my problem.

Thanks for your comments.

Deusdit Correa Cornejo

----------------------

Br. Computer Science

Microsoft Certified Database Administrator

Analyst Programmer

----------------------

A example, I have the follow Metadata table:

MetadataKey, TableName, ColumnName

1, 'ORGANIZATION', 'ORGANIZATION_KEY'

2, 'ORGANIZATION', 'NAME'

3, 'ORGANIZATION', 'MAX_RECORD_TIME'

The table organization exists in my database.

I need create a query for this table from...

Well, i want to use metadata about some tables, so i need a procedure for construct the table from the metadata.

For example, i have the table name and column name...

Thanks Steve, but this is not the problem, because in Query Analyzer all it's correct and i don't get the error the limit execeed. The problem is with DTS Designer.

Do...

Thanks Andy, i download the trial version this tool, SQL Compare and for me is a very good tool.

Thanks again.

Deusdit Correa Cornejo

----------------------

Br. Computer Science

Microsoft Certified Database Administrator

Analyst Programmer

----------------------

Sorry by the duplicate :).

Deusdit Correa Cornejo

----------------------

Br. Computer Science

Microsoft Certified Database Administrator

Analyst Programmer

----------------------

Thanks for the response, because these confirmed my opinion about the alias.

About ISNULL() function, this not function sometimes because in a NULL column not detect this value. I think...