You can use a replay trace (SQL Profiler)

SELECT *

FROM OPENQUERY (LS_ORACLE,'select * from oracletable')

Here LS_ORACLE is a linked server which has provider as "Oracle Provider for OLE DB" and datasource is system datasoruce which points to...

Thanks Chris.

Oh! I thought I was doing something wrong while removing the replication manually.

But if u have 500 + tables EM doesnt sound to be good idea.

Anyways thanks again.

Hi

I was testing Tx replication from sql server 2005 to sql server 2000(push subscriber).

Testing was successful. I referred this article http://support.microsoft.com/kb/324401 to remove replication. But I still see...