Results 1 to 3 of 3

Thread: SQL Server logins

  1. 11-22-2011, 01:22 PM #1
    inet
    inet is offline Registered User
    Join Date
    Mar 2006
    Posts
    127

    SQL Server logins

    Hello All,

    I have named logins and generic logins. For example, jsomebody and test. I need to write a query to exclude named logins. Not sure how to do it. Any ideas?
    Reply With Quote Reply With Quote
  2. 11-22-2011, 04:27 PM #2
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    Are they both SQL Server logins?. If jsomebody is Windows Login then you can query server_principal view for type_desc='WINDOWS LOGIN'

    If it is not windows login then you have to exclude generic logins by putting in NOT IN () clause.
    http://databaseandstorage.blogspot.com
    http://gotodba.weebly.com
    Reply With Quote Reply With Quote
  3. 11-23-2011, 09:34 AM #3
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Sql doesn't know if the login is generic or not but you know, so NOT IN () or IN () clause is your best bet as skhanal said.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules