Missing Info in Enterprise Mgr

  • Warning...Very new to Sql Server.

    In Sql Server 7.0 I can no longer view the contents of any tables, Views, etc. For Example, I can see all the tables, but when I try to Open Or go into Design, It returns a blank screen with disabled buttons. This didn't use to happen. Also, I am the only that has access at this point

    Thanks in advance for any ideas.

    fryere

  • Are you connecting as SA?

    Andy

  • I saw somethign similar and it was a client installation issue. You might try reinstalling the client tools.

    Also, what SP?

    Steve Jones

    steve@dkranch.net

  • Andy,

    That was a good question. I learned a lot by trying to verify how I was logging on.

    I finally got it to prompt me for a logon. However logging on as the 'sa' makes no difference.

    Steve: Console Mgr Bld 1381 SP-6

    (is that what you meant?)

    fryere

  • Sorry Steve meant SQL SP, run SELECT @@VERSION and post the output if you are not sure, we can figure out from that. However I would try a reinstall of just the client tools as could be a number things with the com layer or try installing a more current service pack.

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

  • Version Info : 7.00.623

    I will take the suggestion & re-install the client tools.

    Thanks.

    fryere

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

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