Re: Permission to restore databases and access them without being

Hi Erland,
You could not reproduce the error if you use 'sa' which is a built-in account. You can simply
create a SQL login and only grant CREATE DATABASE permission to it. Then log on your SQL
Server with the new login and run the RESTORE DATABASE statement. Then you should be
able to reproduce the error message and if you open Enterprise Manager or refresh the
database list in Query Analyzer, you will find that the database is created.

Best regards,
Charles Wang
Microsoft Online Community Support
=========================================================
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg@xxxxxxxxxxxxxx
=========================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
=========================================================


.

Relevant Pages

  • Re: msaccess.exe remains in task manager; which vars cause?
    ... >> Hey, kiln, could you provide a simple set of steps to reproduce this ... ideally using the Nortthwind sample database? ... > the result of the orig feild's computation, ... If you can come up with a minimal scenario to reproduce it, ...
    (microsoft.public.access.formscoding)
  • Date Flip Bug
    ... dates retrieved from a database into a date datatype flip ... inexplicably from european to US format. ... To Reproduce: no reliable method to reproduce - it might take days, ...
    (microsoft.public.vb.bugs)
  • Re: msaccess.exe remains in task manager; which vars cause?
    ... >> Hey, kiln, could you provide a simple set of steps to reproduce this ... ideally using the Nortthwind sample database? ... > the result of the orig feild's computation, ... If you can come up with a minimal scenario to reproduce it, ...
    (microsoft.public.access.modulesdaovba)
  • RE: listbox doesnt refresh after adding an item
    ... > the dataset's change to the database. ... > Winform databinding is a 2 ways databinding, that is the change in the ... > I can not reproduce our your issue yet. ... > figure out the problem.(You may attach the reproduce project as an ...
    (microsoft.public.dotnet.framework.windowsforms)
  • RE: listbox doesnt refresh after adding an item
    ... Winform databinding is a 2 ways databinding, that is the change in the ... I can not reproduce our your issue yet. ... I think this issue should have nothing to do with the database, ... figure out the problem.(You may attach the reproduce project as an ...
    (microsoft.public.dotnet.framework.windowsforms)