Try starting sql server from the command line not as a service with the -c option

sqlservr -c.

If it still doesn't start, start it with -e option and provide the...

can you run sp_helpuser from query analyzer and see what permissions the user has ?

Also, if you restored the database from a backup, you might want to run

sp_change_users-login 'auto_fix',username

Can you try creating another user and grant him db_owner permission and try with that user.

can you verify the registration property my right clicking your SQL server and verify that the...

If a user has db_owner permission, you shouldn't have any problems. Can you post the SQL and the error message. Are you trying to access a table in another database ?

Can you verify the file you are using is the right file ?

Also just try the following

restore database database_name from disk = '' with replace

can you run a trace on DB2 Side and see what is exactly being executed ? Below is a KB article which might not be related but does reference an...

I have never used Arcserver but can you try restoring the backup file to the filesystem and then try to restore ?

1) User should be a member of db_ddladmin to create, update procedure.

2) If you want to give execute permissions to all stored procedures in a database to a user, you can...

F.Y.I.

SELECT * FROM OPENROWSET('SQLOLEDB', 'server_name';'uid';'pwd', 'SELECT * FROM master..sysdatabases')

you cannot separate the users with a comma. But you can open a cursor and go through each and every row one at a time.

You can set the DEADLOCK_PRIORITY to LOW for T1 so that it does not block T2.

Ronnie,

I believe below is what might have happened in your case.  SQL Server manages security on two layers, logins and users. A login grants you access in the server but...

Any user is a member of the public role in the database. The public role is granted access to many of the system tables.But You might want to be careful in...

Can you give more details ? Do you mean you are getting errors with cross database ownership ?

Are you looking to change the default database for the login ? if yes then,  just double-click the login in Enterprise Manager and at the bottom it says Defaults. You...