The actual insert/update/delete into a table variable is logged iirc, which makes sense should there be a problem with that transaction during processing you don't necessarily want partial data entered...

hemakumar_p (6/29/2010)

---

Hi,

SQL Expression edition is cool tool and comes with free of cost.

Express edition don't have Agent to schedule the jobs and reporting services But we can do a custom...

Or is it more like this:

CREATE TABLE #T(Id INT,date1 DATETIME,date2 DATETIME)

INSERT INTO #T

SELECT 1,'2/1/2007','1/31/2010' UNION ALL

SELECT 2,'2/1/2007','2/1/2010' UNION ALL

SELECT 3, '2/1/2007','1/15/2010' UNION ALL

SELECT 4, '2/1/2007','2/2/2010'

SELECT

...

Actually, if you take the time to read all 16.072 (at this writing) posts of the this thread, Are the posted questions getting worse?, you will learn a lot...

Which thread are you talking about?

Michael Valentine Jones (6/29/2010)

---

It's not all love and kisses around here; Check...

Jeff Moden (6/29/2010)

---

Michael Valentine Jones (6/29/2010)

---

It's not all love and kisses around...

Rebooting a server does not break the mirror, it will reestablish when the server comes back online. My question is what is the purpose of the mirror if your application...

Okay, you have configured database mirroring, what next.

First, is you mirror configured with a witness to allow automatic failover?

Two, have you configured your application database connections so they are aware...

Steve Jones - Editor (6/28/2010)

---

Not questioning the way things are done according to the rules now. I am questioning why we don't have different rules in the World Cup? I...

alex.kolesar (6/28/2010)

---

I got it working. I needed to Grant Connect on endpoint on the principal side, that's what was screwing it up.

GRANT CONNECT ON ENDPOINT::Endpoint_Mirroring TO [Somedomain\someuser];

WOW. Thanks...

Here is why he couldn't change his call after seeing it in instant replay, he is bound by the same Laws of the Game as the players and coaches. ...

I will agree that there have been some bad calls, some made and some that should have. Over all, however, I think the officiating has been good. I...

I have to agree with Jeff. I have found I don't have as much time right now to hang out on the forums. Guess I am going to...

alex.kolesar (6/24/2010)

---

So im connecting from the principal server to the mirror server using "SQL Server Administration", the sa account. How would I grant the sa account CONNECT privileges on...