When I try with collate I get incorrect syntax..

SELECT

'EXEC sp_rename ''' + TABLE_SCHEMA + '.' + TABLE_NAME + '.' + COLUMN_NAME + ''', ''' + UPPER(COLUMN_NAME) + ''',''COLUMN''' FROM INFORMATION_SCHEMA.COLUMNS...

We are facing some issues on the application with the lower case fields in the database.. So we need to change them all to upper case..

I would really...

When I try without limiting to character fields it works and I seem to get all the fields in lower case.

SELECT

'EXEC sp_rename ''' + TABLE_SCHEMA + '.' + TABLE_NAME +...

Oh no.. Is there a way to find the non character columns that are in lower case? I should may be run the sql for non character fields first and...

Thanks a lot!!

One other doubt, do I need to drop & recreate all DF* and check constraints for those columns before I can rename them?

Thanks

Thanks a lot!!

One other doubt, do I need to drop & recreate all DF* and check constraints for those columns before I can rename them?

Thanks

It works but this generates script for all the columns.. We need the results only for specific tables with the collation !SQL_Latin1_General_CP1_CI_AS for the character columns... I tried the below:

SELECT

...

Thanks... SSMS is very helpful but since we will have to run this on a few environments we need to script it.. I tried the below query, it works to...

Thanks for your reply. Yes it is check constraint.

We have a few char/varchar/nchar columns that we would like the collation to be changed.. To remove the constraints & indexes...

Any suggestions please?

Thanks a lot

I tried the sql using openquery but I'm not getting it right..

SELECT * from OPENQUERY(LS, 'SELECT * FROM U.ABO,

U.LED_ID,

U.PROJECT_NO,

T.WORDC,

...

Thanks a lot for your reply.

We don't have any CLOB/BLOBS columns in the oracle tables.. Since our application code is already written and we are testing the...

Hi all,

APplication connects to non-unicode SQL server database which has linked server connected to unicode Oracle database. Unfortunately, the application does not work when selecting unicode Oracle tables...

Thanks

I agree. But if the length is 0 for trlc.weight in SQL Server, it makes me wonder how this "select * from trlc where weight= ' '; - will return...