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...

Also, please feel free to post questions here for specific "how does SQL work" questions. We also have lots of beginning articles that should help you get up to speed.

Steve...

A quick search on Technet for "sql 823" gives these articles. Any apply?

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q274310

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q281809

Steve Jones

steve@dkranch.net

The long and short is that I place everything in a separate script and it get's shared (to an "InFlight" folder) or branched (To a specific release).

Each script is short...