Post reply

Sa login

  • December 6, 2007 at 1:59 am

    #184529

    Hi,

    I have given a project with a list of servers and my client requested to get a report on the servers using sa login.

    Please help me in doing this.

    Thanks.

  • December 6, 2007 at 2:10 am

    #757572

    You can get the information about server in system tables such as sysservers, sysconfigures, sysdevices etc...

    Or just use the search at the top the page for scripts...

    --Ramesh

  • December 6, 2007 at 2:41 am

    #757582

    Thanks for your immediate response.

    Do you have any scripts to find out who are(were) logged in on a server and what databases they access.

  • December 6, 2007 at 2:54 am

    #757586

    Hi,

    Pls. try this:

    SELECT name

    FROM master.dbo.syslogins

    WHERE IS_SRVROLEMEMBER( 'sysadmin' , name ) = 1

    Saravanan

  • December 6, 2007 at 2:56 am

    #757588

    Since I'm a developer, I don't keep much administrative stuffs with myself:hehe:

    Anyways, here is a script to retrieve server information along with current active user information.

    --Ramesh

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

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