Some users uploaded Access tables to SQL are always NVARCHAR type.

I found that nvarchar cause performace problem. Is it true?

Thank you. It works for me.

I ran your script, it list index for that table. I need it.

Can you tell me how to generate index scripts for one table? I need to apply the scripts...

Yes, once change to desc, it works.

Thnaks,

Yes, it works now.

Thanks

Thank you. It works now

Error:

Msg 102, Level 15, State 1, Line 3

Incorrect syntax near '000'.

Msg 105, Level 15, State 1, Line 3

Unclosed quotation mark after the character string '''.

SQL prompt costs $369

I installed ApexSQL, it works great. Thanks.

I created SSIS and ran it.

It copied all tables I need but missing all index from source server.

How to copy exactly the same index for all tables as in source...

Because I only need to import all tables which my applications will need.(user tables)

Someone else will do the rest.

Backup will backup all objects.

Because I need test scripts in which there are a lot of temp tables. I need to modify codes or parameters to run more thank one time. If I do...

Thank you for help.

We are getting there but if MemberName is 'Cazares, Luis A' I want to display as 'Cazares, Luis' as well.

How modify code?

I did windows update, it is ok now.

Thanks for help.

I did backup.

The problem is that order.bak file is not under list.