Post reply

Not able to view the databases

  • December 3, 2009 at 1:08 am

    #136442

    i am not able to view the DB's when i expand the database's tab in the instance but when executed a query in query analiser its working, really dont know how to fix it, plz help me,

    its sql server 2000 with sp4

  • December 3, 2009 at 1:23 am

    #1086939

    Hi,

    Can you see the system DBs(like master, tempdb…) ,database tab in the enterprise managers?

  • December 3, 2009 at 1:29 am

    #1086940

    yes i am able to see the system tables

  • December 3, 2009 at 1:49 am

    #1086950

    Hi,

    I say about the DBs, but you mentioned the tables, Ok, lets confirm this,

    In the enterprise managers, when expend the database, its not show the DBs except the System DBs. this is what you try to say and this is your query?

  • December 3, 2009 at 2:08 am

    #1086954

    yes, i am sorry it was by mistake speled as tables, its DB's

  • December 3, 2009 at 2:19 am

    #1086957

    Does the available database tab changes the database name when you use following query?

    USE <Any user DB>

    GO

    Also send us select @@version

  • December 3, 2009 at 2:22 am

    #1086959

    Hi,

    In the enterprise managers is some time happened on the client side because of the client and server code pages may not match, but its not the issue in the client side, you delete the server register in the enterprise manager and reregister the server. but if your working in the server side you run the select name,has_dbaccess(name)from master.dbo.sysdatabases and find the DBs.

  • December 9, 2009 at 8:19 am

    #1089883

    just had this happen to me, grant view any tables to the user and this should work.

    let me know.

    sonal.

  • December 12, 2009 at 8:55 pm

    #1091607

    Dear friend,

    I faced the same problem in sql 2000, what you to do is in Enterprise Manager select a SqlServer group add a instance to local. just try this one.

Viewing 9 posts - 1 through 8 (of 8 total)

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