Do not cross post. Please post responses here.

This is the 4th post.

I don't think that demographic is captured, but I...

Do not cross post. Please post responses here.

Do not cross post. Please post responses here.

Neither do I.

Take a closer...

Rich Holt (1/6/2010)

---

:exclamation: I should also caution you about the other way to look at this:

If you insert/update/delete TABLE variable rows inside a transaction, and subsequently rollback the...

john.curran.z3g (1/6/2010)

---

I chose C because there wasn't a 'D - None of the above'.

My instance of SQL 2005 coughs with the error:

Msg 208, Level 16, State 1, Line 1

Invalid...

Dave Ballantyne (1/6/2010)

---

GilaMonster (1/6/2010)

---

Why are there so many 'if you don't help me I'll lose my job' posts all over the place? I just got one by PM. Frankly, seeing...

Lutz, Been there done that with the same regrets. Just thought I'd point out his disclaimer as i did agree with his post as well.

What would really have helped...

GilaMonster (1/5/2010)

---

Lynn Pettis (1/5/2010)

---

Actually, nothing earlier indicated that it was urgent, so more...

lmu92 (1/4/2010)

---

lmu92 (1/4/2010)

---

select * from wce_history where recordedtime >= dateadd(mm,-2,getdate())

dateadd is used to calculate date offsets based on a given date. Getdate() is current date, current time. Please see BOL...

Yes. The 7 AM Tuesday T-Log backup contains all transactions logged since the last T-Log backup Monday night.

And then Gus gives him some code. Think the OP will even respond?

Why are you using a cursor? Can you provide the table DDL (CREATE TABLE statement), sample data (a series of INSERT INTO statements), expected results?

This would help greatly to...