drop login

• charipg

  SSCrazy Eights

  Points: 9888

  More actions

  October 26, 2012 at 8:22 am

  #284193

  i am excuting a sql script through sqlcmd by passing a sql login.I want to drop the same login after excuted the script.

  sqlcmd -S XXX -U ABC -P XXX -i C:\XXX.sql

  I want to drop the login account"ABC" once script excuted.

• Joie Andrew

  One Orange Chip

  Points: 27360

  More actions

  October 26, 2012 at 1:54 pm

  #1553382

  You will still be logged in while trying to run the command. I do not think it will work. Maybe you could do it scheduling a SQL Server Agent job.

  Joie Andrew
  "Since 1982"