How to assign Server Role ???

• vishal.hatvalne

  SSC Enthusiast

  Points: 193

  More actions

  November 12, 2008 at 5:35 am

  #196191

  Hi ,

  Is there a way to assign Server role to Login via CREATE LOGIN STATEMENT.

  Vishal 🙂

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  November 12, 2008 at 7:20 am

  #897502

  You can't assign a server role as part of the Create Login statement. You need to call sp_addsrvrolemember after creating the login.

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question