Search here, I am sure that has been answered before. I *think* you use Execute and not Openquery ? also set warnings off and on. Google and experiment. Done. Thanks