Just created a tmp table and ran the query that looks at the default traces and nothing comes up for temp tables. Appreciate the help.

That's what I was thinking as well. I will run this query

SELECT *

FROM sys.dm_exec_cached_plans

CROSS APPLY sys.dm_exec_sql_text(plan_handle) AS st

WHERE text like '%#%'

look for create...

Hello Chris,

I tried this before, but doesn't this trace only catch the culprit if they create the temp table at the time of the trace being ran? It won't...

That's what I figured, but not what I want to hear. =). Ok next question is then how do we find out who the person is that created...

Sounds good thank Perry. I was going to contact Msft next, but wanted to know if somebody from forums new first. Appreciate it.

Yes both nodes are up. Thanks guys appreciate the information!

Ok sounds good. I'm assuming though you don't need the sql services running on the passive node to run the sql upgrade correct? Sorry this is my first...

I didn't read it I just assumed that since we have to upgrade the passive node first you would need to run the upgrade advisor against the node your upgrading...

Problem is in dev, test and staging these are stand alone servers and in PROD they are clustered does that make a difference?

thanks for the information.

So which one is it? =) I think I will go down the SP 1 first then the cu route. It doesn't hurt I guess to go...

Thank you for the rich feedback!

There are no updates or inserts going on to table1 only to table2.

Alan, your saying for the total time it took to execute and not in real time correct?

Nothing wrong with it. This works too awesome thank you!

awesome thanks all.