Post reply

Cant drop down the database.

  • May 8, 2008 at 9:49 am

    #121296

    Hi,

    I cant drop down a database in SQL2K5,my one database dont show + sign which i used to use to drop down the database to view its contents like tables,views etc.

    Do you have any idea what is the problem and solution.

    Thanks Irfan

  • May 8, 2008 at 10:45 am

    #812550

    Usually if you can't expand a database in SSMS it's because the database is not online. Check the status of the database either through sys.databases or DATABESPROPERTYEX.

    Depending on the state of the database dropping it is not possible.

    [font="Verdana"]Markus Bohse[/font]

  • May 8, 2008 at 12:53 pm

    #812628

    Thank you for your time. database log file was corrupted and i did detach/attach the database with generating new logfile and my problem is fixed.

    Thanks again.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply