Re: Major Problem - lost my whole database

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

ok, I must have wavered over my touchpad and submitted early, sorry.
The above is unfinished and a mixture of drafts! I don't seem to be
able to edit / delete my post - a bit rubbish.

Ok - while waiting for the post to appear so I could edit, I have
figured out the original problem - I uploaded the detached files to a
virtual directory, and so hooked up with that type of permissions
instead of normal permissions - SQL Server didn't get permission, and
so attached the database as read-only.

However, I'd still like any insights as to the second issue (about not
finding the file, even thought I selected it from the directory tree
within the SQL interface), and particularly on restoring a backup when
the database is no longer present in the database.

Thanks, sorry for the extended post.


.

Relevant Pages

  • ADP, Application Role, and objects
    ... The above link is to an atricle on how to implement SQL Server Application ... After you connect with your ADP, fire a bit of code to set the ... third party tools to view the data on the same database. ... Scenario 1 - If I explicitly grant permissions on that object to the user ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Execute Persmission denied on object sp_OACreate
    ... > SQL Server is creating a job behind the scenes. ... > permissions. ... > SA account password and gaining access to the database. ... >>> How can get a user permissions to execute these stored procedures ...
    (microsoft.public.sqlserver.security)
  • Re: Newbie: I dont understand user permissions for table access
    ... > My database is remote to my workstation. ... > tables/fields WITHOUT specifying anything in the permissions dialogs? ... >> HOW are you connecting to SQL Server? ... what rights/permissions have been granted to the PUBLIC role? ...
    (microsoft.public.sqlserver.server)
  • Re: Execute Persmission denied on object sp_OACreate
    ... SQL Server is creating a job behind the scenes. ... SA account password and gaining access to the database. ... > SQL Server doesn't check permissions on indirectly referenced objects as ... > the proxy account security context for non-sysadmin users from Enterprise ...
    (microsoft.public.sqlserver.security)
  • Re: Security question ..
    ... What I want to prevent is any access to the database accept through our ... application unless you have elevated permissions. ... Authentication, if he is smart enough to create an NT Auth ODBC connection ... passes through to the database or to use SQL Server authentication. ...
    (microsoft.public.sqlserver.server)