I found the solution. The problem was, i was not SET NOCOUNT ON in my sp. Hope this will be helpful to many others who have a similar problem.. Thanks, Stevenson Ngila Footman-Walker Associates Ltd http://www.footman-walker.co.uk