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.
- Jayesh