I need to go through a whole database and scrub non ascii characters out of
the data such as em dashes and smart quotes. I'm a programmer and not a dba
so my first instinct is to write a program in c# to do this and schedule it
with the task manager. I know there has to be a better way though with dts.
Possibly an activex script? Can someone provide me an example? If
possible, I'd like to loop through every table and column in the schema
without having to refer to them by name.
Thanks for the input!

Jason

Since you're comfortable with C#, you might as well just write the
code to do the scrub. You're probably not going to get any better
performance out of script or T-SQL since you basically have to touch
each character anyway.

-mary

On Sun, 10 Oct 2004 18:42:17 -0400, "Jason Nesbitt"
<jason.nesbitt (AT) GEEmail (DOT) com> wrote: