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!