write a stored procedure to check for any matches in the database row

• swe-773881

  Newbie

  Points: 1

  More actions

  June 8, 2008 at 9:22 am

  #186534

  i have created a activation page for activating the users account, i need to write a login query to check for activation bit in users db row and only login if user is activated ,if not display an error message

• Jeffrey Williams

  SSC Guru

  Points: 90350

  More actions

  June 8, 2008 at 11:19 am

  #825903

  Are you looking for something like:

  SELECT is_disabled FROM sys.sql_logins WHERE name = 'username';

  Or,

  SELECT is_disabled FROM sys.server_principals WHERE name = 'username';

  Jeff

  Jeffrey Williams
  “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

  ― Charles R. Swindoll

  How to post questions to get better answers faster
  Managing Transaction Logs