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...

Just to validate, you do have log backups in place? If you're not backing up the log frequently enough, you may be seeing excessive growth. Make sure you are backing...

The thing to do is to put your database into source control, just like a piece of code. That way you can always track changes. Even if only you use...

Personally, I'd take no advice from anyone online about licensing. Get in touch with your Microsoft rep to do these validations. No one here is responsible if we get it...

If you look at the input buffers you'll see a stored procedure call and something with an object id: Object Id = 1053962831

I'd start there. What does that Object id...

I wouldn't use a linked server within SSIS. It should be able to connect directly to both servers in question. Is that the cause of the problem? Not sure since...