Dear Gail,

I have send the online enquiry to the MS Customer Support and hope they reply me soon. Hope they can solve quickly.

Anyway, thanks for your advice.

Best Regards,

Eros

Dear Gail,

I have restarted the service. Surely, the db still shows (In Recovery).

So, how can I know it is really recovering or not?

Or what can I do now? Just...

Dear Gail,

Thx for your reply.

I found nothing like 'Recovery of database ...' in the error log.

But I found that one of my service program keep on trying to login to...

You have to connect them by adding the LINKED SERVER entries in any one or both databases. One of the authenication method is that all...

KG,

If I am not mis-understanding your original post, you can do your job easily in DTS.

1. Create the DTS (say called ABC) by saving it...

Can u write VB program?

If yes, then the following code would help you..

Put the Image file into DB

Public Function AddImage(rs As ADODB.Recordset, ByVal...