Yes it was his only goal for us, on his debut too. He made 10 appearances in all, only a couple of starts though. He didn't play at all for us the following season and went back to Ireland around halfway through. The last time I remember seeing him was in the away end with the City fans at Anfield for the 2007 League Cup tie there. Scored a few for our reserves, as Surge pointed out, but, unfortunately, that didn't lead to him becoming a legend of European football like it did with Etien.
Bluetit is right too, City fans were banned from that game at Wolves. Here's a brief report on the day (including the goals) from Ned Boulting.
https://www.youtube.com/watch?v=p0MmaJEeHEM