SQLCMD

• JKSQL

  SSCrazy Eights

  Points: 8481

  More actions

  May 11, 2009 at 3:25 pm

  #209384

  I just need the format to run this from a .bat file using sqlcmd

  USE [XXX]

  GO

  CREATE USER [domain\IamBadAtCmd] FOR LOGIN [domain\IamBadAtCmd]

  GO

  USE [XXX]

  GO

  EXEC sp_addrolemember N'db_datawriter', N'domain\IamBadAtCmd'

  GO

  USE [XXX]

  GO

  EXEC sp_addrolemember N'db_datareader', N'domain\IamBadAtCmd'

  GO

• JKSQL

  SSCrazy Eights

  Points: 8481

  More actions

  May 11, 2009 at 3:58 pm

  #992518

  forget it. This works but is this how I should do it?

  -q "EXIT(CREATE USER [Domain\Blah] FOR LOGIN [Blahs])"