From your output, only the default trace is running and there is no way to modify the settings.

You CAN turn it off. but why?

The default trace should be running... by...

looks like a good idea to me.

I agree on the 'who polices the police' point made by SQLPirate.

This shouldn't run on the agent of each system because the job...

I would create the index on the columns in your delete statement's where clause.

It won't take that long if the disk is fairly fast and your delete will be far...

I would create the index on the columns in your delete statement's where clause.

It won't take that long if the disk is fairly fast and your delete will be far...

select * from :: fn_trace_getinfo(0)

I'm guessing it's the default trace, but who knows.

the trace settings also include a maximum number of rollover files, which will delete the oldest file automatically.

Good...

Agent can't run without SQL Server running so that answers the question.

And if SQL Server is running you can't fail over.

It needs to shutdown on one node and the resources...

look at the books online for

sysjobactivity

http://msdn.microsoft.com/en-us/library/ms190484.aspx

and sysjobhistory

http://msdn.microsoft.com/en-us/library/ms174997.aspx

They're updated by [msdb].[dbo].[sp_sqlagent_log_jobhistory]

That gets run when SQL Agent finishes a step. When the step = 0 (the whole job)

the...

So SQL is still running, I assume... but probably shutting down?

what does the SQL error log say?

use dbcc shrinkfile to shrink the logfile.

Warning:

Many times the logfile is the size it is for a reason...

whether it's logging reindexes or what have you.

If you're really concerned about...

You shrink the files with DBCC Shrinkfile

http://msdn.microsoft.com/en-us/library/ms189493%28SQL.90%29.aspx

Orphaned login.

Run

exec sp_change_users_login 'report'

in the upgraded database and see how many users need to have thier SIDS synchronized or don't exist as logins on the server.

you can fix it...

I would try something like this:

I usually just write a select statement that works for all cases then add the INSERT on top.

This left join syntax is common for the...

This should be all the basic info for the default trace.

select * from :: fn_trace_getinfo(0)

where traceid=1

Yep.

see my...