steve smith-401573 (12/14/2011)

---

@okbangas:

Agreed that virtually any compatible version of SQL Server can work as witness. Not sure about 'older' versions as witness, but as you observed, since you can...

Have to agree with Gus, going?

Actually, if you do take the time...

steve smith-401573 (12/13/2011)

---

Lynn,

Are you saying that, unless all three instances are taken down together, any two instances unavailable breaks the mirror and stops processing of client transactions?

I already identified in...

First, you still haven't provided any of the information I have asked for: CREATE TABLE statement(s), sample data as a series of INSERT INTO statements for the table(s) involved, expected...

steve smith-401573 (12/12/2011)

---

Scenario: Using all virtual servers and same version of SS 2008 SE for principal, mirror and witness. Only two physical hosts. Principal on one host,...

First, since you are preparing for an interview, the best advice I can give is stay away from cursors. There is almost always a set-based solution to solving problems...

I have to ask again, what are you trying to accomplish besides learning how to use cursors?

If SQL Server is not running you should be able to copy the mdf/ldf files to the new host.

Just remember that if you install the evaluation version (free), it does have a limitation on how long you can use it. If you can afford spending about $50,...

The simple answer, no.

Jack Corbett (12/8/2011)

---

Brandie Tarvin (12/8/2011)

---

So with this Redmond report about IT losing jobs this year, and possibly next year, how upbeat or pessimistic are you feeling about the industry?

It's...

PaulB-TheOneAndOnly (12/8/2011)

---

I'm pretty sure this is homework, that's why I'm just pointing poster's nose...

NOw, how about explaining what it is you are trying to accomplish? Also, it may also help if you provided us with the DDL (CREATE TABLE statement) for the...

CELKO (12/7/2011)

---

I like the MySQL convention of using double zeroes for months and years, That is 'yyyy-mm-00' for a month within a year and 'yyyy-00-00' for the whole year. The...

Ray K (12/7/2011)

---

Can't say I have. I wouldn't know...