Thanks Gila,

Might you know how to link the SQL being executed with sys.dm_os_waiting_tasks ?

John

https://www.dropbox.com/s/dl6j41aeg94t5tx/LongRunningQuery.JPG?dl=0

What if you right click and open image in a new tab. I tested that and it seems to work.

Thanks everyone, these solutions are similar to some of what I tried. It ends up the source system has a 36 hour day in some cases.... I'm not sure why...

This is how I found the system. I'm not sure why it was set up this way.

I want to thank everyone for the replies. This has been a frustrating and political situation. The organization has quieted back into a reactive rather than responsive or proactive stance....

I like this idea and it has been implemented for some of the SProcs here. Problem is, the code used is cumbersome and makes a 15 line SProc turn into...

I can see it would take a couple of steps to tie an update time to a table this way. TSQL to pull out the table name from a syscomments...

I know SSIS packages (2008 R2) can be stored in the files system and the MSDB database. I know I have SSIS packages installed which are not returned by...

This looks cool, thanks. Any idea how to map the returned folderid and id to something meaningful?

Grant,

Thank you for this overview of the environment. We to have SSDT in our VS/TFS environment but it's not clear that everyone uses the same process for checking in there...

Alvin, I can understand the wisdom in creating the SSIS package even though it's a one time import. Just to have something persistent so the tweaks can be made rather...

Thanks Alvin,

I've looked at the etiquette page and gather my question is not clear. It's certainly a challenge to articulate. I am looking for documentation telling me which XML file...

Thanks.

I'm using 2008R2 and I'm changing the XML file JetToSSIS. I'd like the nvarchar to default to 2000 instead of 255. I'm not modifying JetToSQL8 or JetToSQL9 because those are...

Most folks with this problem notice two things:

1) Run the browser or SQL Data Tools as administrator and permissions are not a problem.

2) Once Reporting Site Settings are accessed from...