Thanks Steve, that was a great question. It's been a crazy morning, but it's good to know I'm not completely crazy just yet. :hehe:

Whew, I haven't had any caffeine this morning, so this one was a toughy. :doze: I only noticed it missing the brackets right before I submitted my answer. Great question,...

jdamm (2/13/2012)

---

I'll add another "Great Question" - I like the questions that make you sit and think about an answer, rather than either run a snippet of code or look...

I've gotten a lot of good stuff from StackOverflow.com

Here, maybe this will help.

Try this

Great Question. That one took me back a ways in the memory banks. I thought I remembered, and I remembered right.:-)

Thanks Steve. Great back to basics question. 😀 easy point today.

Koen Verbeeck (2/6/2012)

---

GilaMonster (2/6/2012)

---

Given the distribution of answers, I'm considering a followup question - "does recovery model ever affect the ability to rollback transactions?" because it appears way too many...

Here's a couple of things you can try.

http://learningpcs.blogspot.com/2011/03/vbscript-format-date-as-yyyy-mm-dd.html

Great question. Just what I needed this morning to get my brain working. Like many others with the QotD I was looking for the obvious (or sometimes not so obvious)...

+1 :hehe:

Nice question. We've just recently started using replication, so this was just what I needed to perk up my Monday.

Thanks Steve. Great, easy question for a Friday. :hehe:

Great question.

I guess it's just a little too early for the brain to be attempting to operate 100%. That's what I get for attempting to answer without some caffeine pumping...

Great question! Was not very familiar with this topic so I leaned something new today. 🙂