Is this an interview question?

Anyway, this is more a question for the administration forums.

Furthermore, the question is too vague. There are many types of database mirroring.

But you can start here:

http://msdn.microsoft.com/en-us/library/ms151799.aspx

The red arrow in the control flow?

GSquared (3/3/2011)

---

If anyone's interested in what I've been working on the last six months or so, last night (late) we launched http://www.VisitOrlando.com.

While you won't see my ETL and database work...

Don't apologize,...

Sorry to point out an error again, but now you say in the first...

Low priority? This happens...

Lowell (3/3/2011)

---

via SSIS, it's not possible; you'd have to automate excel in order to do that: formatting codes for excel cells are not exposed.

see this thread for Koen's more complete...

You'll have to use a script component to do that.

You need to keep the value of the first column of the previous row in a variable and check the value...

Phil Parkin (3/3/2011)

---

Koen Verbeeck (3/3/2011)

---

Dammit, if that is the solution, I've wasted 5 minutes of my life typing an answer while continuously...

Dammit, if that is the solution, I've wasted 5 minutes of my life typing an answer while continuously checking the SSMS GUI...

Try using the GUI in SSMS to do this task. Go to the Securables tab of the specific user...

Jeff Moden (3/3/2011)

---

I agree that the cursor will likely be a problem but the Temp Table won't be. It's just a different kind of memory usage. I do...

Step 1: Do you have experience working with the Microsoft BI platform (SSIS, SSAS,...

Layne-812700 (3/2/2011)

---

Hi,

We're in the process of migrating from SQL 2005 to 2008, and we have quite a number of packages. Can we script them out, then do a find-replace...

Are you trying to get the actual value (the intersection of the row causing the error and the column) that caused the row to fail?

I tested it on my dev...