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

Thanks to everyone for taking a minute to help me on this SSIS issue.

I'm trying very hard to like SISS but it feels very muc like SSIS doesn't want...

GSquared (4/6/2010)

---

Set up either a script or job that the IT people need to run before they do a shutdown. Maybe a simple VB.NET Windows app with a "pre-shutdown...

Paul White NZ (4/6/2010)

---

YSLGuru (4/6/2010)

---

If I have an Index that over a full cycle, has a large value under the User_Updates columns but has a value of 0 for all...

At this point I'm goingto assume everyone is just as uncertain about where SSMS keeps its config info as I am. While it doesn't suprose me that no...

I'm confused by your question, did you post this tothe wrong thread perhaps?...

Grant Fritchey (4/6/2010)

---

YSLGuru (4/6/2010)

---

Does anyone know where in BOL or somehwre else like MSDN, one can find detailed explinations on the 4 various metrics tracked by SYS.DM_DB_INDEX_USAGE_STATS , specifically the...

GSquared (4/6/2010)

---

Um, this may be a stupid question, but is your server suddenly shutting down spontaneously on a regular basis?

If I need something to run before the server shuts down,...

After some mroe digging aorund I believe the official answer to this question is NO. I dont; even see where this has changed in 2008 and I'm betting its...

Grant Fritchey (4/6/2010)

---

For the period you're covering, the answer is yes. That still doesn't say that the day before you started or the day after you stop, some query won't...

Jeff - I just read over this thread and was curious if there was...

Thanks. I knwo your as busy as the rest of...

cfradenburg (3/26/2010)

---

There are a few ways to do this. You can create a table that has a list of indexes used each day (remove the check for null stats...

divyanth (3/29/2010)

---

you add the ForEach Loop to the package do you drag it on to the work area and then drop the connection inside of the loop or do...