SQL Server creates primary keys (by default) as clustered - which means it gets sorted.

Create a NONCLUSTERED primary key and you should be all set.

It seems so obvious looking at the function name.

Thanks for your help!

I would like to create a variable in my trigger - @DBNAME.
When the trigger executes, this value should be set to the name of the database it was executed in.

E.g. for the master database the...

I would also wrap your sql in some code=sql tags. It's hard to see everything - but for instance, it looks like you have some mixed and/or missing quotes

Yes, export the data as csv - you can do this easily with DTS; or you can do with BCP from the command line:

C:\> BCP database.dbo.table out mytable.csv -S<servername> -Uusername -Ppassword

DTS...

What tables are you querying and what columns are you comparing?