Thanks for your suggesstions. I will try DTS and update you how it works

I have to do real time syncronization. The table stucture between the database is the name.

Pls guide.

Kapil

I exec the store procedure as exec  IsEffective 'LocationLink' 

Could not find stored procedure 'Select  InDate,AccountID,OutDate From LocationLink'.

Pls guide..

Kapil

CREATE PROCEDURE IsEffective

(        

          @WhereClause varchar(1000)

)

AS

  DECLARE @sql varchar(2000)

             ...