Frank's the man...MVP!  Sheet, that's cool! 

And he's not even American.

.

.

.

.

Just kidding about the American part; that's probably to your favor, considering what...

You could pass the Server Name into a proc that executes the dynamic SQL, but it's kinda flaky working with dynamic SQL in DTS.

Instead, you can dynamically change the server/database...

Word!  That's what I like to see.  Frank, you are always a gentleman.  Much http://en.wikipedia.org/wiki/Whuffie to you!

copyfight!

If you are only worried about procs that affect tables, you can set a trigger on each table that logs to another table based on the call "DBCC INPUTBUFFER(@@Spid) ",...

I don't think this is a DTS problem; although it may be.  Is there anything else that would be picking up this file and doing something with it?

Do you have...

Why the heck would you want to?

Definitely...you should do that!  I just wrapped it in the function syntax and added Schemabinding.  Well worth posting, and will probably become a "script of the day".  You may want to...

"DTS stinks, and is foolishly limited in what it can do. There are no format commands to include column names."

Uh...OK; that's totally wrong.  In DTS, the "text file (destination)" object has a property (radio...

"It would probably also overwrite whatever changed your sp_who2's behavior and fix it"

Maybe time for sp_who3? 

PS:  What ever happened to sp_who0 or sp_who1?

On...

"NOT EXISTS" can also be replaces by "LEFT JOIN" and looking for a null in the "WHERE" clause.  The disinctness of your data determinines which one is more optimal.   More...

Nice one, Remi!  Very sweet....can't bum that at all.

As an aside on functions.  I've tested this, and found little to no performance degradation in putting code like this into functions,...

that's pretty stupid that you can't use DTS; it's by far the easiest way to do this.

Look in BOL under:

bcp utility, format files

bcp utility, accessing and changing data:

bcp {[[database_name.][owner].]{table_name |...

The easiest thing to do here is go to the sp_who2 proc (in master database) and alter it by uncommenting the order by in the dynamic SQL.

Hey, Gurus...with the same setup as Chris describes, If I install more than one instance of SQL on the server, would that utilize 2 gigs per instance?

cl