awesome, thanks Grant! I'll look into it. Right now we need to find out what the issues are so the load issue is ok for now while we troubleshoot. I...

Last question - Is there not a way to go deeper to see the whole transactions that took place? The provided statements give me the tables, but the system gets...

Ok so, I was able to run a query of deadlocks (didn't know you could do that) from the link Grant gave me. I can tell which tables are affected,...

• This reply was modified 3 months, 2 weeks ago by Mike-342950.

Thanks for the replies!

I was able to figure out how to run a trace using SQL profiler, so that is running for deadlocks. Nothing yet. I did get a deadlock...

OK Thanks! I will work on it and let you know how it works!

This is great! I have one question. Since the values are in a table already, would I still need a temp table?

Thanks! I will try it out.