Well, you didn't quite mention that in your post:)

In this case, I would write Store Proceduce to perform the update task and then schedule it to run at the time when the DB is available.

I assume that both DBs on the same server.

>Hi,
>But databaseB is not available all the time. It only "open for public" at the end of day.