Alter Login on Stored procedure

• LMtz

  Mr or Mrs. 500

  Points: 514

  More actions

  November 8, 2007 at 12:11 pm

  #200244

  Hi, I need to implement a stored procedure to create a new login and to change password for logins (Sql Server Ent Edition 2005 sp2).

  I'm using this sintax only to test how to pas values to create login and alter login sentence

  DECLARE @ULOGIN sysname

  SET @ULOGIN = 'TESTER'

  ALTER LOGIN @ULOGIN WITH PASSWORD = '222222222' OLD_PASSWORD = '11111111';

  But alter login sentence is not getting @ulogin value and i need to pass password and old password.

  How can I do this.

  I need some advice, thanks for any help.

• MarkusB

  SSC-Dedicated

  Points: 37370

  More actions

  November 9, 2007 at 3:07 am

  #749766

  You need to use dynamic sql in order to do this

  DECLARE @ULOGIN sysname

  DECLARE @sql nvarchar(500)

  SET @ULOGIN = 'TESTER'

  SET @sql = 'ALTER LOGIN ' + @ULOGIN + ' WITH PASSWORD = ''222222222'' OLD_PASSWORD = ''11111111''';

  EXEC sp_executesql @sql

  [font="Verdana"]Markus Bohse[/font]