I'd choose DTS.

Steve Jones

steve@dkranch.net

Pls don't cross post. We check all forums. See the other post.

Steve Jones

steve@dkranch.net

Thanks. Glad someone liked it.

Steve Jones

steve@dkranch.net

I had issues with installing this without shutting down the sevices. Once I shut down the services, it worked.

Steve Jones

steve@dkranch.net

Lonnie, try highlingting and using CTRL-Shift-C to comment a series of lines. Works great to prevent that accidental delete!

Steve Jones

steve@dkranch.net

sorry you don't like it. It's just an attempt at humor.

Steve Jones

steve@dkranch.net

This isn't really encryption. More obfuscation which is a really low level security item.

As Andy said, it's just for casual snooping.

Steve Jones

steve@dkranch.net

Andy, couldn't you use DMO to do this?

Steve Jones

steve@dkranch.net

You can build a file using T-SQL and then run that via ISQL.

Steve Jones

steve@dkranch.net

Can you install the client tools on a workstation and see if this works?

Also, please don't use sa and blank for anything other than this test.

Steve Jones

steve@dkranch.net

Can you install the client tools on a workstation and see if this works?

Also, please don't use sa and blank for anything other than this test.

Steve Jones

steve@dkranch.net

You're welcome. BTW, which did you choose?

Steve Jones

steve@dkranch.net

I took the 7 test last year because there are tons of 7 sites. More than 2000 sites. It was the first very widely adopted SQL version. It will be...

I'd assume this is it:

Windows locale LCID

(locale ID)

Collation designator Code page

Hindi 0x439 Hindi Unicode only

If it isn't there, you will probably have to check with...

Is this in the SQL log or on the client? Also, what OS, Service Pack, MDAC versions?

Haven't seen it.

Steve Jones

steve@dkranch.net