Connection options using SMO

• schleep

  SSChampion

  Points: 12582

  More actions

  June 6, 2016 at 11:45 am

  #400244

  I'm trying to set the following for a single connection (so that I can create a Unique Constraint on a computed varbinary column)

  I want to do this in PoSh using SMO, rather than executing T-SQL -- if possible.

  So, is this under Server.UserOptions? I don't want to permanently change server settings; it's just so I can create the constraint.

  SET NUMERIC_ROUNDABORT OFF

  GO

  SET ANSI_NULLS ON

  GO

  SET ANSI_PADDING ON

  GO

  SET ANSI_WARNINGS ON

  GO

  SET ARITHABORT ON

  GO

  SET CONCAT_NULL_YIELDS_NULL ON

  GO

  SET QUOTED_IDENTIFIER ON

  GO

  Thanks!