Post reply

Why can''t I see all users when logged on as sa - SQL Server 2000, SP1

  • April 13, 2006 at 8:06 am

    #190262

    Hi all,

    I have just spotted something strange.  When I look at my sql server 2000 server, and go to my database, then users, I can't see all the users in the list.   I am logged on as sa, but have also tried logging on with windows auth, but no luck.  I am on service pack 1, but the person next to me is on service pack 2 and can see all users when logged on as sa.  Is this a known issue, or am I on the wrong track with the whole service pack thing?

    Thanks,

    Paula.

  • April 13, 2006 at 10:38 am

    #632460

    Are you talking about SQL Server service packs? If so, you really should be at SP3a or SP4. It probably is a service pack issue. Why don't you try installing the same service pack as the other individual and see if that solves the issue?

    -SQLBill

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

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