I wouldn't recommend using Profiler on a production system. The way it gathers data can lead to performance problems. Better to set the trace up using TSQL scripts.

If you can't...

aaron.reese (4/3/2012)

---

Why? - not saying it won't but what makes you think that...

There must be something else going on. You should be seeing Football first. See this example from AdventureWorks

You can see the SalesPerson and then the SalesPersonQuotaHistory. Yours should be going...

And the JOIN criteria

DRP.rank = DRD.rank + 1

I suspect that's going to lead to scans too.

Come on. I'm not that dangerous.

dianerstein 8713 (4/3/2012)

---

My company has such extreme change control procedures, it is difficult to put anything into production. There is so much you need to fill out to put anything...

The things I'd look at first are the two processes. Each of those shows you the lock that it was holding. That's where the conflict comes in, so that's the...

S_Kumar_S (4/3/2012)

---

Thanks So much Grant! Good to see big guys helping out "lesser knowns" 🙂

Grant Fritchey (4/3/2012)

---

Since you're trying to track data changes, batch_requests and rpc_complete are the two events...

Since you're trying to track data changes, batch_requests and rpc_complete are the two events I would track. For details on how to use extended events, hit the Books Online and...

I posted the question on twitter (#sqlhelp) to get some more feedback. This is anticipated behavior (at least according to Microsoft). You can see it in this Connect item.

Basically...

There is no "ideal" deployment. In most systems I've worked on, I put the database into source control and then use comparisons between source control and a database to generate...

Depending on what you're trying to do, you may want to use a different account for production and non-production environments in order to prevent any chance of a non-production environment...

You just use the OBJECT_NAME function to identify the object in question.

That's a good one. It looks like the minus sign is reversing the division, creating a multiplication when is then divided, unless you set the parenthesis so that it's a...

What about setting up an extended events session and just capturing changes over time. Then, if something goes wrong, you query the extended events results and see who did what...