Code error automating replication script

• sunshine-587009

  SSCrazy Eights

  Points: 8981

  More actions

  December 16, 2011 at 11:18 am

  #252167

  Hi there!

  I am trying to test the code below and receiving an error. I've used this code for other things and it seems to work on those.

  exec sp_grant_publication_access @publication = 'Application', @login = @Domain + '\Username'

  GO

  Error.

  Msg 102, Level 15, State 1, Line 24

  Incorrect syntax near '+'.

  Any assistance would be greatly appreciated!

  Happy Friday!

  ¤ §unshine ¤

• Devendrakumar

  SSC-Forever

  Points: 42493

  More actions

  December 17, 2011 at 4:40 am

  #1422817

  Try this...

  SET @DomainUser=@Domain + '\Username' -- New Variable & concat operation

  exec sp_grant_publication_access @publication = 'Application', @login = @DomainUser

  GO