error 21776 the db name was not found in the databases collection.

Posted on 2007-08-09
Last Modified: 2010-06-10
Can I get some help with this error please.
Question by:sharscho
    LVL 10

    Expert Comment

    We will need some context: E.g. what software, tools, platform, etc.?

    Author Comment

    mssqlserver 2000, win2003. This user db got deleted because it appeared twice but now it gives this error. I created a new one but still it does not get recognized what I don't understand. I need to fix from the point where I deleted this db. Right now there are 2 of this same db name in the db list which none can be accessed because of this error. I am in enterprise manager.
    LVL 10

    Accepted Solution

    Enterprise manager doesn't always keep its displays up to date correctly.  Exit the program and then start it again to get a more accurate picture of how things are now.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    I recently came across an interesting Question In EE ( and was puzzled about how to achieve that using SSIS out of the box tasks, which was i…
    Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
    Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
    Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now