Something from the old thread that should be ported over.

WayneS (4/5/2010)

---

CirquedeSQLeil (4/5/2010)

---

How about we move on to a new topic?

I think the next viable topic would be to hash out...

I have started a new thread on this topic.

http://www.sqlservercentral.com/Forums/Topic897076-10-1.aspx

Have you taken any other certifications?

dma-669038 (4/5/2010)

---

...what i heard from my UG..some people who are managers said pretty emphatically that they would simply not hire an individual with only 1.5 years of expeirence to show...

PaulB-TheOneAndOnly (4/5/2010)

---

Most DBA in the team I work with are over 40 years old; not too late for you.

Reading your post it looks like you have some exposure to SQL...

Jeff Moden (4/4/2010)

---

P.S. There are two huge discussions after articles on the problem of "FizzBuzz". Read the discussions (search for them first, obviously) and understand the difference between...

Jeff Moden (4/4/2010)

---

I'm convinced that Larry wrote that himself. Ignore it or act on it...

Another piece of the puzzle that I just learned today is that each applicant does have to undergo an interview when applying for the MCM. I knew there was...

dma-669038 (4/5/2010)

---

I discussed this with some of my UG members informally. Majority feel 1.5 years of TIS is very less and it is easier to do away with it instead....

With the Enterprise media, you should be able to use the following

setup.exe SKUUPGRADE=1

RBarryYoung (4/5/2010)

---

GilaMonster (3/31/2010)

---

Lynn Pettis (3/31/2010)

---

GilaMonster (3/31/2010)

---

WayneS (3/31/2010)

---

Makes me wonder...

WayneS (4/5/2010)

---

Has we handle the different topics, are we going to have a central place to have this all written down? Jason, are you going to keep your blog up-to-date...

Start with this article.

http://technet.microsoft.com/en-us/library/bb326598.aspx

There it discusses logon events, DDL Triggers, and capturing IP address.

konstantinos.christodoulakis (4/5/2010)

---

OK, I found the solution.

It's really a recursive query, but easier that you make it:

SELECT e1.RES_UID, e1.RES_NAME, e1.RES_TIMESHEET_MGR_UID, e2.RES_NAME AS TimesheetManagerName

FROM MSP_RESOURCES e1 LEFT JOIN MSP_RESOURCES e2 ON e1.RES_TIMESHEET_MGR_UID...

When this issue occurs, do you have any difficulty in pinging the server or establishing an RDP session with the remote server?

Another item to check would be in relation to...