Dan,

Gotcha, thanks for explaining that.

BTW I did get a reply on this at the Microsoft forum for...

Lowell (5/19/2010)

---

some powerful thread pruning occurred;

i had posted the following and then reported them to the SSC gods:

i'm thinking that chinnu.saha and pinky.bd420 are bots that are just designed...

[Imagine well drawn image of human face with mouth gaping wide open and a look of shock and horror on the face]

IN order to create a Login you must connect...

Brandie Tarvin (4/30/2010)

---

One of our corporate teams monitors that sort of thing for us (Server is offsite) and notified us of these problems. Some alerts are auto, some are manual.

Our...

Luke,

I haven't read over the article you linked in your reply but the title alone and the fact its about SSIS is enough to make me think this just may...

Thanks everyone for the replies and links/examples; they've definately helped.

Lynn Pettis (4/15/2010)

---

Hard to say. Can you recreate the problem in a test environment that you could share the code with us? I'd rather not have you post...

WayneS (4/12/2010)

---

This doesn't answer your question, but maybe it will help with the underlying issue.

Since you want to capture the data from the dmv, while not capture the data periodically...

Thanks for sharing Matthias. Different strokes for different folks so don't take the below as a criticism, just some of us have different coding styles so if you...

Schadenfreude-Mei (4/13/2010)

---

YSL,

Completely agree with you and believe me, my position and the hoops I have to jump through are far from ideal; thats why i put in the bit about...

Schadenfreude-Mei (4/13/2010)

---

Ivanna Noh (4/12/2010)

---

I've posted about this before, but it's relevant to this discussion too...

We have a mirrored database in production which is reindexed once a week - the reindexing...

Ivanna Noh (4/12/2010)

---

I've posted about this before, but it's relevant to this discussion too...

We have a mirrored database in production which is reindexed once a week - the reindexing causes...

Yeah, I'm not trying to stop all...

We don't mirror so we also do the 'switch' thing but I was hoping there might be somtheing better.

Thanks

I just read thru the posts at the Kehayias thread (http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/d5cb4004-02fb-4b41-a321-5197f8105941) on this, (provided thanks to Weksh Corgi.

Luckily for me and my specific scenario I can go with 'ON COMPLETION'...