When SQL Server 2000 creates a script, it dumps it into an .sql file with UniCode text. This causes problems with most text editors - I use Multi-Edit.

Can SQL Server 2000 be made to dump the script in plain ASCII text instead of UniCode? If so how do you do it?

Alternately, do you know of a text/programmer's editor that can handle UniCode?

Rand

__________________
Rand

How are you generating the scripts?

If you are using EM, Generate script option for the object(s) you are scripting, look on the 'Options' tab of the dialog. There you will see a 'File Format' section. By default the International setting (UNICODE) is selected, but you can change it to DOS or ANSI (8 bit ASCII)

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com