One of the ways I manage my logins is I use group policies for some if possible, and keep records of the logins for all the databases. It easier to...

If Mani's suggestion doesn't seem to work, stop and restart the SQL service, then if needed run the command again.

Jan's solution is dead on! We had several databases go into suspect mode after power failure. Including MSDB. I worked with Microsoft on the MSDB recovery and we deleted and...

Those kind of questions are the most fun.

Corrupt databases occur on Thursday the 5th!!!! Oh wait that was last weeks power outage that caused that not the date on calendar... sorry LOL:D

I agree that asking about a Resource database is misleading and incorrect. In the system db .mdf files master.mdf refers to Master etc. so mssqlsystemresource.mdf should not be considered Resource...

I support SQL 2000 and SQL 2005, from SQL 2005 MSS Mgmt Studio I can access all the systems and do 95% of the tasks needed on the 2000 boxes....

please re-read all the posts. Everything you need is in there.

Abi Chapagai (3/26/2008)

---

Hi Balmukunda,

I checked it and i found following:

Component Name ...

The problem with 2005 at the moment is they have all of these hotfixes out and only recommend installing if you are having the problem the fix corrects. Start out...

That is your base install, download and install service pack2, KB933508 and any other critical patches recommended by microsoft. There is one but I cannot remember it. doing updates after...

Clarification... you did select Databases in the roles? within that you deny or grant

Deny would be like revoke, check that and they cannot do that function.

Try using rolebased permissions.

Under the major security context, add the user to the database in a dbo role. Locate the user in the database and select properties. Under securables ->...

Are you interfacing directly from the server or connecting via Management studio on your pc? If it is the later did you also upgrade your pc to sp2 with KB...