Post reply

Enterprise Manager with (no items) on database folder

  • March 2, 2005 at 10:57 am

    #85268

    Does someone knows what is this??

    I have an instance that on Enterprise Manager the folder databases is with (no items). I don't know what can be this..

     

     

    Thanks and Regards,

     

    Felipe

  • March 2, 2005 at 12:38 pm

    #544984

    Make sure you have permission to view the databases on this server.

  • March 2, 2005 at 12:41 pm

    #544985

    Yes, i have permission. Because i have the sa pass!

  • March 2, 2005 at 12:53 pm

    #544993

    When i execute the folow query on Query Analyzer:

    select * from sysdatabases

     

    I HAVE THIS ERROR:

    (2 row(s) affected)

    Server: Msg 220, Level 16, State 1, Line 1

    Arithmetic overflow error for data type smallint, value = 38472.

  • March 2, 2005 at 2:50 pm

    #545036

    Did you recently place some databases in 'offline' status?

    If so, you need to open query analyzer and run

    --To bring a database back online

    sp_dboption @dbname = 'dbname'

    , @optname = 'offline'

    , @optvalue = 'false'

    Then try to open Enterprise Manager again. I can't remember if I had to stop and start the SQL Service before I could regain access or not. I have discovered that if I place dbs in offline status and reboot the server, that occassionally I will receive this error.

    Hope this helps,



    Michelle

  • March 3, 2005 at 6:45 am

    #545190

    Michele.

    This works.

     

    Thanks very much!!

Viewing 6 posts - 1 through 5 (of 5 total)

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