Assembly: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)
This namespace, class, or member is supported only in version 2.0 of the Microsoft .NET Framework.
To get Settings object properties, users can be a member of the public fixed server role.
To set Settings object properties, users must be a member of the sysadmin fixed server role.
'Connect to the local, default instance of SQL Server. Dim srv As Server srv = New Server 'Display information about the instance of SQL Server in Information and Settings. Console.WriteLine("OS Version = " & srv.Information.OSVersion) Console.WriteLine("State = " & srv.Settings.State.ToString) 'Display information specific to the current user in UserOptions. Console.WriteLine("Quoted Identifier support = " & srv.UserOptions.QuotedIdentifier) 'Modify server settings in Settings. srv.Settings.LoginMode = ServerLoginMode.Integrated 'Modify settings specific to the current connection in UserOptions. srv.UserOptions.AbortOnArithmeticErrors = True 'Run the Alter method to make the changes on the instance of SQL Server. srv.Alter()