I am no expert at reading these but you have one of the more interesting ones I have seen....lots of players 😀

It appears that CSTool.dbo.RequestContents is a popular object. This...

The picture is nice, but the XML content of the deadlock graph is preferable. Save it with a .txt extension and attach it to the thread please.

The Conditional Split Transformation in SSIS will make quick work (and by quick I mean quick to develop and perform quick too) of the file you are being asked to...

Sure, HTH.

At first glance I thought maybe you needed an EXEC before the proc call in the second email attempt, but that rule only applies if there is more...

Post the job script.

True. It might be an easier sell than getting a maintenance...

Ninja's_RGR'us (9/21/2011)

---

opc.three (9/21/2011)

---

This thread was an awesome read!

@M_E_K, if this query is consistently pegging your DB instance where it affects other activity consider a defensive move...add a MAXDOP hint to...

In that case you do not need the "SQL Server Integration Services" service to be running at all in order to support the SSIS packages you're migrating. You only get...

File system...so you're executing the all SSIS packages using dtexec.exe?

aleee_shaikh (9/8/2011)

---

Join http://testspot.net where you will find

1. Free online MCQS based tests and competition opportunity.

2. Create and joincustomized groups, tests and competitions.

3. Share your...

Is there a problem in doing this, as I have lots and lots of SSIS packages (SQL 2005) already in place and that are running daily called in sql jobs...

You do not need to wait for another deadlock. In 2008 you can pull the graphs of deadlock events that already occurred:

http://www.sqlservercentral.com/articles/deadlock/65658/%5B/url%5D

Pull some of the graphs and post them to...

You're welcome, HTH.

This thread was an awesome read!

@M_E_K, if this query is consistently pegging your DB instance where it affects other activity consider a defensive move...add a MAXDOP hint to the problem...

Use SUSER_SNAME():

SELECT name,

SUSER_SNAME(owner_sid) AS job_owner

FROM msdb.dbo.sysjobs

ORDER BY name ;