Thank you

A very interesting question.

Alas, I could see no other way to work out the answer, than to run the code.

Hugo Kornelis (11/16/2011)

---

My question is: would you like a few more questions of this kind, or would submitting the rest of the questions I was planning expose me to death...

whoop whoop! I learnt something 🙂

But I got the answer wrong 🙁

Thanks for your help Roy.

I just need to get this weekend thing out of the way and start again fresh on Monday.

Ian

We have the database in stand by mode.

I think I will strip it all out , check my scripts and start again.

Do you think it would make a difference if...

On the Web server I have restored the warm standby with the same name as the database in Enterprise.

the name of the subscriber on the web server is different.

EnterpriseEdition.DB1 ->...

I think I have found my answer here.

http://geekswithblogs.net/RobBowman/archive/2009/07/08/scripting-perfmon.aspx

DOH! Right answer, for the wrong reason.

I completely missed the aliases and selected the correct answer on the DATE type.

So I learnt something and won a checky point.

Making this my...

Thanks, good question.

It nicely highlights the difference between the two insert statements.

I appreciate the time & effort you took with the question

Maybe we could exchange them for a 59 millisecond journey across the altantic on the Hibernian Express

http://www.telegraph.co.uk/technology/news/8753784/The-300m-cable-that-will-save-traders-milliseconds.html

-- edited the link

-- sorry, I just can not get that link thing to...

Good question. That woke me up.

Great article.

Is there a way to roll over the logs on a time basis or manually?

I'm thinking of some sort of

DBCC ERRORLOG

sp_cycle_errorlog

equivilant

DOH!

right answer, wrong reason.

I saw the int, an empty string, an implicit conversion and an ISNULL.

Went straight for the NO without reading the rest.

If anyone feels they have ever been...

I think I just fell in love ...

GilaMonster (7/26/2011)

---

Watch...

Good question.

Thank you.