On Mon, Sep 10, 2012 at 6:22 AM, mathewabraham68007
<mathewabraham68007@...> wrote:

> I checked with a database manager, first the view is dropped and created again, and data is retrived. but for the
> second time the view cannot be dropped..

My gut feeling is that CR is holding to the view and not detatching it
because it's a remote database.
What I would try is using a selectable stored proc instead and
dropping/recreating the view in it or,
even better, just not use a view and do all of the job in the stored.

Please also keep in mind that, remotely, the time needed to drop and
recreate a view
increases because of the network latency and this might be a factor
along side multiple
clients requesting the same report at different, but very close, times.

Regards,

A