SET IDENTITY INSERT

• geoff hopkins

  Ten Centuries

  Points: 1147

  More actions

  November 10, 2005 at 4:54 am

  #89833

  I wish to do the following:

  SET @sql = "SET IDENTITY_INSERT " + @DB_NAME_TO + ".dbo.TBL_RELATIONSHIPS ON"

  EXEC(@SQL)

  As it may vary which database I write to depending on input paramter, BUT it does not work, I guess its to do with the scope of EXEC dynamic SQL, any work arounds?

• geoff hopkins

  Ten Centuries

  Points: 1147

  More actions

  November 10, 2005 at 5:18 am

  #603196

  include it with the rest of the dynamic SQL