How to get SQL server authenticmode

• deba_20032004

  Default port

  Points: 1476

  More actions

  May 27, 2011 at 12:01 am

  #238263

  Dear Sir,

  Is ther any way to get which authentic mode a user login. I don't use of wizard. I want to get use of T-SQL command. So please give me any idea.

  Thanking You

  Debasis Bag;-)

• Mr. Holio

  Hall of Fame

  Points: 3314

  More actions

  May 27, 2011 at 12:17 am

  #1330785

  SELECT name, type, type_desc FROM master.sys.server_principals

  ..or something

  __________________________
  Allzu viel ist ungesund...