+1 for this solution which got demo'd at SQL in the City last week. Your best bet would be to speak to the guys and girls...

Good thinking Penfold! 🙂

They're both...

Thanks Elliot, we're scheduled to have another look at this one tomorrow. The only difference I've got on my gmail setup is the port number so I'll give that...

Hugo Kornelis (6/18/2013)

---

To understand the mechanics, start with the subquery:

SELECT Departmentid

FROM Emptable AS Emptable_1

WHERE (Empid...

Elliott Whitlow (6/17/2013)

---

I know you said everything is spelled correctly and you could connect via telnet and ping.

I'm verifying that you are trying telnet and ping by name and not...

Ambiguity thou art a bitch!!

Luckily got it right but it was always going to be a gamble due to the available answers!

kapil_kk (6/14/2013)

---

Lokesh Vij (6/13/2013)

---

My eyes winked when I looked at this code

DROP TABLE [dbo].[IndexTable]

SELECT * FROM indextable

Qotd aks about "the output of select statement", but as per the code this...

Thanks for responding so quickly guys.

@Gail - that'll teach me to read the error messages in full - when I grow up I want to be a proper DBA!! 😀

I was wondering about the collation issue (i.e. case sensitive or not) and as the question didn't specify the collation I took a punt...... and got it wrong! Hey Ho....

This one made me chuckle even though I went for the sp_addmessage answer, very good start to my day. 😀

Problem solved (ish):- Caused by 32bit OS restricted to max of 4Gb - time to get to the root of what is using so much memory now then!! 😀

+1 to that but I was looking for a catch somewhere in the answers though (paranoid much!!)...

Liked that one, looked innocuous at first then had a think about it and had a facepalm moment as I was writing out what I thought the results would be...

Thanks Ness,...

Interesting one, had to use sp_help though as I wasn't 100% sure! 😀