USE THIS QUERY

sp_change_users_login 'REPORT'

Report: Lists the users, and their corresponding security identifiers (SID), that are in the current database, not linked to any login.

user and login must be NULL,...

The particular database to which insertion occurs is in SIMPLE recovery model is that a cause???

Its a dual core machine with 4GB RAM.

Sorry to post here ....

Its a 2000 server.Both the access db and sql server db in the same machine.

The data from access is exported to sql server in every 3...

Thanks 2 ALL 😀

If you want multiple servers then you need to install server only.

Can i restore msdb now with the old msdb backup???Is ther issue in restoring msdb now after restoring master and all other databases??

Files were not in the same path at ,first copied all files to that path and then run servr.exe.All databases were listed but in suspect mode, restored all databases and...

Hi Gila ,

Am able to restore the master db and theservice is not starting now...reinstalled sql server 🙁

Can you please tell the order...

From syslogin view am only able to get logins and database names.Is the database names are those to which they are mapped or just the default database in the logins.What...

Am really sorry for that and will definitely try to eliminate mistakes like this.

Thanks for your help

I got error that the present version is lower than the backup of master.The present one had sp3 ,thinking that earlier one had sp4 i installed sp4 and now the...

Will Restoring the master DB gives the mapping of all users to respective databases???

Command prompt showing

2008-09-01 14:38:26.40 spid4 Recovery complete.

2008-09-01 14:38:26.41 spid4 SQL global counter collection task is created.

2008-09-01 15:15:36.50 spid51 Using...

Given the command sqlservr -c -m at its taking so long displaying messages like executing procedures.What to do am i going through the right way??

stopped services.

run sqlservr -c -m

Can...