Post reply

Database List Update

  • March 1, 2010 at 7:42 am

    #143141

    I found 56 database when run this query

    SELECT name, SUSER_SNAME(owner_sid)FROM sys.databases

    but actually there are only 32 database's i see from SSMS, do i have to update anything when ever a database is deleted as a regualr maintenance job ?

  • March 1, 2010 at 8:01 am

    #1126463

    Are you a database administrator? Do you have permissions on all the database on the instance?

  • March 1, 2010 at 12:39 pm

    #1126650

    I am unable to repeat what you described. If the problem persists, try to resart the SQL Server services to see if this takes care of the issue.

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

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