PLs do. This is one reason I avoid Temp tables if possible. There are more bugs associated with temp tables.

Steve Jones

steve@dkranch.net

You will have to use the timestamps to correlate them. You are trying to match an event in Profiler with the worsening or changing performance in Performance Monitor.

Steve Jones

steve@dkranch.net

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