I'll look. I know there is an ODBC for Unix. There's also a project at GNU to translate the TDS (SQL protocol) for Unix.

Should have some info tomorrow.

Steve Jones

steve@dkranch.net

I hate to say it, but you probablty need a reboot. Disable the job and then check the logs. We'll keep thinking.

Steve Jones

steve@dkranch.net

Interesting. Thanks for the update and glad it be working.

Steve Jones

steve@dkranch.net

Good idea. Let us know if that works.

Steve Jones

steve@dkranch.net

Maybe I'm not such a good writer. I thought I had a comprehensive article, but maybe not.... oh well.

DTS: Desgin the package and choose SAVE AS. There...

I'd kill the spid. Try a couple kill <x>. Does this bring back a rolling back message?

Steve Jones

steve@dkranch.net

I do include the DROP object because it has worked well for me and, other than tables, I like it better than ALTERs.

Addressing your items:

DBA Tools - scripts and stored...

Never seen this. Have you changed any settings? Is there an SP appplied?

I checked my errorlogs and this isn't in them.

Steve Jones

steve@dkranch.net

You'd need to use a linked server and join them as a single source.

You can use the multi data pump thing, but I've never liked it. I'd prefer to use...

I tend to agree with Andy. Another thing to be aware of is that you should only return what you need. I often see select * when only a few...

Thanks dood, I did. Glad I could help.

Steve Jones

steve@dkranch.net

thanks for the feedback. glad to help.

Steve Jones

steve@dkranch.net

I agree with Andy. Large data isn't bad. If the query performs badly, then your design might need some rethinking or use Andy's summary options.

Steve Jones

steve@dkranch.net

Glad to help. Hope it works and let us know.

Steve Jones

steve@dkranch.net

An interesting explanation. And not without merit. Part of my hesitation is that over the years I have seen more bugs (obscure) with views and temp tables than with normal...