RBarryYoung,

The script works as advertised. It is exactly what we were looking for.

Thank you very much:)

Yes - You are absolutely correct - Scripting to a New Query window and then saving as with encoding does save as an ANSI encoded file. It doesn't ,however, solve...

Hi RBarryYoung,

Please do. That Save button would be awesome.

BTW, I did not mean to offend you in any way with the 'winner' comment. It just happened to be the...

To all those who responded,

Thank you very much. The winner is grasshopper, because, although it is a little cumbersome, the Script Wizard does indeed produce ANSI...

Hey Grasshopper,

We installed the x86 version of SP2 because we have 32 bit machines. We have the 'script' entry for Tools which is nice because we...

Hi GSquared,

Thanks for the input. Although one can save the File as either .SQl or .Txt the character encoding remains the same(Unicode).

If you Right-Click...

Hi Grasshopper,

Thanks for all the info. Our issue is that we started tracking changes in SQL Server 2000. When we would alter a stored procedure, we...