Re: Is there a way to find out which login who created a login?

From: Hari Prasad (hari_prasad_k_at_hotmail.com)
Date: 09/19/05

  • Next message: z f: "deny a computer from connecting using sql authentication" 
    Date: Mon, 19 Sep 2005 07:32:01 -0600

    Hi,

    No, SQL Server will not store those information Only Login created date will
    be available in syslogins table

    Thanks
    Hari
    SQL Server MVP

    <mwastesson@gmail.com> wrote in message
    news:1127131830.786619.49910@g43g2000cwa.googlegroups.com...
    > Hi, I have a question about Microsoft Sql Server 7.
    > Is there a way to find out which login who created a login?
    > And how do I find out which login it created?
    >

  • Next message: z f: "deny a computer from connecting using sql authentication"

    Relevant Pages

    • Re: Cannot create a SQL user logon
      ... Tibor Karaszi, SQL Server MVP ... >>> Login to Query Analyzer and execute the below query to check if login ...
      (microsoft.public.sqlserver.setup)
    • Re: Unexpected Login Screen When Accessing SQL Data Via .NET Intra
      ... >> data and the SQL Server is on the same server. ... >> My problem is that one user has started getting a login popup ... >> right in via Windows Authentication like everyone else and like they ...
      (microsoft.public.sqlserver.connect)
    • Re: cannot acees two databases as owner
      ... it does not matter you are a member of the ... the sysadmin fixed server role or if there is no any other Login which is ... group if it's a domain) and you can login to your SQL Server with, ...
      (microsoft.public.sqlserver.setup)
    • Re: Database security design with ASP.net and form-based authentication
      ... Since you already have forms-based security, why not use a single SQL login ... for all database access? ... data entry, guest/view only, admin, report viewer. ... so I'm using SQL Server authentication. ...
      (microsoft.public.sqlserver.security)
    • Re: Credentials not being passed with remote access
      ... allowed windows authentication to work, ... I had assumed johnx was a domain user rather than a local Windows account. ... johnx was set up as a local login on sql server. ...
      (microsoft.public.sqlserver.security)