SQL Server Performance

1 question?

Discussion in 'General DBA Questions' started by xiebo2010cx, Aug 15, 2006.

  1. xiebo2010cx Member

    I used 2005 Management Studio on my local machine connecting a remote instance via 1 login. Then used remote desktop login the server using 2000 EM with the different login, I got totally different databse image, looks like different instance.

    So the sql server display diffent image to diffent login based on the privileges? any related reading materials? Thanks.
  2. Bredsox New Member

    Interesting. If the user do not have read permission on the db, then that user won't be able to see the database. I use both 2000 EM and 2005 MS.

  3. Adriaan New Member

    If you're logging on to SQL Server with Windows authentication, and your login for Remote Desktop has restricted access, then you only see the databases and objects for which this login has permissions.
  4. xiebo2010cx Member

    Yes, my windows login for Remote Desktop was in the server role sysadmin, While, I only can see a small part of the whole instance.
  5. Adriaan New Member

    You mentioned "2000 EM". I would think this will show you only types of objects that were already available in SQL 2000.

    Perhaps you are looking for stuff that is new in SQL 2005?

Share This Page