RESTORE in VB

[NevG]

Hi Guys and gals

I am trying to restore a database through vb that a user selects. The syntax is not a problem I have done this several times. The problem I have is restoring the database that the user is currently using.

I have tries USE MASTER and then return to the reletive database asfter the restore. I have tried many things.

Is there a cheap and cheerful way to restore the database I am currently using without getting any errors and finishing with a successful restore.

Thanks fr any help

Nev G

 

[Psychpt]

you must separate the use master from the rest of the restore with a GO.

HTH