SQL Server Performance

about users and logins urgent please

Discussion in 'General DBA Questions' started by manu_dba, May 18, 2006.

  1. manu_dba New Member

    I have restored a database from sql7 to sql 2000.
    now on sql the EM was not working so i used isql...

    i was having access to that server through net meeting...

    can you please help me if I want to check the logins and user information for the databases i have restored.
    how i can check the user and login info on that sql 7 without enterprise manager.
    how i can transfer from sql 7 to sql2000 when i am having access through net meeting to sql 7 .

    can you please suggest me the best solution for this.
  2. spacemonkey New Member

    What in particular about the users do you want to check? Just existence of logins?

    To make sure the users are all there, you can always use master.dbo.sysxlogins, or any db's sysusers table. There is also sp_who and sp_who2 to give some general user data.

  3. Luis Martin Moderator


    Luis Martin

    Although nature commences with reason and ends in experience it is necessary for us to do the opposite, that is to commence with experience and from this to proceed to investigate the reason.
    Leonardo Da Vinci

    Nunca esperes el reconocimiento de tus hijos, eso ocurrirá luego de tu muerte

    All postings are provided “AS IS” with no warranties for accuracy.

  4. satya Moderator

Share This Page