API Diff between 1.2.28 and 1.3.7
11114 Additions
37 Removals
FSharp.Data
FSharp.Data.SqlClient
-
public sealed class Column : IEquatable<Column>, IStructuralEquatable
-
public class Configuration
-
public class DesignTime
-
public sealed class DynamicRecord : DynamicObject
-
public static class Extensions
- public sealed class Column : IEquatable<Column>, IStructuralEquatable
- public sealed class Parameter : IEquatable<Parameter>, IStructuralEquatable
- public abstract class Routine : IEquatable<Routine>, IStructuralEquatable, IComparable<Routine>, IComparable, IStructuralComparable
- public static class SqlDataReader
- public sealed class TypeInfo : IEquatable<TypeInfo>, IStructuralEquatable
- public static FSharpOption<object> parseDefaultValue(string definition, ScalarExpression expr)
- public static a CallSmo<a>(string connString, FSharpFunc<Database, a> f)
- public static FSharpOption<a> DataRow.toOption<a>(DataRow this, string key)
- public static FSharpMap<string, string> GetDefaults(Database db, string twoPartsName, bool isFunction)
- public static FSharpList<Column> GetFunctionColumns(Database db, string twoPartsName)
- public static FSharpList<string> GetFunctions(Database db)
- public static object parseDefaultValue(string value, Type typ)
- public static Tuple<string, string> splitName(string twoPartsName)
- public static void SqlConnection.ClearDataTypesMap(SqlConnection )
- public static IDisposable SqlConnection.UseLocally(SqlConnection )
- public static void SqlConnection.LoadDataTypesMap(SqlConnection )
- public static IDisposable SqlConnection.UseConnection(SqlConnection )
- public static FSharpOption<a> SqlDataReader.toOption<a>(SqlDataReader this, string key)
-
public sealed class Parameter : IEquatable<Parameter>, IStructuralEquatable
-
public class ProgrammabilityQuotationsFactory
-
public sealed class TypeInfo : IEquatable<TypeInfo>, IStructuralEquatable
Microsoft.SqlServer.Management.Common
Microsoft.SqlServer.Management.Sdk.Differencing
Microsoft.SqlServer.Management.Sdk.Differencing.SPI
Microsoft.SqlServer.Management.Sdk.Sfc
-
public abstract class ConditionedSql
-
public class ConditionedSqlList
-
public class DataProvider : IDataReader, IDisposable, IDataRecord
- public enum RetriveMode
- public int Depth { get; }
- public int FieldCount { get; }
- public bool IsClosed { get; }
- public object this[int idx] { get; }
- public object this[string name] { get; }
- public int RecordsAffected { get; }
- public DataProvider(StatementBuilder sb)
- public DataProvider(StatementBuilder sb, RetriveMode rm)
- public void Close()
- public void Dispose()
- public bool GetBoolean(int i)
- public byte GetByte(int i)
- public long GetBytes(int i, long fieldOffset, byte[] buffer, int bufferoffset, int length)
- public char GetChar(int i)
- public long GetChars(int i, long fieldoffset, char[] buffer, int bufferoffset, int length)
- public IDataReader GetData(int i)
- public string GetDataTypeName(int i)
- public DateTime GetDateTime(int i)
- public decimal GetDecimal(int i)
- public double GetDouble(int i)
- public Type GetFieldType(int i)
- public float GetFloat(int i)
- public Guid GetGuid(int i)
- public short GetInt16(int i)
- public int GetInt32(int i)
- public long GetInt64(int i)
- public string GetName(int i)
- public int GetOrdinal(string name)
- public DataTable GetSchemaTable()
- public string GetString(int i)
- public object GetValue(int i)
- public int GetValues(object[] values)
- public void InitRowDataManipulation(ArrayList parentProperties, SortedList postProcessList)
- public void InitSchemaTable(ArrayList parentProperties)
- public bool IsDBNull(int i)
- public bool NextResult()
- public bool Read()
- public void SetConnectionAndQuery(ExecuteSql execSql, string query)
-
public class Dependency
-
public class DependencyChainCollection : ArrayList
-
public class DependencyRequest
-
public class DisplayCategoryKeyAttribute : Attribute, IDisplayKey
-
public class DisplayDescriptionKeyAttribute : Attribute, IDisplayKey
-
public class DisplayNameKeyAttribute : Attribute, IDisplayKey
-
public sealed class DmfIgnorePropertyAttribute : Attribute
-
public abstract class DomainRootKey : SfcKey
-
public class DynamicValuesAttribute : Attribute
-
public class DynamicValueTypeConverter : StringConverter
-
public class Enumerator : MarshalByRefObject
- public Enumerator()
- public static EnumResult GetData(object connectionInfo, Request request)
- public static EnumResult GetData(object connectionInfo, Urn urn)
- public static EnumResult GetData(object connectionInfo, Urn urn, string[] requestedFields)
- public static EnumResult GetData(object connectionInfo, Urn urn, string[] requestedFields, OrderBy[] orderBy)
- public static EnumResult GetData(object connectionInfo, Urn urn, string[] requestedFields, OrderBy orderBy)
- public static void RegisterExtension(Urn urn, string name, Assembly assembly, string implementsType)
- public static void TraceInfo(string trace)
- public static void TraceInfo(string strFormat, object[] arg)
- public DependencyChainCollection EnumDependencies(object connectionInfo, DependencyRequest dependencyRequest)
- public EnumResult Process(object connectionInfo, Request request)
- public ObjectInfo Process(object connectionInfo, RequestObjectInfo requestObjectInfo)
- public ObjectInfo Process(ServerVersion version, RequestObjectInfo requestObjectInfo)
-
public class EnumeratorException : SqlServerManagementException
-
public abstract class EnumObject
-
public class EnumResult
-
public class ExecuteSql
-
public class ExtendedPropertyAttribute : Attribute
-
public class FilterDecoder
-
public abstract class FilterNode
-
public class FilterNodeAttribute : FilterNode
-
public abstract class FilterNodeChildren : FilterNode
-
public class FilterNodeConstant : FilterNode
-
public class FilterNodeFunction : FilterNodeChildren
-
public class FilterNodeGroup : FilterNodeChildren
-
public class FilterNodeOperator : FilterNodeChildren
-
public class FilterPropertyEventArgs : EventArgs
-
public sealed delegate FilterPropertyHandler : MulticastDelegate
-
public interface IAlienObject
-
public interface IAlienRoot
-
public interface IDmfFacet
-
public interface IDynamicProperties
-
public interface IDynamicReadOnly
-
public interface IDynamicValues
-
public interface IDynamicVisible
-
public interface IEnumDependencies
-
public sealed class InternalEnumeratorException : EnumeratorException
-
public sealed class InvalidConfigurationFileEnumeratorException : EnumeratorException
-
public sealed class InvalidPropertyUsageEnumeratorException : EnumeratorException
-
public sealed class InvalidQueryExpressionEnumeratorException : EnumeratorException
-
public sealed class InvalidVersionEnumeratorException : EnumeratorException
-
public interface IReadOnlyCollection : IEnumerable
-
public interface IReadOnlyCollection<T> : IReadOnlyCollection, IEnumerable<T>, IEnumerable
-
public interface IReadOnlyDictionary<K, T> : IReadOnlyCollection<T>, IReadOnlyCollection, IEnumerable<T>, IEnumerable
-
public interface IReadOnlyList<T> : IReadOnlyCollection<T>, IReadOnlyCollection, IEnumerable<T>, IEnumerable
- T this[int index] { get; }
-
public interface IReadOnlySet : IReadOnlyCollection, IEnumerable
-
public interface IReadOnlySet<T> : IReadOnlySet, IReadOnlyCollection<T>, IReadOnlyCollection, IEnumerable<T>, IEnumerable
-
public interface IScriptedByParent
-
public interface ISfcAlterable : IAlterable
-
public interface ISfcCollection
-
public interface ISfcCreatable : ICreatable
-
public interface ISfcDependencyDiscoveryObjectSink
-
public interface ISfcDiscoverObject
-
public interface ISfcDomain : ISfcDomainLite, ISfcHasConnection
-
public interface ISfcDomain2 : ISfcDomain, ISfcDomainLite, ISfcHasConnection
-
public interface ISfcDomainLite : ISfcHasConnection
-
public interface ISfcDroppable : IDroppable
-
public interface ISfcExecutionEngine
-
public interface ISfcHasConnection
-
public interface ISfcMarkForDrop : IMarkForDrop
-
public interface ISfcMovable
-
public interface ISfcNotifyPropertyMetadataChanged
-
public interface ISfcProperty
-
public interface ISfcPropertyProvider : ISfcNotifyPropertyMetadataChanged, INotifyPropertyChanged
-
public interface ISfcPropertySet
-
public interface ISfcPropertyStorageProvider
-
public interface ISfcRenamable
-
public interface ISfcScript
-
public interface ISfcScriptCollector
-
public interface ISfcSerializableUpgrade
-
public interface ISfcSimpleList : IEnumerable<ISfcSimpleNode>, IEnumerable
-
public interface ISfcSimpleMap<TKey, TValue>
- TValue this[TKey key] { get; }
-
public interface ISfcSimpleNode
-
public interface ISfcSupportsDesignMode
-
public interface ISfcValidate
-
public interface ISqlFilterDecoderCallback
-
public interface ISupportDatabaseEngineTypes
-
public interface ISupportInitData
-
public interface ISupportInitDatabaseEngineData
-
public interface ISupportVersions
-
public interface IUrnFragment
-
public interface IXmlSerializationAdapter
-
public class LinkField
-
public enum LinkFieldType
-
public class LinkMultiple
-
public class LocalizableEnumConverter : EnumConverter
-
public class LocalizableMemberDescriptor : MemberDescriptor
-
public class LocalizablePropertyDescriptor : PropertyDescriptor
-
public class LocalizableTypeConverter : TypeConverter
-
public class LocalizedPropertyResourcesAttribute : Attribute
-
public class NamedDomainKey<T> : DomainRootKey, IEquatable<NamedDomainKey<T>> where T : ISfcDomain
-
public class NamedKey<T> : SfcKey, IEquatable<NamedKey<T>> where T : SfcInstance
-
public class ObjectInfo
-
public class ObjectProperty
-
public enum ObjectPropertyUsages
-
public class OrderBy
-
public sealed class PhysicalFacetAttribute : Attribute
-
public enum PhysicalFacetOptions
-
public class PropertiesRequest
-
public class PropertyAlias
-
public enum PropertyMode
-
public class PropertyOrderAttribute : Attribute
-
public sealed class QueryNotSupportedEnumeratorException : EnumeratorException
-
public struct ReadOnlyList<T> : IReadOnlyList<T>, IReadOnlyCollection<T>, IReadOnlyCollection, IEnumerable<T>, IEnumerable
-
public class ReadOnlyPropertyChangedEventArgs : EventArgs
-
public class Request : PropertiesRequest
-
public enum RequestFieldsTypes
-
public class RequestObjectInfo
-
public class RequestParentSelect
-
public enum ResultType
-
public sealed class ResultTypeNotSupportedEnumeratorException : EnumeratorException
-
public sealed class RootFacetAttribute : Attribute
-
public class SchemaNamedKey<T> : SfcKey, IEquatable<SchemaNamedKey<T>> where T : SfcInstance
-
public class SfcAfterObjectMovedEventArgs : SfcEventArgs
-
public class SfcAfterObjectRenamedEventArgs : SfcEventArgs
-
public class SfcApplication
-
public class SfcApplicationEvents
-
public class SfcBeforeObjectMovedEventArgs : SfcEventArgs
-
public class SfcBeforeObjectRenamedEventArgs : SfcEventArgs
-
public abstract class SfcCollatedDictionaryCollection<T, K, ParentT> : SfcCollection<T, K, ParentT>, IComparer<K>, IEnumerable<T>, IEnumerable where T : SfcInstance where K : SfcKey where ParentT : SfcInstance
-
public abstract class SfcCollection<T, K, ParentT> : ICollection<T>, ICollection, ISfcCollection, IEnumerable<T>, IEnumerable, IListSource where T : SfcInstance where K : SfcKey where ParentT : SfcInstance
-
public class SfcCollectionInfo
-
public abstract class SfcConnection : ISfcConnection
-
public class SfcConnectionContext
-
public enum SfcConnectionContextMode
-
public sealed class SfcCRUDOperationFailedException : SfcException
-
public enum SfcDependencyAction
-
public enum SfcDependencyDirection
-
public enum SfcDependencyDiscoveryMode
-
public sealed class SfcDependencyEngine : ISfcDependencyDiscoveryObjectSink, IDisposable
- public class DependencyListEnumerator : IEnumerator<SfcDependencyNode>, IDisposable, IEnumerator, IEnumerable<SfcDependencyNode>, IEnumerable
- public class DependencyNodeEnumerator : IEnumerator<SfcDependencyNode>, IDisposable, IEnumerator, IEnumerable<SfcDependencyNode>, IEnumerable
- public class DependencyTreeEnumerator : IEnumerator<SfcDependencyNode>, IDisposable, IEnumerator, IEnumerable<SfcDependencyNode>, IEnumerable
- public SfcDependencyAction Action { get; }
- public SfcDependencyEngine(SfcDependencyDiscoveryMode mode, SfcDependencyAction action)
- public void Add(SfcInstance objParent, SfcInstance objChild, SfcTypeRelation relation)
- public void Add(SfcInstance obj)
- public void Discover()
- public void Dispose()
- public DependencyListEnumerator GetListEnumerator()
- public DependencyTreeEnumerator GetTreeEnumerator()
-
public sealed class SfcDependencyNode
-
public sealed class SfcDesignModeException : SfcException
-
public abstract class SfcDictionaryCollection<T, K, ParentT> : SfcCollection<T, K, ParentT>, IEnumerable<T>, IEnumerable where T : SfcInstance where K : SfcKey where ParentT : SfcInstance
-
public sealed class SfcDomainInfo
-
public class SfcDomainInfoCollection : ReadOnlyCollection<SfcDomainInfo>
-
public sealed class SfcEmptyXmlException : SfcException
-
public class SfcEventArgs : EventArgs
-
public class SfcException : SqlServerManagementException
-
public abstract class SfcInstance : ISfcDiscoverObject, ISfcPropertyProvider, ISfcNotifyPropertyMetadataChanged, INotifyPropertyChanged
-
public abstract class SfcInstance<K, T> : SfcInstance where K : SfcKey where T : SfcInstance
-
public struct SfcInstanceSerializedData
-
public sealed class SfcInvalidArgumentException : SfcException
-
public sealed class SfcInvalidConnectionContextModeChangeException : SfcException
-
public sealed class SfcInvalidKeyChainException : SfcException
-
public sealed class SfcInvalidKeyException : SfcException
-
public sealed class SfcInvalidMoveException : SfcException
-
public sealed class SfcInvalidQueryExpressionException : SfcException
-
public sealed class SfcInvalidRenameException : SfcException
-
public sealed class SfcInvalidStateException : SfcException
-
public sealed class SfcInvalidStreamException : SfcException
-
public sealed class SfcInvalidXmlParentTypeException : SfcException
-
public abstract class SfcKey : IEquatable<SfcKey>
-
public abstract class SfcListCollection<T, K, ParentT> : SfcCollection<T, K, ParentT>, IEnumerable<T>, IEnumerable where T : SfcInstance where K : SfcKey where ParentT : SfcInstance
-
public class SfcMetadataException : SfcException
-
public sealed class SfcMissingParentException : SfcException
-
public sealed class SfcNonSerializablePropertyException : SfcException
-
public sealed class SfcNonSerializableTypeException : SfcException
-
public class SfcObjectAlteredEventArgs : SfcEventArgs
-
public class SfcObjectCreatedEventArgs : SfcEventArgs
-
public class SfcObjectDroppedEventArgs : SfcEventArgs
-
public class SfcObjectExtender<TSfcInstance> : ISfcPropertyProvider, INotifyPropertyChanged, ISfcNotifyPropertyMetadataChanged where TSfcInstance : ISfcPropertyProvider
-
public abstract class SfcObjectFactory
-
public sealed class SfcObjectInitializationException : SfcException
-
public sealed class SfcObjectNotScriptableException : SfcException
-
public class SfcObjectQuery
-
public enum SfcObjectQueryMode
-
public enum SfcObjectState
-
public sealed class SfcPathConversionException : SfcException
-
public sealed class SfcProperty : ISfcProperty
-
public sealed class SfcPropertyCollection : ICollection, IEnumerable, ISfcPropertySet
-
public class SfcPropertyMetadataChangedEventArgs : PropertyChangedEventArgs
-
public sealed class SfcPropertyNotSetException : SfcException
-
public sealed class SfcPropertyReadOnlyException : SfcException
-
public abstract class SfcProxyInstance<K, T, TRef> : SfcInstance<K, T> where K : SfcKey where T : SfcInstance where TRef : SfcInstance
-
public sealed class SfcQueryConnectionUnavailableException : SfcException
-
public sealed class SfcQueryExpression : IXmlSerializable
-
public abstract class SfcReferenceCollection<K, T, S> : IReadOnlyDictionary<K, T>, IReadOnlyCollection<T>, IReadOnlyCollection, IEnumerable<T>, IEnumerable, IListSource where K : IComparable<K> where T : SfcInstance where S : SfcInstance
-
public sealed class SfcRegistration
-
public static class SfcSecureString
-
public sealed class SfcSecurityException : SfcException
-
public sealed class SfcSerializationException : SfcException
-
public enum SfcSerializedTypes
-
public sealed class SfcSerializer
-
public class SfcSimpleNodeFactory
-
public sealed class SfcSqlCeNotInstalledException : SfcException
-
public class SfcSqlPathUtilities
-
public class SfcTSqlExecutionEngine : ISfcExecutionEngine
-
public sealed class SfcTSqlExecutor
-
public class SfcTsqlProcFormatter
-
public class SfcTSqlScript : ISfcScript
-
public abstract class SfcTypeMetadata
-
public enum SfcTypeRelation
-
public sealed class SfcUnregisteredXmlDomainException : SfcException
-
public sealed class SfcUnregisteredXmlTypeException : SfcException
-
public sealed class SfcUnsupportedVersionException : SfcException
-
public sealed class SfcUnsupportedVersionSerializationException : SfcException
-
public static class SfcUtility
-
public abstract class SimpleNodeAdapter
-
public class SqlEnumResult : EnumResult
-
public abstract class SqlObject : SqlObjectBase, ISupportInitDatabaseEngineData
-
public abstract class SqlObjectBase : EnumObject, ISqlFilterDecoderCallback
-
public class SqlObjectProperty : ObjectProperty
-
public class SqlPropertyLink : ConditionedSql
-
public class SqlRequest : Request
-
public class SqlStoreConnection : SfcConnection
-
public class StatementBuilder
-
public sealed class UnknownPropertyEnumeratorException : EnumeratorException
-
public sealed class UnknownTypeEnumeratorException : EnumeratorException
-
public class UpgradeSession
-
public class Urn
-
public class Util
-
public class ValidationMethod
-
public class ValidationResult
-
public class ValidationState
- public bool HasErrors { get; }
- public bool HasWarnings { get; }
- public IList<ValidationResult> Results { get; }
- public ValidationState()
- public ValidationState(string message, string bindingKey, bool isWarning)
- public ValidationState(Exception error, string bindingKey, bool isWarning)
- public ValidationState(string message, Exception error, string bindingKey, bool isWarning)
- public ValidationState(string message, string bindingKey)
- public ValidationState(Exception error, string bindingKey)
- public ValidationState(string message, Exception error, string bindingKey)
- public void AddError(string message, string bindingKey)
- public void AddError(Exception error, string bindingKey)
- public void AddError(string message, Exception error, string bindingKey)
- public void AddWarning(string message, string bindingKey)
- public void AddWarning(Exception error, string bindingKey)
- public void AddWarning(string message, Exception error, string bindingKey)
-
public class XmlRead
-
public class XmlReadConditionedStatement : XmlReadRepeated
-
public class XmlReadConditionedStatementFailCondition : XmlReadConditionedStatement
-
public class XmlReadConditionedStatementPostfix : XmlReadConditionedStatement
-
public class XmlReadConditionedStatementPostProcess : XmlReadRepeated
-
public class XmlReadConditionedStatementPrefix : XmlReadConditionedStatement
-
public class XmlReadDoc : XmlRead
-
public class XmlReadInclude : XmlRead
-
public class XmlReadLinkFields : XmlReadRepeated
-
public class XmlReadMultipleLink : XmlRead
-
public class XmlReadOrderByRedirect : XmlReadRepeated
-
public class XmlReadParentLink : XmlRead
-
public class XmlReadProperties : XmlRead
-
public class XmlReadProperty : XmlRead
-
public class XmlReadPropertyLink : XmlReadRepeated
-
public class XmlReadRepeated : XmlRead
-
public class XmlReadSettings : XmlRead
-
public class XmlReadSimpleParentLink : XmlReadRepeated
-
public class XmlReadSpecialQuery : XmlRead
-
public class XmlRequestParentSelect : XmlRead
-
public class XmlRequestParentSelectField : XmlReadRepeated
-
public class XmlUtility
-
public class XPathException : EnumeratorException
-
public enum XPathExceptionCode
-
public class XPathExpression
-
public class XPathExpressionBlock
Microsoft.SqlServer.Management.Sdk.Sfc.Metadata
-
public interface ISfcMetadata
-
public interface ISfcMetadataProvider
-
public interface ISfcReferenceCollectionResolver
-
public interface ISfcReferenceCollectionResolver<T, S> : ISfcReferenceCollectionResolver
-
public interface ISfcReferenceResolver
- object Resolve(object instance, object[] args)
-
public interface ISfcReferenceResolver<T, S> : ISfcReferenceResolver
- T Resolve(S instance, object[] args)
-
public sealed delegate ReferenceResolverDelegate : MulticastDelegate
-
public class SfcBrowsableAttribute : Attribute
-
public enum SfcCardinality
-
public enum SfcContainerCardinality
-
public enum SfcContainerRelationship
-
public class SfcElementTypeAttribute : Attribute
-
public class SfcIgnoreAttribute : SfcRelationshipAttribute
-
public class SfcInvalidForTypeAttribute : Attribute
-
public class SfcKeyAttribute : Attribute
-
public class SfcMetadataDiscovery
-
public class SfcMetadataRelation : SfcMetadataDiscovery
- public SfcCardinality Cardinality { get; }
- public Type ContainerType { get; }
- public bool IsBrowsable { get; }
- public object PropertyDefaultValue { get; }
- public SfcPropertyFlags PropertyFlags { get; }
- public string PropertyName { get; }
- public SfcRelationship Relationship { get; }
- public AttributeCollection RelationshipAttributes { get; }
- public bool SupportsDesignMode { get; }
- public SfcMetadataRelation(string propertyName, Type type, SfcCardinality cardinality, SfcRelationship relationship, Type containerType, SfcPropertyFlags flags, object defaultValue, AttributeCollection attributes)
- public SfcMetadataRelation(string propertyName, Type type, SfcCardinality cardinality, SfcRelationship relationship, Type containerType, SfcPropertyFlags flags, AttributeCollection attributes)
- public SfcMetadataRelation(string propertyName, Type type, SfcCardinality cardinality, SfcRelationship relationship, Type containerType, AttributeCollection attributes)
- public SfcMetadataRelation(string propertyName, Type type, SfcCardinality cardinality, SfcRelationship relationship, Type containerType)
- public SfcMetadataRelation(string propertyName, Type type, SfcCardinality cardinality, SfcRelationship relationship, AttributeCollection attributes)
- public SfcMetadataRelation(string propertyName, Type type, SfcCardinality cardinality, AttributeCollection attributes)
- public SfcMetadataRelation(string propertyName, Type type, SfcPropertyFlags flags, AttributeCollection attributes)
- public SfcMetadataRelation(string propertyName, Type type, SfcPropertyFlags flags)
- public SfcMetadataRelation(string propertyName, Type type)
- public object Resolve(object instance)
- public T Resolve<T, S>(S instance)
- public IEnumerable ResolveCollection(object instance)
- public IEnumerable<T> ResolveCollection<T, S>(S instance)
-
public class SfcNonSerializableAttribute : Attribute
-
public class SfcObjectAttribute : SfcRelationshipAttribute
- public bool Deploy { get; set; }
- public bool Design { get; set; }
- public SfcObjectFlags Flags { get; set; }
- public bool NaturalOrder { get; set; }
- public SfcObjectAttribute(SfcObjectFlags flags)
- public SfcObjectAttribute()
- public SfcObjectAttribute(SfcObjectCardinality cardinality, SfcObjectFlags flags)
- public SfcObjectAttribute(SfcObjectCardinality cardinality)
- public SfcObjectAttribute(SfcObjectRelationship relationship, SfcObjectFlags flags)
- public SfcObjectAttribute(SfcObjectRelationship relationship)
- public SfcObjectAttribute(SfcObjectRelationship relationship, SfcObjectCardinality cardinality, SfcObjectFlags flags)
- public SfcObjectAttribute(SfcObjectRelationship relationship, SfcObjectCardinality cardinality)
- public SfcObjectAttribute(Type containsType, SfcObjectFlags flags)
- public SfcObjectAttribute(Type containsType)
- public SfcObjectAttribute(SfcContainerCardinality cardinality, Type containsType, SfcObjectFlags flags)
- public SfcObjectAttribute(SfcContainerCardinality cardinality, Type containsType)
- public SfcObjectAttribute(SfcContainerRelationship relationship, SfcContainerCardinality cardinality, Type containsType, SfcObjectFlags flags)
- public SfcObjectAttribute(SfcContainerRelationship relationship, SfcContainerCardinality cardinality, Type containsType)
-
public enum SfcObjectCardinality
-
public enum SfcObjectFlags
-
public class SfcObjectNotFoundException : SfcException
-
public enum SfcObjectRelationship
-
public class SfcParentAttribute : Attribute
-
public class SfcPropertyAttribute : Attribute
-
public enum SfcPropertyFlags
-
public class SfcReferenceAttribute : Attribute
- public string[] Arguments { get; }
- public ISfcReferenceResolver InstanceResolver { get; }
- public string[] Keys { get; set; }
- public Delegate Resolver { get; }
- public Type Type { get; set; }
- public string UrnTemplate { get; }
- public SfcReferenceAttribute(Type resolverType)
- public SfcReferenceAttribute(Type resolverType, string[] parameters)
- public SfcReferenceAttribute(Type referenceType, string urnTemplate, string[] parameters)
- public SfcReferenceAttribute(Type referenceType, Type resolverType, string methodName, string[] parameters)
- public SfcReferenceAttribute(Type referenceType, string[] keys, string urnTemplate, string[] parameters)
- public SfcReferenceAttribute(Type referenceType, string[] keys, Type resolverType, string methodName, string[] parameters)
- public Urn GetUrn(object instance)
- public T Resolve<T, S>(S instance)
- public object Resolve(object instance)
-
public class SfcReferenceCollectionAttribute : Attribute
-
public sealed delegate SfcReferenceCollectionResolverFactoryDelegate : MulticastDelegate
-
public sealed delegate SfcReferenceResolverFactoryDelegate : MulticastDelegate
-
public class SfcReferenceSelectorAttribute : Attribute
-
public enum SfcRelationship
-
public abstract class SfcRelationshipAttribute : Attribute
-
public class SfcSerializationAdapterAttribute : Attribute
-
public class SfcSkuAttribute : Attribute
-
public class SfcVersionAttribute : Attribute
- public Version BeginVersion { get; }
- public Version EndVersion { get; }
- public SfcVersionAttribute(int beginMajor, int beginMinor, int beginBuild, int beginRevision, int endMajor, int endMinor, int endBuild, int endRevision)
- public SfcVersionAttribute(int beginMajor, int beginMinor, int beginBuild, int beginRevision)
- public SfcVersionAttribute(int beginMajor, int endMajor)
- public SfcVersionAttribute(int beginMajor)
Microsoft.SqlServer.Management.Smo
-
public abstract class AbstractCollectionBase
-
public sealed class AffinityInfo : AffinityInfoBase
-
public abstract class AffinityInfoBase : IAlterable, IScriptable
-
public enum AffinityType
-
public sealed class ApplicationRole : ScriptNameObjectBase, ISfcSupportsDesignMode, IObjectPermission, IAlterable, IDroppable, IRenamable, IExtendedProperties, IScriptable
- public DateTime CreateDate { get; }
- public DateTime DateLastModified { get; }
- public string DefaultSchema { get; set; }
- public ApplicationRoleEvents Events { get; }
- public ExtendedPropertyCollection ExtendedProperties { get; }
- public int ID { get; }
- public Database Parent { get; set; }
- public ApplicationRole()
- public ApplicationRole(Database database, string name)
- public void Alter()
- public void ChangePassword(string password)
- public void ChangePassword(SecureString password)
- public void Create(string password)
- public void Create(SecureString password)
- public void Deny(ObjectPermissionSet permission, string[] granteeNames)
- public void Deny(ObjectPermissionSet permission, string[] granteeNames, bool cascade)
- public void Deny(ObjectPermissionSet permission, string granteeName)
- public void Deny(ObjectPermissionSet permission, string granteeName, bool cascade)
- public void Drop()
- public ObjectPermissionInfo[] EnumObjectPermissions()
- public ObjectPermissionInfo[] EnumObjectPermissions(string granteeName)
- public ObjectPermissionInfo[] EnumObjectPermissions(ObjectPermissionSet permissions)
- public ObjectPermissionInfo[] EnumObjectPermissions(string granteeName, ObjectPermissionSet permissions)
- public void Grant(ObjectPermissionSet permission, string[] granteeNames)
- public void Grant(ObjectPermissionSet permission, string[] granteeNames, bool grantGrant)
- public void Grant(ObjectPermissionSet permission, string[] granteeNames, bool grantGrant, string asRole)
- public void Grant(ObjectPermissionSet permission, string granteeName)
- public void Grant(ObjectPermissionSet permission, string granteeName, bool grantGrant)
- public void Grant(ObjectPermissionSet permission, string granteeName, bool grantGrant, string asRole)
- public void Rename(string newname)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames, bool revokeGrant, bool cascade)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames, bool revokeGrant, bool cascade, string asRole)
- public void Revoke(ObjectPermissionSet permission, string granteeName)
- public void Revoke(ObjectPermissionSet permission, string granteeName, bool revokeGrant, bool cascade)
- public void Revoke(ObjectPermissionSet permission, string granteeName, bool revokeGrant, bool cascade, string asRole)
- public StringCollection Script()
- public StringCollection Script(ScriptingOptions scriptingOptions)
-
public sealed class ApplicationRoleCollection : SimpleObjectCollectionBase
-
public class ApplicationRoleEvents
-
public abstract class ArrayListCollectionBase : SmoCollectionBase
-
public sealed class AsymmetricKey : NamedSmoObject, IAlterable, IDroppable, ISfcSupportsDesignMode, IObjectPermission
- public int ID { get; }
- public AsymmetricKeyEncryptionAlgorithm KeyEncryptionAlgorithm { get; }
- public int KeyLength { get; }
- public string Owner { get; set; }
- public Database Parent { get; set; }
- public PrivateKeyEncryptionType PrivateKeyEncryptionType { get; }
- public string ProviderName { get; set; }
- public byte[] PublicKey { get; }
- public byte[] Sid { get; }
- public byte[] Thumbprint { get; }
- public AsymmetricKey()
- public AsymmetricKey(Database database, string name)
- public void AddPrivateKey(string password)
- public void Alter()
- public void ChangePrivateKeyPassword(string oldPassword, string newPassword)
- public void Create(AsymmetricKeyEncryptionAlgorithm encryptionAlgorithm)
- public void Create(AsymmetricKeyEncryptionAlgorithm encryptionAlgorithm, string password)
- public void Create(string keySource, AsymmetricKeySourceType sourceType)
- public void Create(string keySource, AsymmetricKeySourceType sourceType, string password)
- public void Create(string providerAlgorithm, string providerKeyName, CreateDispositionType createDispositionType, AsymmetricKeySourceType sourceType)
- public void Deny(ObjectPermissionSet permission, string[] granteeNames)
- public void Deny(ObjectPermissionSet permission, string[] granteeNames, bool cascade)
- public void Deny(ObjectPermissionSet permission, string granteeName)
- public void Deny(ObjectPermissionSet permission, string granteeName, bool cascade)
- public void Drop()
- public void Drop(bool removeProviderKey)
- public ObjectPermissionInfo[] EnumObjectPermissions()
- public ObjectPermissionInfo[] EnumObjectPermissions(string granteeName)
- public ObjectPermissionInfo[] EnumObjectPermissions(ObjectPermissionSet permissions)
- public ObjectPermissionInfo[] EnumObjectPermissions(string granteeName, ObjectPermissionSet permissions)
- public void Grant(ObjectPermissionSet permission, string[] granteeNames)
- public void Grant(ObjectPermissionSet permission, string[] granteeNames, bool grantGrant)
- public void Grant(ObjectPermissionSet permission, string[] granteeNames, bool grantGrant, string asRole)
- public void Grant(ObjectPermissionSet permission, string granteeName)
- public void Grant(ObjectPermissionSet permission, string granteeName, bool grantGrant)
- public void Grant(ObjectPermissionSet permission, string granteeName, bool grantGrant, string asRole)
- public void RemovePrivateKey()
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames, bool revokeGrant, bool cascade)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames, bool revokeGrant, bool cascade, string asRole)
- public void Revoke(ObjectPermissionSet permission, string granteeName)
- public void Revoke(ObjectPermissionSet permission, string granteeName, bool revokeGrant, bool cascade)
- public void Revoke(ObjectPermissionSet permission, string granteeName, bool revokeGrant, bool cascade, string asRole)
-
public sealed class AsymmetricKeyCollection : SimpleObjectCollectionBase
-
public enum AsymmetricKeySourceType
-
public enum AttachOptions
-
public sealed class Audit : ScriptNameObjectBase, ICreatable, IAlterable, IDroppable, IRenamable, IScriptable, ISfcSupportsDesignMode
-
public sealed class AuditCollection : SimpleObjectCollectionBase
-
public class AuditExtender : SmoObjectExtender<Audit>, ISfcValidate
-
public class AuditSpecification : ScriptNameObjectBase, ICreatable, IAlterable, IDroppable, IScriptable
-
public struct AuditSpecificationDetail
-
public sealed class AvailabilityDatabase : NamedSmoObject, ICreatable, IDroppable, IScriptable
-
public sealed class AvailabilityDatabaseCollection : SimpleObjectCollectionBase
-
public sealed class AvailabilityGroup : NamedSmoObject, IObjectPermission, ICreatable, IAlterable, IDroppable, IScriptable
- public AvailabilityGroupAutomatedBackupPreference AutomatedBackupPreference { get; set; }
- public AvailabilityDatabaseCollection AvailabilityDatabases { get; }
- public AvailabilityGroupListenerCollection AvailabilityGroupListeners { get; }
- public AvailabilityReplicaCollection AvailabilityReplicas { get; }
- public DatabaseReplicaStateCollection DatabaseReplicaStates { get; }
- public AvailabilityGroupFailureConditionLevel FailureConditionLevel { get; set; }
- public int HealthCheckTimeout { get; set; }
- public int ID { get; }
- public AvailabilityReplicaRole LocalReplicaRole { get; }
- public Server Parent { get; set; }
- public string PrimaryReplicaServerName { get; }
- public Guid UniqueId { get; }
- public AvailabilityGroup()
- public AvailabilityGroup(Server server, string name)
- public void Alter()
- public void Create()
- public void Deny(ObjectPermissionSet permission, string[] granteeNames)
- public void Deny(ObjectPermissionSet permission, string[] granteeNames, bool cascade)
- public void Deny(ObjectPermissionSet permission, string granteeName)
- public void Deny(ObjectPermissionSet permission, string granteeName, bool cascade)
- public void Drop()
- public ObjectPermissionInfo[] EnumObjectPermissions()
- public ObjectPermissionInfo[] EnumObjectPermissions(string granteeName)
- public ObjectPermissionInfo[] EnumObjectPermissions(ObjectPermissionSet permissions)
- public ObjectPermissionInfo[] EnumObjectPermissions(string granteeName, ObjectPermissionSet permissions)
- public DataTable EnumReplicaClusterNodes()
- public void Failover()
- public void FailoverWithPotentialDataLoss()
- public void Grant(ObjectPermissionSet permission, string[] granteeNames)
- public void Grant(ObjectPermissionSet permission, string[] granteeNames, bool grantGrant)
- public void Grant(ObjectPermissionSet permission, string[] granteeNames, bool grantGrant, string asRole)
- public void Grant(ObjectPermissionSet permission, string granteeName)
- public void Grant(ObjectPermissionSet permission, string granteeName, bool grantGrant)
- public void Grant(ObjectPermissionSet permission, string granteeName, bool grantGrant, string asRole)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames, bool revokeGrant, bool cascade)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames, bool revokeGrant, bool cascade, string asRole)
- public void Revoke(ObjectPermissionSet permission, string granteeName)
- public void Revoke(ObjectPermissionSet permission, string granteeName, bool revokeGrant, bool cascade)
- public void Revoke(ObjectPermissionSet permission, string granteeName, bool revokeGrant, bool cascade, string asRole)
- public StringCollection Script()
- public StringCollection Script(ScriptingOptions scriptingOptions)
-
public sealed class AvailabilityGroupCollection : SimpleObjectCollectionBase
-
public sealed class AvailabilityGroupListener : NamedSmoObject, ICreatable, IDroppable, IAlterable, IScriptable
-
public sealed class AvailabilityGroupListenerCollection : SimpleObjectCollectionBase
-
public sealed class AvailabilityGroupListenerIPAddress : SqlSmoObject, ICreatable, IScriptable
-
public sealed class AvailabilityGroupListenerIPAddressCollection : AvailabilityGroupListenerIPAddressCollectionBase
-
public class AvailabilityGroupListenerIPAddressCollectionBase : SortedListCollectionBase
-
public class AvailabilityGroupState : IAvailabilityGroupState, IDmfFacet, IDmfAdapter, IRefreshable
-
public sealed class AvailabilityReplica : NamedSmoObject, ICreatable, IDroppable, IAlterable, IScriptable
-
public sealed class AvailabilityReplicaCollection : SimpleObjectCollectionBase
-
public sealed class BackupDevice : ScriptNameObjectBase, ICreatable, IDroppable, IScriptable
-
public sealed class BackupDeviceCollection : SimpleObjectCollectionBase
-
public sealed class BackupMedia
-
public sealed class BackupMediaSet
-
public sealed class BackupSet
-
public sealed class BackupSetCollection : ICollection, IEnumerable
-
public sealed class Certificate : NamedSmoObject, ICreatable, IDroppable, IAlterable, ISfcSupportsDesignMode, IObjectPermission
- public bool ActiveForServiceBrokerDialog { get; set; }
- public CertificateEvents Events { get; }
- public DateTime ExpirationDate { get; set; }
- public int ID { get; }
- public string Issuer { get; }
- public DateTime LastBackupDate { get; }
- public string Owner { get; set; }
- public Database Parent { get; set; }
- public PrivateKeyEncryptionType PrivateKeyEncryptionType { get; }
- public string Serial { get; }
- public byte[] Sid { get; }
- public DateTime StartDate { get; set; }
- public string Subject { get; set; }
- public byte[] Thumbprint { get; }
- public Certificate()
- public Certificate(Database database, string name)
- public void AddPrivateKey(string privateKeyPath, string decryptionPassword)
- public void AddPrivateKey(string privateKeyPath, string decryptionPassword, string encryptionPassword)
- public void Alter()
- public void ChangePrivateKeyPassword(string oldPassword, string newPassword)
- public void Create()
- public void Create(string encryptionPassword)
- public void Create(string certificateSource, CertificateSourceType sourceType)
- public void Create(string certificateSource, CertificateSourceType sourceType, string privateKeyPath, string privateKeyDecryptionPassword)
- public void Create(string certificateSource, CertificateSourceType sourceType, string privateKeyPath, string privateKeyDecryptionPassword, string privateKeyEncryptionPassword)
- public void Deny(ObjectPermissionSet permission, string[] granteeNames)
- public void Deny(ObjectPermissionSet permission, string[] granteeNames, bool cascade)
- public void Deny(ObjectPermissionSet permission, string granteeName)
- public void Deny(ObjectPermissionSet permission, string granteeName, bool cascade)
- public void Drop()
- public ObjectPermissionInfo[] EnumObjectPermissions()
- public ObjectPermissionInfo[] EnumObjectPermissions(string granteeName)
- public ObjectPermissionInfo[] EnumObjectPermissions(ObjectPermissionSet permissions)
- public ObjectPermissionInfo[] EnumObjectPermissions(string granteeName, ObjectPermissionSet permissions)
- public void Export(string certificatePath)
- public void Export(string certificatePath, string privateKeyPath, string encryptionPassword)
- public void Export(string certificatePath, string privateKeyPath, string encryptionPassword, string decryptionPassword)
- public void Grant(ObjectPermissionSet permission, string[] granteeNames)
- public void Grant(ObjectPermissionSet permission, string[] granteeNames, bool grantGrant)
- public void Grant(ObjectPermissionSet permission, string[] granteeNames, bool grantGrant, string asRole)
- public void Grant(ObjectPermissionSet permission, string granteeName)
- public void Grant(ObjectPermissionSet permission, string granteeName, bool grantGrant)
- public void Grant(ObjectPermissionSet permission, string granteeName, bool grantGrant, string asRole)
- public void RemovePrivateKey()
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames, bool revokeGrant, bool cascade)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames, bool revokeGrant, bool cascade, string asRole)
- public void Revoke(ObjectPermissionSet permission, string granteeName)
- public void Revoke(ObjectPermissionSet permission, string granteeName, bool revokeGrant, bool cascade)
- public void Revoke(ObjectPermissionSet permission, string granteeName, bool revokeGrant, bool cascade, string asRole)
-
public sealed class CertificateCollection : SimpleObjectCollectionBase
-
public class CertificateEvents
-
public enum CertificateSourceType
-
public sealed class Check : ScriptNameObjectBase, ICreatable, IDroppable, IRenamable, IMarkForDrop, IAlterable, IExtendedProperties, IScriptable, ISfcSupportsDesignMode
-
public sealed class CheckCollection : SimpleObjectCollectionBase
-
public sealed class CollectionNotAvailableException : SmoException
-
public sealed class Column : ScriptNameObjectBase, ISfcSupportsDesignMode, IPropertyDataDispatch, ICreatable, IAlterable, IDroppable, IMarkForDrop, IExtendedProperties, IRenamable
- public bool AnsiPaddingStatus { get; }
- public string Collation { get; set; }
- public bool Computed { get; set; }
- public string ComputedText { get; set; }
- public DataType DataType { get; set; }
- public string Default { get; set; }
- public DefaultConstraint DefaultConstraint { get; }
- public string DefaultSchema { get; set; }
- public ExtendedPropertyCollection ExtendedProperties { get; }
- public int ID { get; }
- public bool Identity { get; set; }
- public long IdentityIncrement { get; set; }
- public long IdentitySeed { get; set; }
- public bool InPrimaryKey { get; }
- public bool IsColumnSet { get; set; }
- public bool IsDeterministic { get; }
- public bool IsFileStream { get; set; }
- public bool IsForeignKey { get; }
- public bool IsFullTextIndexed { get; }
- public bool IsPersisted { get; set; }
- public bool IsPrecise { get; }
- public bool IsSparse { get; set; }
- public bool NotForReplication { get; set; }
- public bool Nullable { get; set; }
- public SqlSmoObject Parent { get; set; }
- public bool RowGuidCol { get; set; }
- public string Rule { get; set; }
- public string RuleSchema { get; set; }
- public int StatisticalSemantics { get; }
- public Column()
- public Column(SqlSmoObject parent, string name)
- public Column(SqlSmoObject parent, string name, DataType dataType)
- public Column(SqlSmoObject parent, string name, DataType dataType, bool isFileStream)
- public DefaultConstraint AddDefaultConstraint()
- public DefaultConstraint AddDefaultConstraint(string name)
- public void Alter()
- public void BindDefault(string defaultSchema, string defaultName)
- public void BindRule(string ruleSchema, string ruleName)
- public void Create()
- public void Drop()
- public DataTable EnumForeignKeys()
- public DataTable EnumIndexes()
- public DataTable EnumUserPermissions(string username)
- public void MarkForDrop(bool dropOnAlter)
- public void Rename(string newname)
- public void UnbindDefault()
- public void UnbindRule()
- public void UpdateStatistics()
- public void UpdateStatistics(StatisticsScanType scanType)
- public void UpdateStatistics(StatisticsScanType scanType, int sampleValue)
- public void UpdateStatistics(StatisticsScanType scanType, int sampleValue, bool recompute)
-
public sealed class ColumnCollection : ParameterCollectionBase
-
public sealed class ConfigProperty
-
public sealed class ConfigPropertyCollection : ICollection, IEnumerable
-
public class Configuration : ConfigurationBase
-
public class ConfigurationBase
-
public sealed class Cpu
-
public sealed class CpuCollection : ICollection, IEnumerable
-
public sealed class Credential : NamedSmoObject, ISfcSupportsDesignMode, ICreatable, IAlterable, IDroppable
-
public sealed class CredentialCollection : SimpleObjectCollectionBase
-
public sealed class CryptographicProvider : NamedSmoObject, ISfcSupportsDesignMode, ICreatable, IAlterable, IDroppable, IScriptable
-
public sealed class CryptographicProviderCollection : SimpleObjectCollectionBase
-
public sealed class Database : ScriptNameObjectBase, ICreatable, IAlterable, IDroppable, IRenamable, IExtendedProperties, IScriptable, IDatabaseOptions, IDmfFacet, ISfcSupportsDesignMode, IPropertyDataDispatch
- public int ActiveConnections { get; }
- public DatabaseActiveDirectory ActiveDirectory { get; }
- public bool AnsiNullDefault { get; set; }
- public bool AnsiNullsEnabled { get; set; }
- public bool AnsiPaddingEnabled { get; set; }
- public bool AnsiWarningsEnabled { get; set; }
- public ApplicationRoleCollection ApplicationRoles { get; }
- public bool ArithmeticAbortEnabled { get; set; }
- public SqlAssemblyCollection Assemblies { get; }
- public AsymmetricKeyCollection AsymmetricKeys { get; }
- public bool AutoClose { get; set; }
- public bool AutoCreateStatisticsEnabled { get; set; }
- public bool AutoShrink { get; set; }
- public bool AutoUpdateStatisticsAsync { get; set; }
- public bool AutoUpdateStatisticsEnabled { get; set; }
- public AvailabilityDatabaseSynchronizationState AvailabilityDatabaseSynchronizationState { get; }
- public string AvailabilityGroupName { get; }
- public bool BrokerEnabled { get; set; }
- public bool CaseSensitive { get; }
- public CertificateCollection Certificates { get; }
- public bool ChangeTrackingAutoCleanUp { get; set; }
- public bool ChangeTrackingEnabled { get; set; }
- public int ChangeTrackingRetentionPeriod { get; set; }
- public RetentionPeriodUnits ChangeTrackingRetentionPeriodUnits { get; set; }
- public bool CloseCursorsOnCommitEnabled { get; set; }
- public string Collation { get; set; }
- public CompatibilityLevel CompatibilityLevel { get; set; }
- public bool ConcatenateNullYieldsNull { get; set; }
- public ContainmentType ContainmentType { get; set; }
- public DateTime CreateDate { get; }
- public DatabaseAuditSpecificationCollection DatabaseAuditSpecifications { get; }
- public DatabaseEncryptionKey DatabaseEncryptionKey { get; }
- public Guid DatabaseGuid { get; }
- public DatabaseOptions DatabaseOptions { get; }
- public bool DatabaseOwnershipChaining { get; set; }
- public string DatabaseSnapshotBaseName { get; set; }
- public double DataSpaceUsage { get; }
- public bool DateCorrelationOptimization { get; set; }
- public bool DboLogin { get; }
- public string DefaultFileGroup { get; }
- public string DefaultFileStreamFileGroup { get; }
- public string DefaultFullTextCatalog { get; set; }
- public DefaultLanguage DefaultFullTextLanguage { get; }
- public DefaultLanguage DefaultLanguage { get; }
- public DefaultCollection Defaults { get; }
- public string DefaultSchema { get; set; }
- public bool EncryptionEnabled { get; set; }
- public DatabaseEvents Events { get; }
- public ExtendedPropertyCollection ExtendedProperties { get; }
- public ExtendedStoredProcedureCollection ExtendedStoredProcedures { get; }
- public FederationCollection Federations { get; }
- public FileGroupCollection FileGroups { get; }
- public string FilestreamDirectoryName { get; set; }
- public FilestreamNonTransactedAccessType FilestreamNonTransactedAccess { get; set; }
- public FullTextCatalogCollection FullTextCatalogs { get; }
- public FullTextStopListCollection FullTextStopLists { get; }
- public bool HonorBrokerPriority { get; set; }
- public int ID { get; }
- public double IndexSpaceUsage { get; }
- public bool IsAccessible { get; }
- public bool IsDatabaseSnapshot { get; }
- public bool IsDatabaseSnapshotBase { get; }
- public bool IsDbAccessAdmin { get; }
- public bool IsDbBackupOperator { get; }
- public bool IsDbDatareader { get; }
- public bool IsDbDatawriter { get; }
- public bool IsDbDdlAdmin { get; }
- public bool IsDbDenyDatareader { get; }
- public bool IsDbDenyDatawriter { get; }
- public bool IsDbManager { get; }
- public bool IsDbOwner { get; }
- public bool IsDbSecurityAdmin { get; }
- public bool IsFederationMember { get; }
- public bool IsFullTextEnabled { get; set; }
- public bool IsLoginManager { get; }
- public bool IsMailHost { get; }
- public bool IsManagementDataWarehouse { get; }
- public bool IsMirroringEnabled { get; }
- public bool IsParameterizationForced { get; set; }
- public bool IsReadCommittedSnapshotOn { get; set; }
- public bool IsSystemObject { get; }
- public bool IsUpdateable { get; }
- public bool IsVarDecimalStorageFormatEnabled { get; set; }
- public DateTime LastBackupDate { get; }
- public DateTime LastDifferentialBackupDate { get; }
- public DateTime LastLogBackupDate { get; }
- public bool LocalCursorsDefault { get; set; }
- public LogFileCollection LogFiles { get; }
- public LogReuseWaitStatus LogReuseWaitStatus { get; }
- public MasterKey MasterKey { get; }
- public decimal MirroringFailoverLogSequenceNumber { get; }
- public Guid MirroringID { get; }
- public string MirroringPartner { get; set; }
- public string MirroringPartnerInstance { get; }
- public int MirroringRedoQueueMaxSize { get; }
- public int MirroringRoleSequence { get; }
- public MirroringSafetyLevel MirroringSafetyLevel { get; set; }
- public int MirroringSafetySequence { get; }
- public MirroringStatus MirroringStatus { get; }
- public int MirroringTimeout { get; set; }
- public string MirroringWitness { get; set; }
- public MirroringWitnessStatus MirroringWitnessStatus { get; }
- public bool NestedTriggersEnabled { get; set; }
- public bool NumericRoundAbortEnabled { get; set; }
- public string Owner { get; }
- public PageVerify PageVerify { get; set; }
- public Server Parent { get; set; }
- public PartitionFunctionCollection PartitionFunctions { get; }
- public PartitionSchemeCollection PartitionSchemes { get; }
- public PlanGuideCollection PlanGuides { get; }
- public string PrimaryFilePath { get; }
- public bool QuotedIdentifiersEnabled { get; set; }
- public bool ReadOnly { get; set; }
- public Guid RecoveryForkGuid { get; }
- public RecoveryModel RecoveryModel { get; set; }
- public bool RecursiveTriggersEnabled { get; set; }
- public ReplicationOptions ReplicationOptions { get; }
- public DatabaseRoleCollection Roles { get; }
- public RuleCollection Rules { get; }
- public SchemaCollection Schemas { get; }
- public SearchPropertyListCollection SearchPropertyLists { get; }
- public SequenceCollection Sequences { get; }
- public ServiceBroker ServiceBroker { get; }
- public Guid ServiceBrokerGuid { get; }
- public double Size { get; }
- public SnapshotIsolationState SnapshotIsolationState { get; }
- public double SpaceAvailable { get; }
- public DatabaseStatus Status { get; }
- public StoredProcedureCollection StoredProcedures { get; }
- public SymmetricKeyCollection SymmetricKeys { get; }
- public SynonymCollection Synonyms { get; }
- public TableCollection Tables { get; }
- public int TargetRecoveryTime { get; set; }
- public bool TransformNoiseWords { get; set; }
- public DatabaseDdlTriggerCollection Triggers { get; }
- public bool Trustworthy { get; set; }
- public int TwoDigitYearCutoff { get; set; }
- public DatabaseUserAccess UserAccess { get; set; }
- public UserDefinedAggregateCollection UserDefinedAggregates { get; }
- public UserDefinedDataTypeCollection UserDefinedDataTypes { get; }
- public UserDefinedFunctionCollection UserDefinedFunctions { get; }
- public UserDefinedTableTypeCollection UserDefinedTableTypes { get; }
- public UserDefinedTypeCollection UserDefinedTypes { get; }
- public string UserName { get; }
- public UserCollection Users { get; }
- public int Version { get; }
- public ViewCollection Views { get; }
- public XmlSchemaCollectionCollection XmlSchemaCollections { get; }
- public Database()
- public Database(Server server, string name)
- public void Alter()
- public void Alter(TerminationClause terminationClause)
- public void Alter(TimeSpan transactionTerminationTime)
- public void ChangeMirroringState(MirroringOption mirroringOption)
- public StringCollection CheckAllocations(RepairType repairType)
- public StringCollection CheckAllocationsDataOnly()
- public StringCollection CheckCatalog()
- public void CheckIdentityValues()
- public void Checkpoint()
- public StringCollection CheckTables(RepairType repairType)
- public StringCollection CheckTables(RepairType repairType, RepairOptions repairOptions, RepairStructure repairStructure)
- public StringCollection CheckTables(RepairType repairType, RepairStructure repairStructure)
- public StringCollection CheckTables(RepairType repairType, RepairOptions repairOptions)
- public StringCollection CheckTablesDataOnly()
- public StringCollection CheckTablesDataOnly(RepairOptions repairOptions)
- public StringCollection CheckTablesDataOnly(RepairStructure repairStructure)
- public StringCollection CheckTablesDataOnly(RepairOptions repairOptions, RepairStructure repairStructure)
- public void Create(bool forAttach)
- public void Create()
- public void Deny(DatabasePermissionSet permission, string[] granteeNames)
- public void Deny(DatabasePermissionSet permission, string[] granteeNames, bool cascade)
- public void Deny(DatabasePermissionSet permission, string granteeName)
- public void Deny(DatabasePermissionSet permission, string granteeName, bool cascade)
- public void DisableAllPlanGuides()
- public void Drop()
- public void DropAllPlanGuides()
- public void DropBackupHistory()
- public void EnableAllPlanGuides()
- public DataTable EnumBackupSetFiles(int backupSetID)
- public DataTable EnumBackupSetFiles()
- public DataTable EnumBackupSets()
- public DataTable EnumCandidateKeys()
- public DatabasePermissionInfo[] EnumDatabasePermissions()
- public DatabasePermissionInfo[] EnumDatabasePermissions(string granteeName)
- public DatabasePermissionInfo[] EnumDatabasePermissions(DatabasePermissionSet permissions)
- public DatabasePermissionInfo[] EnumDatabasePermissions(string granteeName, DatabasePermissionSet permissions)
- public DataTable EnumLocks(int processId)
- public DataTable EnumLocks()
- public DataTable EnumLoginMappings()
- public UrnCollection EnumMatchingSPs(string description, bool includeSystem)
- public UrnCollection EnumMatchingSPs(string description)
- public ObjectPermissionInfo[] EnumObjectPermissions()
- public ObjectPermissionInfo[] EnumObjectPermissions(string granteeName)
- public ObjectPermissionInfo[] EnumObjectPermissions(ObjectPermissionSet permissions)
- public ObjectPermissionInfo[] EnumObjectPermissions(string granteeName, ObjectPermissionSet permissions)
- public DataTable EnumObjects(DatabaseObjectTypes types, SortOrder order)
- public DataTable EnumObjects()
- public DataTable EnumObjects(DatabaseObjectTypes types)
- public DataTable EnumTransactions()
- public DataTable EnumTransactions(TransactionTypes transactionType)
- public DataTable EnumWindowsGroups()
- public DataTable EnumWindowsGroups(string groupName)
- public void ExecuteNonQuery(string sqlCommand)
- public void ExecuteNonQuery(string sqlCommand, ExecutionTypes executionType)
- public void ExecuteNonQuery(StringCollection sqlCommands)
- public void ExecuteNonQuery(StringCollection sqlCommands, ExecutionTypes executionType)
- public DataSet ExecuteWithResults(StringCollection sqlCommands)
- public DataSet ExecuteWithResults(string sqlCommand)
- public int GetTransactionCount()
- public int GetTransactionCount(TransactionTypes transactionType)
- public void Grant(DatabasePermissionSet permission, string[] granteeNames)
- public void Grant(DatabasePermissionSet permission, string[] granteeNames, bool grantGrant)
- public void Grant(DatabasePermissionSet permission, string[] granteeNames, bool grantGrant, string asRole)
- public void Grant(DatabasePermissionSet permission, string granteeName)
- public void Grant(DatabasePermissionSet permission, string granteeName, bool grantGrant)
- public void Grant(DatabasePermissionSet permission, string granteeName, bool grantGrant, string asRole)
- public bool IsMember(string groupOrRole)
- public void PrefetchObjects()
- public void PrefetchObjects(Type objectType)
- public void PrefetchObjects(Type objectType, ScriptingOptions scriptingOptions)
- public void RecalculateSpaceUsage()
- public void RemoveFullTextCatalogs()
- public void Rename(string newName)
- public void Revoke(DatabasePermissionSet permission, string[] granteeNames)
- public void Revoke(DatabasePermissionSet permission, string[] granteeNames, bool revokeGrant, bool cascade)
- public void Revoke(DatabasePermissionSet permission, string[] granteeNames, bool revokeGrant, bool cascade, string asRole)
- public void Revoke(DatabasePermissionSet permission, string granteeName)
- public void Revoke(DatabasePermissionSet permission, string granteeName, bool revokeGrant, bool cascade)
- public void Revoke(DatabasePermissionSet permission, string granteeName, bool revokeGrant, bool cascade, string asRole)
- public StringCollection Script()
- public StringCollection Script(ScriptingOptions scriptingOptions)
- public void SetDefaultFileGroup(string fileGroupName)
- public void SetDefaultFileStreamFileGroup(string fileGroupName)
- public void SetDefaultFullTextCatalog(string catalog)
- public void SetOffline()
- public void SetOnline()
- public void SetOwner(string loginName)
- public void SetOwner(string loginName, bool overrideIfAlreadyUser)
- public void SetSnapshotIsolation(bool enabled)
- public void Shrink(int percentFreeSpace, ShrinkMethod shrinkMethod)
- public void TruncateLog()
- public void UpdateIndexStatistics()
- public bool ValidateAllPlanGuides()
- public bool ValidateAllPlanGuides(out DataTable errorInfo)
-
public sealed class DatabaseActiveDirectory : SqlSmoObject
-
public class DatabaseAdapter : DatabaseAdapterBase, IDmfAdapter, IDmfFacet
-
public class DatabaseAdapterBase : IRefreshable, IAlterable
-
public sealed class DatabaseAuditSpecification : AuditSpecification, ISfcSupportsDesignMode
-
public sealed class DatabaseAuditSpecificationCollection : SimpleObjectCollectionBase
-
public class DatabaseAuditSpecificationExtender : SmoObjectExtender<DatabaseAuditSpecification>, ISfcValidate
-
public sealed class DatabaseCollection : SimpleObjectCollectionBase
-
public sealed class DatabaseDdlTrigger : DdlTriggerBase, IExtendedProperties, ISfcSupportsDesignMode
-
public sealed class DatabaseDdlTriggerCollection : SimpleObjectCollectionBase
-
public sealed class DatabaseEncryptionKey : SqlSmoObject, ICreatable, IAlterable, IDroppable, IScriptable
-
public class DatabaseEncryptionKeyExtender : SmoObjectExtender<DatabaseEncryptionKey>, ISfcValidate
-
public sealed class DatabaseEvent
-
public class DatabaseEventArgs : SmoEventArgs
-
public class DatabaseEvents
-
public sealed class DatabaseEventSet : EventSetBase
-
public enum DatabaseEventType
-
public class DatabaseFile : NamedSmoObject, IAlterable, IDroppable, IRenamable, IMarkForDrop
-
public sealed class DatabaseFileMappingsDictionary : Dictionary<string, string>
-
public class DatabaseMaintenanceAdapter : DatabaseAdapter, IDatabaseMaintenanceFacet, IDmfFacet
-
public sealed class DatabaseMapping
-
public sealed class DatabaseMirroringPayload : EndpointPayload
-
public enum DatabaseObjectTypes
-
public sealed class DatabaseOptions : SqlSmoObject, IAlterable
-
public class DatabasePerformanceAdapter : DatabaseAdapterBase, IDmfAdapter, IDatabasePerformanceFacet, IDmfFacet
-
public sealed class DatabasePermission
-
public class DatabasePermissionInfo : PermissionInfo
-
public sealed class DatabasePermissionSet : PermissionSetBase
-
public sealed class DatabaseReplicaState : SqlSmoObject
-
public sealed class DatabaseReplicaStateCollection : DatabaseReplicaStateCollectionBase
-
public class DatabaseReplicaStateCollectionBase : SortedListCollectionBase
-
public sealed class DatabaseRole : ScriptNameObjectBase, ISfcSupportsDesignMode, IObjectPermission, ICreatable, IDroppable, IAlterable, IRenamable, IExtendedProperties, IScriptable
- public DateTime CreateDate { get; }
- public DateTime DateLastModified { get; }
- public ExtendedPropertyCollection ExtendedProperties { get; }
- public int ID { get; }
- public bool IsFixedRole { get; }
- public string Owner { get; set; }
- public Database Parent { get; set; }
- public DatabaseRole()
- public DatabaseRole(Database database, string name)
- public void AddMember(string name)
- public void Alter()
- public void Create()
- public void Deny(ObjectPermissionSet permission, string[] granteeNames)
- public void Deny(ObjectPermissionSet permission, string[] granteeNames, bool cascade)
- public void Deny(ObjectPermissionSet permission, string granteeName)
- public void Deny(ObjectPermissionSet permission, string granteeName, bool cascade)
- public void Drop()
- public void DropMember(string name)
- public DataTable EnumAgentProxyAccounts()
- public StringCollection EnumMembers()
- public ObjectPermissionInfo[] EnumObjectPermissions()
- public ObjectPermissionInfo[] EnumObjectPermissions(string granteeName)
- public ObjectPermissionInfo[] EnumObjectPermissions(ObjectPermissionSet permissions)
- public ObjectPermissionInfo[] EnumObjectPermissions(string granteeName, ObjectPermissionSet permissions)
- public StringCollection EnumRoles()
- public void Grant(ObjectPermissionSet permission, string[] granteeNames)
- public void Grant(ObjectPermissionSet permission, string[] granteeNames, bool grantGrant)
- public void Grant(ObjectPermissionSet permission, string[] granteeNames, bool grantGrant, string asRole)
- public void Grant(ObjectPermissionSet permission, string granteeName)
- public void Grant(ObjectPermissionSet permission, string granteeName, bool grantGrant)
- public void Grant(ObjectPermissionSet permission, string granteeName, bool grantGrant, string asRole)
- public void Rename(string newname)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames, bool revokeGrant, bool cascade)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames, bool revokeGrant, bool cascade, string asRole)
- public void Revoke(ObjectPermissionSet permission, string granteeName)
- public void Revoke(ObjectPermissionSet permission, string granteeName, bool revokeGrant, bool cascade)
- public void Revoke(ObjectPermissionSet permission, string granteeName, bool revokeGrant, bool cascade, string asRole)
- public StringCollection Script()
- public StringCollection Script(ScriptingOptions scriptingOptions)
-
public sealed class DatabaseRoleCollection : SimpleObjectCollectionBase
-
public class DatabaseSecurityAdapter : DatabaseAdapter, IDatabaseSecurityFacet, IDmfFacet
-
public class DatabaseSnapshotExtender : SmoObjectExtender<Database>, ISfcValidate
-
public sealed class DataFile : DatabaseFile, ICreatable, ISfcSupportsDesignMode
-
public sealed class DataFileCollection : SimpleObjectCollectionBase
-
public class DataType : IXmlSerializable
- public static DataType BigInt { get; }
- public static DataType Bit { get; }
- public static DataType Date { get; }
- public static DataType DateTime { get; }
- public static DataType Float { get; }
- public static DataType Geography { get; }
- public static DataType Geometry { get; }
- public static DataType HierarchyId { get; }
- public static DataType Image { get; }
- public static DataType Int { get; }
- public static DataType Money { get; }
- public static DataType NText { get; }
- public static DataType NVarCharMax { get; }
- public static DataType Real { get; }
- public static DataType SmallDateTime { get; }
- public static DataType SmallInt { get; }
- public static DataType SmallMoney { get; }
- public static DataType SysName { get; }
- public static DataType Text { get; }
- public static DataType Timestamp { get; }
- public static DataType TinyInt { get; }
- public static DataType UniqueIdentifier { get; }
- public static DataType VarBinaryMax { get; }
- public static DataType VarCharMax { get; }
- public static DataType Variant { get; }
- public int MaximumLength { get; set; }
- public string Name { get; set; }
- public int NumericPrecision { get; set; }
- public int NumericScale { get; set; }
- public string Schema { get; set; }
- public SqlDataType SqlDataType { get; set; }
- public XmlDocumentConstraint XmlDocumentConstraint { get; set; }
- public DataType()
- public DataType(SqlDataType sqlDataType)
- public DataType(SqlDataType sqlDataType, int precisionOrMaxLengthOrScale)
- public DataType(SqlDataType sqlDataType, int precision, int scale)
- public DataType(SqlDataType sqlDataType, string type)
- public DataType(SqlDataType sqlDataType, string type, string schema)
- public DataType(XmlSchemaCollection xmlSchemaCollection)
- public DataType(UserDefinedDataType userDefinedDataType)
- public DataType(UserDefinedTableType userDefinedTableType)
- public DataType(UserDefinedType userDefinedType)
- public static DataType Binary(int maxLength)
- public static DataType Char(int maxLength)
- public static DataType DateTime2(int scale)
- public static DataType DateTimeOffset(int scale)
- public static DataType Decimal(int scale, int precision)
- public static DataType NChar(int maxLength)
- public static DataType Numeric(int scale, int precision)
- public static DataType NVarChar(int maxLength)
- public static DataType Time(int scale)
- public static DataType UserDefinedDataType(string type, string schema)
- public static DataType UserDefinedDataType(string type)
- public static DataType UserDefinedTableType(string type, string schema)
- public static DataType UserDefinedTableType(string type)
- public static DataType UserDefinedType(string type, string schema)
- public static DataType UserDefinedType(string type)
- public static DataType VarBinary(int maxLength)
- public static DataType VarChar(int maxLength)
- public static DataType Xml(string type)
- public static DataType Xml(string type, string schema)
- public static DataType Xml(string type, string schema, XmlDocumentConstraint xmlDocumentConstraint)
- public bool Equals(DataType dt)
-
public abstract class DdlTriggerBase : ScriptNameObjectBase, ICreatable, IAlterable, IDroppable, IScriptable, ITextObject
-
public sealed class Default : DefaultRuleBase, ISfcSupportsDesignMode
-
public sealed class DefaultCollection : SchemaCollectionBase
-
public sealed class DefaultConstraint : ScriptNameObjectBase, ICreatable, IDroppable, IRenamable, IAlterable, IExtendedProperties, IScriptable, ISfcSupportsDesignMode
-
public class DefaultLanguage
- public int Lcid { get; set; }
- public string Name { get; set; }
-
public class DefaultRuleBase : ScriptSchemaObjectBase, ICreatable, IDroppable, IAlterable, IExtendedProperties, IScriptable, ITextObject
-
public class DependencyCollection : IList<DependencyCollectionNode>, ICollection<DependencyCollectionNode>, IEnumerable<DependencyCollectionNode>, IEnumerable
-
public class DependencyCollectionNode : DependencyNode
-
public class DependencyNode
-
public class DependencyTree : DependencyTreeNode
-
public class DependencyTreeNode : DependencyNode
-
public enum DependencyType
-
public class DependencyWalker
-
public enum DeviceType
-
public enum Edition
-
public sealed class Endpoint : ScriptNameObjectBase, ICreatable, IAlterable, IDroppable, IScriptable, IObjectPermission
- public EndpointState EndpointState { get; }
- public EndpointType EndpointType { get; set; }
- public int ID { get; }
- public bool IsAdminEndpoint { get; }
- public bool IsSystemObject { get; }
- public string Owner { get; set; }
- public Server Parent { get; set; }
- public Payload Payload { get; }
- public Protocol Protocol { get; }
- public ProtocolType ProtocolType { get; set; }
- public Endpoint()
- public Endpoint(Server server, string name)
- public void Alter()
- public void Create()
- public void Deny(ObjectPermissionSet permission, string[] granteeNames)
- public void Deny(ObjectPermissionSet permission, string[] granteeNames, bool cascade)
- public void Deny(ObjectPermissionSet permission, string granteeName)
- public void Deny(ObjectPermissionSet permission, string granteeName, bool cascade)
- public void Disable()
- public void Drop()
- public ObjectPermissionInfo[] EnumObjectPermissions()
- public ObjectPermissionInfo[] EnumObjectPermissions(string granteeName)
- public ObjectPermissionInfo[] EnumObjectPermissions(ObjectPermissionSet permissions)
- public ObjectPermissionInfo[] EnumObjectPermissions(string granteeName, ObjectPermissionSet permissions)
- public void Grant(ObjectPermissionSet permission, string[] granteeNames)
- public void Grant(ObjectPermissionSet permission, string[] granteeNames, bool grantGrant)
- public void Grant(ObjectPermissionSet permission, string[] granteeNames, bool grantGrant, string asRole)
- public void Grant(ObjectPermissionSet permission, string granteeName)
- public void Grant(ObjectPermissionSet permission, string granteeName, bool grantGrant)
- public void Grant(ObjectPermissionSet permission, string granteeName, bool grantGrant, string asRole)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames, bool revokeGrant, bool cascade)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames, bool revokeGrant, bool cascade, string asRole)
- public void Revoke(ObjectPermissionSet permission, string granteeName)
- public void Revoke(ObjectPermissionSet permission, string granteeName, bool revokeGrant, bool cascade)
- public void Revoke(ObjectPermissionSet permission, string granteeName, bool revokeGrant, bool cascade, string asRole)
- public StringCollection Script()
- public StringCollection Script(ScriptingOptions scriptingOptions)
- public void Start()
- public void Stop()
-
public sealed class EndpointCollection : SimpleObjectCollectionBase
-
public abstract class EndpointPayload : SqlSmoObject
-
public abstract class EndpointProtocol : SqlSmoObject
-
public sealed class EventProperty
- public string Name { get; }
- public object Value { get; }
-
public sealed class EventPropertyCollection : ICollection, IEnumerable<EventProperty>, IEnumerable
-
public enum EventType
-
public enum ExecutionStatus
-
public sealed class ExtendedProperty : ScriptNameObjectBase, ICreatable, IAlterable, IDroppable, IMarkForDrop, IScriptable
-
public sealed class ExtendedPropertyCollection : SimpleObjectCollectionBase
-
public sealed class ExtendedStoredProcedure : ScriptSchemaObjectBase, IObjectPermission, ICreatable, IAlterable, IDroppable, IExtendedProperties
- public DateTime CreateDate { get; }
- public DateTime DateLastModified { get; }
- public string DllLocation { get; set; }
- public ExtendedPropertyCollection ExtendedProperties { get; }
- public int ID { get; }
- public bool IsSchemaOwned { get; }
- public bool IsSystemObject { get; }
- public string Owner { get; set; }
- public Database Parent { get; set; }
- public ExtendedStoredProcedure()
- public ExtendedStoredProcedure(Database database, string name)
- public ExtendedStoredProcedure(Database database, string name, string schema)
- public void Alter()
- public void ChangeSchema(string newSchema)
- public void Create()
- public void Deny(ObjectPermissionSet permission, string[] granteeNames)
- public void Deny(ObjectPermissionSet permission, string[] granteeNames, bool cascade)
- public void Deny(ObjectPermissionSet permission, string granteeName)
- public void Deny(ObjectPermissionSet permission, string granteeName, bool cascade)
- public void Drop()
- public ObjectPermissionInfo[] EnumObjectPermissions()
- public ObjectPermissionInfo[] EnumObjectPermissions(string granteeName)
- public ObjectPermissionInfo[] EnumObjectPermissions(ObjectPermissionSet permissions)
- public ObjectPermissionInfo[] EnumObjectPermissions(string granteeName, ObjectPermissionSet permissions)
- public void Grant(ObjectPermissionSet permission, string[] granteeNames)
- public void Grant(ObjectPermissionSet permission, string[] granteeNames, bool grantGrant)
- public void Grant(ObjectPermissionSet permission, string[] granteeNames, bool grantGrant, string asRole)
- public void Grant(ObjectPermissionSet permission, string granteeName)
- public void Grant(ObjectPermissionSet permission, string granteeName, bool grantGrant)
- public void Grant(ObjectPermissionSet permission, string granteeName, bool grantGrant, string asRole)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames, bool revokeGrant, bool cascade)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames, bool revokeGrant, bool cascade, string asRole)
- public void Revoke(ObjectPermissionSet permission, string granteeName)
- public void Revoke(ObjectPermissionSet permission, string granteeName, bool revokeGrant, bool cascade)
- public void Revoke(ObjectPermissionSet permission, string granteeName, bool revokeGrant, bool cascade, string asRole)
-
public sealed class ExtendedStoredProcedureCollection : SchemaCollectionBase
-
public sealed class FailedOperationException : SmoException
-
public sealed class Federation : ScriptNameObjectBase, IDroppable, IAlterable, ICreatable, IScriptable
-
public sealed class FederationCollection : SimpleObjectCollectionBase
-
public sealed class FileGroup : NamedSmoObject, ICreatable, IAlterable, IDroppable, IRenamable, IMarkForDrop, ISfcSupportsDesignMode
-
public sealed class FileGroupCollection : SimpleObjectCollectionBase
-
public enum FilestreamAccessLevelType
-
public enum FileStreamEffectiveLevel
-
public sealed class ForeignKey : ScriptNameObjectBase, ICreatable, IDroppable, IMarkForDrop, IAlterable, IRenamable, IExtendedProperties, IScriptable, ISfcSupportsDesignMode, IPropertyDataDispatch
-
public sealed class ForeignKeyCollection : SimpleObjectCollectionBase
-
public sealed class ForeignKeyColumn : NamedSmoObject, ISfcSupportsDesignMode, IPropertyDataDispatch
-
public sealed class ForeignKeyColumnCollection : ParameterCollectionBase
-
public enum FragmentationOption
-
public sealed class FrequencyPair
-
public sealed class FullTextCatalog : ScriptNameObjectBase, ISfcSupportsDesignMode, IObjectPermission, ICreatable, IAlterable, IDroppable, IScriptable
- public int ErrorLogSize { get; }
- public string FileGroup { get; set; }
- public int FullTextIndexSize { get; }
- public bool HasFullTextIndexedTables { get; }
- public int ID { get; }
- public bool IsAccentSensitive { get; set; }
- public bool IsDefault { get; set; }
- public int ItemCount { get; }
- public string Owner { get; set; }
- public Database Parent { get; set; }
- public TimeSpan PopulationCompletionAge { get; }
- public DateTime PopulationCompletionDate { get; }
- public CatalogPopulationStatus PopulationStatus { get; }
- public string RootPath { get; set; }
- public int UniqueKeyCount { get; }
- public FullTextCatalog()
- public FullTextCatalog(Database database, string name)
- public void Alter()
- public void Create()
- public void Deny(ObjectPermissionSet permission, string[] granteeNames)
- public void Deny(ObjectPermissionSet permission, string[] granteeNames, bool cascade)
- public void Deny(ObjectPermissionSet permission, string granteeName)
- public void Deny(ObjectPermissionSet permission, string granteeName, bool cascade)
- public void Drop()
- public DataTable EnumErrorLogs()
- public ObjectPermissionInfo[] EnumObjectPermissions()
- public ObjectPermissionInfo[] EnumObjectPermissions(string granteeName)
- public ObjectPermissionInfo[] EnumObjectPermissions(ObjectPermissionSet permissions)
- public ObjectPermissionInfo[] EnumObjectPermissions(string granteeName, ObjectPermissionSet permissions)
- public void Grant(ObjectPermissionSet permission, string[] granteeNames)
- public void Grant(ObjectPermissionSet permission, string[] granteeNames, bool grantGrant)
- public void Grant(ObjectPermissionSet permission, string[] granteeNames, bool grantGrant, string asRole)
- public void Grant(ObjectPermissionSet permission, string granteeName)
- public void Grant(ObjectPermissionSet permission, string granteeName, bool grantGrant)
- public void Grant(ObjectPermissionSet permission, string granteeName, bool grantGrant, string asRole)
- public DataTable ReadErrorLog()
- public DataTable ReadErrorLog(int logNumber)
- public void Rebuild()
- public void Rebuild(bool accentSensitive)
- public void Reorganize()
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames, bool revokeGrant, bool cascade)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames, bool revokeGrant, bool cascade, string asRole)
- public void Revoke(ObjectPermissionSet permission, string granteeName)
- public void Revoke(ObjectPermissionSet permission, string granteeName, bool revokeGrant, bool cascade)
- public void Revoke(ObjectPermissionSet permission, string granteeName, bool revokeGrant, bool cascade, string asRole)
- public StringCollection Script()
- public StringCollection Script(ScriptingOptions scriptingOptions)
- public void StartPopulation(CatalogPopulationAction action)
- public void StopPopulation()
-
public sealed class FullTextCatalogCollection : SimpleObjectCollectionBase
-
public sealed class FullTextIndex : SqlSmoObject, ISfcSupportsDesignMode, ICreatable, IAlterable, IDroppable, IScriptable
-
public sealed class FullTextIndexColumn : ScriptNameObjectBase, IAlterable, ICreatable, IDroppable, IScriptable
-
public sealed class FullTextIndexColumnCollection : SimpleObjectCollectionBase
-
public sealed class FullTextService : ScriptNameObjectBase, IAlterable, IScriptable
-
public sealed class FullTextStopList : ScriptNameObjectBase, ISfcSupportsDesignMode, IObjectPermission, ICreatable, IDroppable, IScriptable
- public int ID { get; }
- public string Owner { get; set; }
- public Database Parent { get; set; }
- public FullTextStopList()
- public FullTextStopList(Database database, string name)
- public void AddStopWord(string stopword, string language)
- public void Create()
- public void CreateFromExistingStopList(string stoplistName)
- public void CreateFromExistingStopList(string dbName, string stoplistName)
- public void CreateFromSystemStopList()
- public void Deny(ObjectPermissionSet permission, string[] granteeNames)
- public void Deny(ObjectPermissionSet permission, string[] granteeNames, bool cascade)
- public void Deny(ObjectPermissionSet permission, string granteeName)
- public void Deny(ObjectPermissionSet permission, string granteeName, bool cascade)
- public void Drop()
- public ObjectPermissionInfo[] EnumObjectPermissions()
- public ObjectPermissionInfo[] EnumObjectPermissions(string granteeName)
- public ObjectPermissionInfo[] EnumObjectPermissions(ObjectPermissionSet permissions)
- public ObjectPermissionInfo[] EnumObjectPermissions(string granteeName, ObjectPermissionSet permissions)
- public DataTable EnumStopWords()
- public void Grant(ObjectPermissionSet permission, string[] granteeNames)
- public void Grant(ObjectPermissionSet permission, string[] granteeNames, bool grantGrant)
- public void Grant(ObjectPermissionSet permission, string[] granteeNames, bool grantGrant, string asRole)
- public void Grant(ObjectPermissionSet permission, string granteeName)
- public void Grant(ObjectPermissionSet permission, string granteeName, bool grantGrant)
- public void Grant(ObjectPermissionSet permission, string granteeName, bool grantGrant, string asRole)
- public bool HasStopWord(string stopword, string language)
- public void RemoveAllStopWords()
- public void RemoveAllStopWords(string language)
- public void RemoveStopWord(string stopword, string language)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames, bool revokeGrant, bool cascade)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames, bool revokeGrant, bool cascade, string asRole)
- public void Revoke(ObjectPermissionSet permission, string granteeName)
- public void Revoke(ObjectPermissionSet permission, string granteeName, bool revokeGrant, bool cascade)
- public void Revoke(ObjectPermissionSet permission, string granteeName, bool revokeGrant, bool cascade, string asRole)
- public StringCollection Script()
- public StringCollection Script(ScriptingOptions scriptingOptions)
-
public sealed class FullTextStopListCollection : SimpleObjectCollectionBase
-
public sealed class HttpProtocol : EndpointProtocol
-
public interface IAvailabilityGroupState : IDmfFacet, IRefreshable
-
public interface IColumnPermission : IObjectPermission
- void Deny(ObjectPermissionSet permissions, string[] granteeNames, string[] columnNames)
- void Deny(ObjectPermissionSet permissions, string granteeName, string[] columnNames)
- void Deny(ObjectPermissionSet permissions, string[] granteeNames, string[] columnNames, bool cascade)
- void Deny(ObjectPermissionSet permissions, string granteeName, string[] columnNames, bool cascade)
- ObjectPermissionInfo[] EnumColumnPermissions(string granteeName)
- ObjectPermissionInfo[] EnumColumnPermissions(string granteeName, ObjectPermissionSet permissions)
- void Grant(ObjectPermissionSet permissions, string[] granteeNames, string[] columnNames)
- void Grant(ObjectPermissionSet permissions, string granteeName, string[] columnNames)
- void Grant(ObjectPermissionSet permissions, string[] granteeNames, string[] columnNames, bool grantGrant)
- void Grant(ObjectPermissionSet permissions, string granteeName, string[] columnNames, bool grantGrant)
- void Grant(ObjectPermissionSet permissions, string[] granteeNames, string[] columnNames, bool grantGrant, string asRole)
- void Grant(ObjectPermissionSet permissions, string granteeName, string[] columnNames, bool grantGrant, string asRole)
- void Revoke(ObjectPermissionSet permissions, string[] granteeNames, string[] columnNames)
- void Revoke(ObjectPermissionSet permissions, string granteeName, string[] columnNames)
- void Revoke(ObjectPermissionSet permissions, string[] granteeNames, string[] columnNames, bool revokeGrant, bool cascade)
- void Revoke(ObjectPermissionSet permissions, string granteeName, string[] columnNames, bool revokeGrant, bool cascade)
- void Revoke(ObjectPermissionSet permissions, string[] granteeNames, string[] columnNames, bool revokeGrant, bool cascade, string asRole)
- void Revoke(ObjectPermissionSet permissions, string granteeName, string[] columnNames, bool revokeGrant, bool cascade, string asRole)
-
public interface IDatabaseMaintenanceFacet : IDmfFacet
-
public interface IDatabaseOptions : IDmfFacet
-
public interface IDatabasePerformanceFacet : IDmfFacet
-
public interface IDatabaseSecurityFacet : IDmfFacet
-
public interface IExtendedProperties
-
public interface ILoginOptions : IDmfFacet
-
public interface IMultipartNameFacet : IDmfFacet
-
public interface INameFacet : IDmfFacet
-
public sealed class Index : ScriptNameObjectBase, ICreatable, IDroppable, IMarkForDrop, IAlterable, IRenamable, IExtendedProperties, IScriptable, ISfcSupportsDesignMode, IPropertyDataDispatch
-
public sealed class IndexCollection : SimpleObjectCollectionBase
-
public sealed class IndexedColumn : NamedSmoObject, ISfcSupportsDesignMode, IPropertyDataDispatch
-
public sealed class IndexedColumnCollection : ParameterCollectionBase
-
public sealed class IndexedXmlPath : NamedSmoObject, ISfcSupportsDesignMode, IPropertyDataDispatch, IMarkForDrop
-
public sealed class IndexedXmlPathCollection : ParameterCollectionBase
-
public sealed class IndexedXmlPathNamespace : NamedSmoObject, ISfcSupportsDesignMode, IPropertyDataDispatch
-
public sealed class IndexedXmlPathNamespaceCollection : SimpleObjectCollectionBase
-
public enum IndexEnableAction
-
public class IndexEvents
-
public enum IndexOperation
-
public enum InDoubtTransactionResolutionType
-
public sealed class Information : SqlSmoObject
-
public enum InstanceState
-
public sealed class InternalSmoErrorException : SmoException
-
public sealed class InvalidScriptingOptionException : SmoException
-
public sealed class InvalidSmoOperationException : SmoException
-
public sealed class InvalidVersionSmoOperationException : SmoException
-
public interface IObjectPermission
- void Deny(ObjectPermissionSet permissions, string[] granteeNames)
- void Deny(ObjectPermissionSet permissions, string granteeName)
- void Deny(ObjectPermissionSet permissions, string[] granteeNames, bool cascade)
- void Deny(ObjectPermissionSet permissions, string granteeName, bool cascade)
- ObjectPermissionInfo[] EnumObjectPermissions()
- ObjectPermissionInfo[] EnumObjectPermissions(string granteeName)
- ObjectPermissionInfo[] EnumObjectPermissions(ObjectPermissionSet permissions)
- ObjectPermissionInfo[] EnumObjectPermissions(string granteeName, ObjectPermissionSet permissions)
- void Grant(ObjectPermissionSet permissions, string[] granteeNames)
- void Grant(ObjectPermissionSet permissions, string granteeName)
- void Grant(ObjectPermissionSet permissions, string[] granteeNames, bool grantGrant)
- void Grant(ObjectPermissionSet permissions, string granteeName, bool grantGrant)
- void Grant(ObjectPermissionSet permissions, string[] granteeNames, bool grantGrant, string asRole)
- void Grant(ObjectPermissionSet permissions, string granteeName, bool grantGrant, string asRole)
- void Revoke(ObjectPermissionSet permissions, string[] granteeNames)
- void Revoke(ObjectPermissionSet permissions, string granteeName)
- void Revoke(ObjectPermissionSet permissions, string[] granteeNames, bool revokeGrant, bool cascade)
- void Revoke(ObjectPermissionSet permissions, string granteeName, bool revokeGrant, bool cascade, string asRole)
-
public interface IScriptable
-
public interface IServerAuditFacet : IDmfFacet
-
public interface IServerConfigurationFacet : IDmfFacet
-
public interface IServerInformation : IDmfFacet
-
public interface IServerPerformanceFacet : IDmfFacet
-
public interface IServerSecurityFacet : IDmfFacet
-
public interface IServerSelectionFacet : IDmfFacet
-
public interface IServerSettings : IDmfFacet
-
public interface IServerSetupFacet : IDmfFacet
-
public interface ISurfaceAreaFacet : IDmfFacet
-
public interface ITableOptions : IDmfFacet
-
public interface ITextObject
- string TextBody { get; set; }
- string { get; set; }
- bool TextMode { get; set; }
- string (bool forAlter)
-
public interface IUserOptions : IDmfFacet
-
public interface IViewOptions : IDmfFacet
-
public class JobScheduleCollectionBase : ArrayListCollectionBase
-
public enum KeyEncryptionType
-
public sealed class Language : NamedSmoObject
-
public sealed class LanguageCollection : SimpleObjectCollectionBase
-
public sealed class LinkedServer : NamedSmoObject, ISfcSupportsDesignMode, ICreatable, IDroppable, IAlterable, IScriptable
- public string Catalog { get; set; }
- public bool CollationCompatible { get; set; }
- public string CollationName { get; set; }
- public int ConnectTimeout { get; set; }
- public bool DataAccess { get; set; }
- public string DataSource { get; set; }
- public DateTime DateLastModified { get; }
- public bool DistPublisher { get; set; }
- public bool Distributor { get; set; }
- public int ID { get; }
- public bool IsPromotionofDistributedTransactionsForRPCEnabled { get; set; }
- public bool LazySchemaValidation { get; set; }
- public LinkedServerLoginCollection LinkedServerLogins { get; }
- public string Location { get; set; }
- public Server Parent { get; set; }
- public string ProductName { get; set; }
- public string ProviderName { get; set; }
- public string ProviderString { get; set; }
- public bool Publisher { get; set; }
- public int QueryTimeout { get; set; }
- public bool Rpc { get; set; }
- public bool RpcOut { get; set; }
- public bool Subscriber { get; set; }
- public bool UseRemoteCollation { get; set; }
- public LinkedServer()
- public LinkedServer(Server server, string name)
- public void Alter()
- public void Create()
- public void Drop()
- public void Drop(bool dropDependentLogins)
- public DataTable EnumColumns()
- public DataTable EnumColumns(string tableName)
- public DataTable EnumColumns(string tableName, string schemaName)
- public DataTable EnumColumns(string tableName, string schemaName, string databaseName)
- public DataTable EnumColumns(string tableName, string schemaName, string databaseName, string columnName)
- public DataTable EnumTables()
- public DataTable EnumTables(string tableName)
- public DataTable EnumTables(string tableName, string schemaName)
- public DataTable EnumTables(string tableName, string schemaName, string databaseName)
- public DataTable EnumTables(string tableName, string schemaName, string databaseName, LinkedTableType tableType)
- public StringCollection Script()
- public StringCollection Script(ScriptingOptions scriptingOptions)
- public void TestConnection()
-
public sealed class LinkedServerCollection : SimpleObjectCollectionBase
-
public sealed class LinkedServerLogin : NamedSmoObject, ISfcSupportsDesignMode, ICreatable, IDroppable, IAlterable
-
public sealed class LinkedServerLoginCollection : SimpleObjectCollectionBase
-
public enum LinkedTableType
-
public sealed class LogFile : DatabaseFile, ICreatable, ISfcSupportsDesignMode
-
public sealed class LogFileCollection : SimpleObjectCollectionBase
-
public sealed class Login : ScriptNameObjectBase, ISfcSupportsDesignMode, IObjectPermission, ICreatable, IAlterable, IDroppable, IRenamable, IScriptable, ILoginOptions, IDmfFacet
- public string AsymmetricKey { get; set; }
- public string Certificate { get; set; }
- public DateTime CreateDate { get; }
- public string Credential { get; set; }
- public DateTime DateLastModified { get; }
- public string DefaultDatabase { get; set; }
- public bool DenyWindowsLogin { get; set; }
- public LoginEvents Events { get; }
- public bool HasAccess { get; }
- public int ID { get; }
- public bool IsDisabled { get; }
- public bool IsLocked { get; }
- public bool IsPasswordExpired { get; }
- public bool IsSystemObject { get; }
- public string Language { get; set; }
- public string LanguageAlias { get; }
- public LoginType LoginType { get; set; }
- public bool MustChangePassword { get; }
- public Server Parent { get; set; }
- public bool PasswordExpirationEnabled { get; set; }
- public PasswordHashAlgorithm PasswordHashAlgorithm { get; }
- public bool PasswordPolicyEnforced { get; set; }
- public byte[] Sid { get; set; }
- public WindowsLoginAccessType WindowsLoginAccessType { get; }
- public Login()
- public Login(Server server, string name)
- public void AddCredential(string credentialName)
- public void AddToRole(string role)
- public void Alter()
- public void ChangePassword(string newPassword)
- public void ChangePassword(string oldPassword, string newPassword)
- public void ChangePassword(string newPassword, bool unlock, bool mustChange)
- public void Create()
- public void Create(string password)
- public void Create(SecureString password)
- public void Create(string password, LoginCreateOptions options)
- public void Create(SecureString password, LoginCreateOptions options)
- public void Deny(ObjectPermissionSet permission, string[] granteeNames)
- public void Deny(ObjectPermissionSet permission, string[] granteeNames, bool cascade)
- public void Deny(ObjectPermissionSet permission, string granteeName)
- public void Deny(ObjectPermissionSet permission, string granteeName, bool cascade)
- public void Disable()
- public void Drop()
- public void DropCredential(string credentialName)
- public void Enable()
- public DataTable EnumAgentProxyAccounts()
- public StringCollection EnumCredentials()
- public DatabaseMapping[] EnumDatabaseMappings()
- public ObjectPermissionInfo[] EnumObjectPermissions()
- public ObjectPermissionInfo[] EnumObjectPermissions(string granteeName)
- public ObjectPermissionInfo[] EnumObjectPermissions(ObjectPermissionSet permissions)
- public ObjectPermissionInfo[] EnumObjectPermissions(string granteeName, ObjectPermissionSet permissions)
- public string GetDatabaseUser(string databaseName)
- public void Grant(ObjectPermissionSet permission, string[] granteeNames)
- public void Grant(ObjectPermissionSet permission, string[] granteeNames, bool grantGrant)
- public void Grant(ObjectPermissionSet permission, string[] granteeNames, bool grantGrant, string asRole)
- public void Grant(ObjectPermissionSet permission, string granteeName)
- public void Grant(ObjectPermissionSet permission, string granteeName, bool grantGrant)
- public void Grant(ObjectPermissionSet permission, string granteeName, bool grantGrant, string asRole)
- public bool IsMember(string role)
- public StringCollection ListMembers()
- public void Rename(string newname)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames, bool revokeGrant, bool cascade)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames, bool revokeGrant, bool cascade, string asRole)
- public void Revoke(ObjectPermissionSet permission, string granteeName)
- public void Revoke(ObjectPermissionSet permission, string granteeName, bool revokeGrant, bool cascade)
- public void Revoke(ObjectPermissionSet permission, string granteeName, bool revokeGrant, bool cascade, string asRole)
- public StringCollection Script()
- public StringCollection Script(ScriptingOptions scriptingOptions)
-
public sealed class LoginCollection : SimpleObjectCollectionBase
-
public enum LoginCreateOptions
-
public class LoginEvents
-
public sealed class MasterKey : SqlSmoObject, ISfcSupportsDesignMode, IDroppable
-
public class MessageCollectionBase : SortedListCollectionBase
- public bool Contains(int id, string language)
- public bool Contains(int id, int languageId)
- public void Remove(int id)
- public void Remove(int id, string language)
-
public class MessageObjectBase : SqlSmoObject
-
public sealed class MissingObjectException : SmoException
-
public enum Month
-
public class NamedSmoObject : SqlSmoObject
-
public sealed class NumaNode
-
public enum NumaNodeAffinity
-
public sealed class NumaNodeCollection : ICollection, IEnumerable
-
public abstract class NumberedObjectCollectionBase : SortedListCollectionBase
-
public sealed class NumberedStoredProcedure : ScriptNameObjectBase, ISfcSupportsDesignMode, ICreatable, IAlterable, ITextObject
-
public sealed class NumberedStoredProcedureCollection : NumberedObjectCollectionBase
-
public sealed class NumberedStoredProcedureParameter : Parameter, ISfcSupportsDesignMode
-
public sealed class NumberedStoredProcedureParameterCollection : ParameterCollectionBase
-
public class ObjectAlteredEventArgs : SmoEventArgs
-
public class ObjectCreatedEventArgs : SmoEventArgs
-
public class ObjectDroppedEventArgs : SmoEventArgs
-
public sealed class ObjectEvent
-
public sealed class ObjectEventSet : EventSetBase
-
public sealed class ObjectPermission
-
public class ObjectPermissionInfo : PermissionInfo
-
public sealed class ObjectPermissionSet : PermissionSetBase
-
public class ObjectRenamedEventArgs : SmoEventArgs
-
public sealed class OleDbProviderSettings : NamedSmoObject, IAlterable, IScriptable
-
public class OleDbProviderSettingsCollection : SimpleObjectCollectionBase
-
public sealed class OrderColumn : NamedSmoObject, IPropertyDataDispatch
-
public sealed class OrderColumnCollection : ParameterCollectionBase
-
public class Parameter : ParameterBase, ISfcSupportsDesignMode
-
public class ParameterBase : ScriptNameObjectBase, IExtendedProperties, IMarkForDrop
-
public abstract class ParameterCollectionBase : ArrayListCollectionBase
-
public sealed class PartitionFunction : ScriptNameObjectBase, ISfcSupportsDesignMode, IDroppable, IAlterable, ICreatable, IScriptable, IExtendedProperties
-
public sealed class PartitionFunctionCollection : SimpleObjectCollectionBase
-
public class PartitionFunctionEvents
-
public sealed class PartitionFunctionParameter : ScriptNameObjectBase, ISfcSupportsDesignMode
-
public sealed class PartitionFunctionParameterCollection : ParameterCollectionBase
-
public abstract class PartitionNumberedObjectCollectionBase : SortedListCollectionBase
-
public sealed class PartitionScheme : ScriptNameObjectBase, ISfcSupportsDesignMode, IDroppable, IAlterable, ICreatable, IScriptable
-
public sealed class PartitionSchemeCollection : SimpleObjectCollectionBase
-
public class PartitionSchemeEvents
-
public sealed class PartitionSchemeParameter : ScriptNameObjectBase, ISfcSupportsDesignMode
-
public sealed class PartitionSchemeParameterCollection : ParameterCollectionBase
-
public class Payload
-
public sealed class PerformanceCounters
-
public class PermissionInfo
-
public abstract class PermissionSetBase
-
public sealed class PhysicalPartition : SqlSmoObject, IPropertyDataDispatch
-
public sealed class PhysicalPartitionCollection : PartitionNumberedObjectCollectionBase
-
public sealed class PlanGuide : NamedSmoObject, ICreatable, IAlterable, IDroppable, IScriptable, IExtendedProperties
-
public sealed class PlanGuideCollection : SimpleObjectCollectionBase
-
public class PlanGuideExtender : SmoObjectExtender<PlanGuide>, ISfcValidate
-
public enum PrivilegeTypes
-
public class ProgressReportEventArgs : EventArgs
- public Urn Current { get; }
- public bool IsSchemaBound { get; }
- public Urn Parent { get; }
- public int SubTotal { get; }
- public int SubTotalCount { get; }
- public int Total { get; }
- public int TotalCount { get; }
- public ProgressReportEventArgs(Urn current, Urn parent, int subTotalCount, int subTotal, int totalCount, int total)
- public ProgressReportEventArgs(Urn current, Urn parent, bool isSchemaBound, int subTotalCount, int subTotal, int totalCount, int total)
-
public sealed delegate ProgressReportEventHandler : MulticastDelegate
-
public class Property : ISfcProperty
-
public sealed class PropertyCannotBeRetrievedException : SmoException
-
public class PropertyCollection : ICollection, IEnumerable, ISfcPropertySet
-
public sealed class PropertyNotSetException : SmoException
-
public sealed class PropertyReadOnlyException : SmoException
-
public sealed class PropertyTypeMismatchException : SmoException
-
public sealed class PropertyWriteException : SmoException
-
public class Protocol
-
public enum RepairType
-
public sealed class ResourceGovernor : SqlSmoObject, ISfcSupportsDesignMode, IAlterable, IScriptable
-
public sealed class ResourcePool : ScriptNameObjectBase, ISfcSupportsDesignMode, ICreatable, IDroppable, IAlterable, IScriptable
-
public sealed class ResourcePoolAffinityInfo : AffinityInfoBase
-
public sealed class ResourcePoolCollection : SimpleObjectCollectionBase
-
public enum RoleTypes
-
public sealed class Rule : DefaultRuleBase, ISfcSupportsDesignMode
-
public sealed class RuleCollection : SchemaCollectionBase
-
public sealed class Scheduler
-
public sealed class SchedulerCollection : ICollection, IEnumerable
-
public sealed class Schema : ScriptNameObjectBase, ISfcSupportsDesignMode, IObjectPermission, ICreatable, IDroppable, IExtendedProperties, IScriptable, IAlterable
- public SchemaEvents Events { get; }
- public ExtendedPropertyCollection ExtendedProperties { get; }
- public int ID { get; }
- public bool IsSystemObject { get; }
- public string Owner { get; set; }
- public Database Parent { get; set; }
- public Schema()
- public Schema(Database database, string name)
- public void Alter()
- public void Create()
- public void Deny(ObjectPermissionSet permission, string[] granteeNames)
- public void Deny(ObjectPermissionSet permission, string[] granteeNames, bool cascade)
- public void Deny(ObjectPermissionSet permission, string granteeName)
- public void Deny(ObjectPermissionSet permission, string granteeName, bool cascade)
- public void Drop()
- public ObjectPermissionInfo[] EnumObjectPermissions()
- public ObjectPermissionInfo[] EnumObjectPermissions(string granteeName)
- public ObjectPermissionInfo[] EnumObjectPermissions(ObjectPermissionSet permissions)
- public ObjectPermissionInfo[] EnumObjectPermissions(string granteeName, ObjectPermissionSet permissions)
- public Urn[] EnumOwnedObjects()
- public void Grant(ObjectPermissionSet permission, string[] granteeNames)
- public void Grant(ObjectPermissionSet permission, string[] granteeNames, bool grantGrant)
- public void Grant(ObjectPermissionSet permission, string[] granteeNames, bool grantGrant, string asRole)
- public void Grant(ObjectPermissionSet permission, string granteeName)
- public void Grant(ObjectPermissionSet permission, string granteeName, bool grantGrant)
- public void Grant(ObjectPermissionSet permission, string granteeName, bool grantGrant, string asRole)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames, bool revokeGrant, bool cascade)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames, bool revokeGrant, bool cascade, string asRole)
- public void Revoke(ObjectPermissionSet permission, string granteeName)
- public void Revoke(ObjectPermissionSet permission, string granteeName, bool revokeGrant, bool cascade)
- public void Revoke(ObjectPermissionSet permission, string granteeName, bool revokeGrant, bool cascade, string asRole)
- public StringCollection Script()
- public StringCollection Script(ScriptingOptions scriptingOptions)
-
public sealed class SchemaCollection : SimpleObjectCollectionBase
-
public class SchemaCollectionBase : SortedListCollectionBase
- public bool Contains(string name)
- public bool Contains(string name, string schema)
-
public class SchemaCustomResolver
-
public class SchemaEvents
-
public class Scripter : DependencyWalker
-
public class ScriptingErrorEventArgs : EventArgs
-
public sealed delegate ScriptingErrorEventHandler : MulticastDelegate
-
public sealed delegate ScriptingFilter : MulticastDelegate
-
public sealed class ScriptingOptions
-
public class ScriptNameObjectBase : NamedSmoObject
- protected void AppendCommaText(StringBuilder sb, string optionText, ref bool needsComma, string beginWord)
- protected void AppendWithCommaText(StringBuilder sb, string optionText, ref bool needsComma)
- protected void AppendWithOption(StringBuilder sb, string propName, string optionText, ref bool needsComma)
- protected void AutoGenerateName()
- protected virtual bool CheckObjectDirty()
- protected void (string ddlText, bool enforceCreate, bool checkName, string[] expectedObjectTypes, out DdlTextParserHeaderInfo headerInfo)
- protected bool CheckTextModeSupport()
- protected bool ForceTextModeOnTextBody()
- protected virtual string GetBraketNameForText()
- protected bool GetIsSystemNamed()
- protected bool GetIsTextDirty()
- protected string GetTextBody()
- protected string GetTextBody(bool forScripting)
- protected string (bool forAlter)
- protected bool GetTextMode()
- protected string GetTextProperty(string requestingProperty)
- protected void SetCollectionTextMode(bool newTextModeValue, SmoCollectionBase coll)
- protected void SetIsSystemNamed(bool flag)
- protected void SetTextBody(string textBody)
- protected void (string textHeader)
- protected void SetTextMode(bool textMode, SmoCollectionBase[] collList)
- protected void SwitchTextMode(bool newTextModeValue, SmoCollectionBase[] collList)
- protected void ThrowIfTextIsDirtyForAlter()
-
public sealed class ScriptOption
-
public class ScriptSchemaObjectBase : ScriptNameObjectBase
- public virtual string Schema { get; set; }
-
public sealed class ScriptWriterException : SmoException
-
public sealed class SearchProperty : ScriptNameObjectBase, ICreatable, IDroppable, IScriptable
-
public sealed class SearchPropertyCollection : SimpleObjectCollectionBase
-
public sealed class SearchPropertyList : ScriptNameObjectBase, IObjectPermission, ICreatable, IDroppable, IAlterable, IScriptable
- public DateTime DateCreated { get; }
- public DateTime DateLastModified { get; }
- public int ID { get; }
- public string Owner { get; set; }
- public Database Parent { get; set; }
- public SearchPropertyCollection SearchProperties { get; }
- public SearchPropertyList()
- public SearchPropertyList(Database database, string name)
- public void Alter()
- public void Create()
- public void Create(string sourceSearchPropertyListName)
- public void Create(string sourceDatabaseName, string sourceSearchPropertyListName)
- public void Deny(ObjectPermissionSet permission, string[] granteeNames)
- public void Deny(ObjectPermissionSet permission, string[] granteeNames, bool cascade)
- public void Deny(ObjectPermissionSet permission, string granteeName)
- public void Deny(ObjectPermissionSet permission, string granteeName, bool cascade)
- public void Drop()
- public ObjectPermissionInfo[] EnumObjectPermissions()
- public ObjectPermissionInfo[] EnumObjectPermissions(string granteeName)
- public ObjectPermissionInfo[] EnumObjectPermissions(ObjectPermissionSet permissions)
- public ObjectPermissionInfo[] EnumObjectPermissions(string granteeName, ObjectPermissionSet permissions)
- public void Grant(ObjectPermissionSet permission, string[] granteeNames)
- public void Grant(ObjectPermissionSet permission, string[] granteeNames, bool grantGrant)
- public void Grant(ObjectPermissionSet permission, string[] granteeNames, bool grantGrant, string asRole)
- public void Grant(ObjectPermissionSet permission, string granteeName)
- public void Grant(ObjectPermissionSet permission, string granteeName, bool grantGrant)
- public void Grant(ObjectPermissionSet permission, string granteeName, bool grantGrant, string asRole)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames, bool revokeGrant, bool cascade)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames, bool revokeGrant, bool cascade, string asRole)
- public void Revoke(ObjectPermissionSet permission, string granteeName)
- public void Revoke(ObjectPermissionSet permission, string granteeName, bool revokeGrant, bool cascade)
- public void Revoke(ObjectPermissionSet permission, string granteeName, bool revokeGrant, bool cascade, string asRole)
- public StringCollection Script()
- public StringCollection Script(ScriptingOptions scriptingOptions)
-
public sealed class SearchPropertyListCollection : SimpleObjectCollectionBase
-
public sealed class Sequence : ScriptSchemaObjectBase, IObjectPermission, ICreatable, IDroppable, IRenamable, IExtendedProperties, IScriptable, IAlterable
- public int CacheSize { get; set; }
- public DateTime CreateDate { get; }
- public object CurrentValue { get; }
- public DataType DataType { get; set; }
- public DateTime DateLastModified { get; }
- public SequenceEvents Events { get; }
- public ExtendedPropertyCollection ExtendedProperties { get; }
- public int ID { get; }
- public object IncrementValue { get; set; }
- public bool IsCycleEnabled { get; set; }
- public bool IsExhausted { get; }
- public bool IsSchemaOwned { get; }
- public object MaxValue { get; set; }
- public object MinValue { get; set; }
- public string Owner { get; set; }
- public Database Parent { get; set; }
- public SequenceCacheType SequenceCacheType { get; set; }
- public object StartValue { get; set; }
- public Sequence()
- public Sequence(Database database, string name)
- public Sequence(Database database, string name, string schema)
- public void Alter()
- public void Create()
- public void Deny(ObjectPermissionSet permission, string[] granteeNames)
- public void Deny(ObjectPermissionSet permission, string[] granteeNames, bool cascade)
- public void Deny(ObjectPermissionSet permission, string granteeName)
- public void Deny(ObjectPermissionSet permission, string granteeName, bool cascade)
- public void Drop()
- public ObjectPermissionInfo[] EnumObjectPermissions()
- public ObjectPermissionInfo[] EnumObjectPermissions(string granteeName)
- public ObjectPermissionInfo[] EnumObjectPermissions(ObjectPermissionSet permissions)
- public ObjectPermissionInfo[] EnumObjectPermissions(string granteeName, ObjectPermissionSet permissions)
- public void Grant(ObjectPermissionSet permission, string[] granteeNames)
- public void Grant(ObjectPermissionSet permission, string[] granteeNames, bool grantGrant)
- public void Grant(ObjectPermissionSet permission, string[] granteeNames, bool grantGrant, string asRole)
- public void Grant(ObjectPermissionSet permission, string granteeName)
- public void Grant(ObjectPermissionSet permission, string granteeName, bool grantGrant)
- public void Grant(ObjectPermissionSet permission, string granteeName, bool grantGrant, string asRole)
- public void Rename(string newname)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames, bool revokeGrant, bool cascade)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames, bool revokeGrant, bool cascade, string asRole)
- public void Revoke(ObjectPermissionSet permission, string granteeName)
- public void Revoke(ObjectPermissionSet permission, string granteeName, bool revokeGrant, bool cascade)
- public void Revoke(ObjectPermissionSet permission, string granteeName, bool revokeGrant, bool cascade, string asRole)
- public StringCollection Script()
- public StringCollection Script(ScriptingOptions scriptingOptions)
-
public sealed class SequenceCollection : SchemaCollectionBase
-
public class SequenceEvents
-
public class SequenceExtender : SmoObjectExtender<Sequence>, ISfcValidate
-
public sealed class Server : SqlSmoObject, ISfcSupportsDesignMode, IAlterable, IScriptable, IServerSettings, IServerInformation, IDmfFacet, IAlienRoot, ISfcDomainLite, ISfcHasConnection
- public ServerActiveDirectory ActiveDirectory { get; }
- public AffinityInfo AffinityInfo { get; }
- public AuditLevel AuditLevel { get; set; }
- public AuditCollection Audits { get; }
- public AvailabilityGroupCollection AvailabilityGroups { get; }
- public BackupDeviceCollection BackupDevices { get; }
- public string BackupDirectory { get; set; }
- public string BrowserServiceAccount { get; }
- public ServiceStartMode BrowserStartMode { get; }
- public Version BuildClrVersion { get; }
- public string BuildClrVersionString { get; }
- public int BuildNumber { get; }
- public string ClusterName { get; }
- public ClusterQuorumState ClusterQuorumState { get; }
- public ClusterQuorumType ClusterQuorumType { get; }
- public string Collation { get; }
- public int CollationID { get; }
- public int ComparisonStyle { get; }
- public string ComputerNamePhysicalNetBIOS { get; }
- public Configuration Configuration { get; }
- public ServerConnection ConnectionContext { get; }
- public CredentialCollection Credentials { get; }
- public CryptographicProviderCollection CryptographicProviders { get; }
- public DatabaseCollection Databases { get; }
- public string DefaultFile { get; set; }
- public string DefaultLog { get; set; }
- public bool DefaultTextMode { get; set; }
- public string Edition { get; }
- public EndpointCollection Endpoints { get; }
- public Edition EngineEdition { get; }
- public string ErrorLogPath { get; }
- public ServerEvents Events { get; }
- public FileStreamEffectiveLevel FilestreamLevel { get; }
- public string FilestreamShareName { get; }
- public FullTextService FullTextService { get; }
- public HadrManagerStatus HadrManagerStatus { get; }
- public Information Information { get; }
- public string InstallDataDirectory { get; }
- public string InstallSharedDirectory { get; }
- public string InstanceName { get; }
- public bool IsCaseSensitive { get; }
- public bool IsClustered { get; }
- public bool IsFullTextInstalled { get; }
- public bool IsHadrEnabled { get; }
- public bool IsSingleUser { get; }
- public JobServer JobServer { get; }
- public string Language { get; }
- public LanguageCollection Languages { get; }
- public LinkedServerCollection LinkedServers { get; }
- public ServerLoginMode LoginMode { get; set; }
- public LoginCollection Logins { get; }
- public SqlMail Mail { get; }
- public string MailProfile { get; set; }
- public string MasterDBLogPath { get; }
- public string MasterDBPath { get; }
- public byte MaxPrecision { get; }
- public string Name { get; }
- public bool NamedPipesEnabled { get; }
- public string NetName { get; }
- public int NumberOfLogFiles { get; set; }
- public OleDbProviderSettingsCollection OleDbProviderSettings { get; }
- public string OSVersion { get; }
- public PerfMonMode PerfMonMode { get; set; }
- public int PhysicalMemory { get; }
- public long PhysicalMemoryUsageInKB { get; }
- public string Platform { get; }
- public int Processors { get; }
- public int ProcessorUsage { get; }
- public string Product { get; }
- public string ProductLevel { get; }
- public ServerProxyAccount ProxyAccount { get; }
- public ResourceGovernor ResourceGovernor { get; }
- public DateTime ResourceLastUpdateDateTime { get; }
- public Version ResourceVersion { get; }
- public string ResourceVersionString { get; }
- public ServerRoleCollection Roles { get; }
- public string RootDirectory { get; }
- public ServerAuditSpecificationCollection ServerAuditSpecifications { get; }
- public DatabaseEngineType ServerType { get; }
- public string ServiceAccount { get; }
- public string ServiceInstanceId { get; }
- public ServiceMasterKey ServiceMasterKey { get; }
- public string ServiceName { get; }
- public ServiceStartMode ServiceStartMode { get; }
- public Settings Settings { get; }
- public short SqlCharSet { get; }
- public string SqlCharSetName { get; }
- public string SqlDomainGroup { get; }
- public short SqlSortOrder { get; }
- public string SqlSortOrderName { get; }
- public ServerStatus Status { get; }
- public SystemDataTypeCollection SystemDataTypes { get; }
- public SystemMessageCollection SystemMessages { get; }
- public int TapeLoadWaitTime { get; set; }
- public bool TcpEnabled { get; }
- public ServerDdlTriggerCollection Triggers { get; }
- public UserDefinedMessageCollection UserDefinedMessages { get; }
- public UserOptions UserOptions { get; }
- public Version Version { get; }
- public int VersionMajor { get; }
- public int VersionMinor { get; }
- public string VersionString { get; }
- public Server(string name)
- public Server()
- public Server(ServerConnection serverConnection)
- public void Alter()
- public void Alter(bool overrideValueChecking)
- public void AttachDatabase(string name, StringCollection files, string owner)
- public void AttachDatabase(string name, StringCollection files)
- public void AttachDatabase(string name, StringCollection files, AttachOptions attachOptions)
- public void AttachDatabase(string name, StringCollection files, string owner, AttachOptions attachOptions)
- public int CompareUrn(Urn urn1, Urn urn2)
- public void DeleteBackupHistory(DateTime oldestDate)
- public void DeleteBackupHistory(int mediaSetId)
- public void DeleteBackupHistory(string database)
- public void Deny(ServerPermissionSet permission, string[] granteeNames)
- public void Deny(ServerPermissionSet permission, string[] granteeNames, bool cascade)
- public void Deny(ServerPermissionSet permission, string granteeName)
- public void Deny(ServerPermissionSet permission, string granteeName, bool cascade)
- public void DetachDatabase(string databaseName, bool updateStatistics)
- public void DetachDatabase(string databaseName, bool updateStatistics, bool removeFulltextIndexFile)
- public DataTable DetachedDatabaseInfo(string mdfName)
- public DataTable EnumActiveCurrentSessionTraceFlags()
- public DataTable EnumActiveGlobalTraceFlags()
- public DataTable EnumAvailableMedia()
- public DataTable EnumAvailableMedia(MediaTypes media)
- public DataTable ()
- public DataTable EnumClusterSubnets()
- public DataTable EnumCollations()
- public DataTable EnumDatabaseMirrorWitnessRoles()
- public DataTable EnumDatabaseMirrorWitnessRoles(string database)
- public StringCollection EnumDetachedDatabaseFiles(string mdfName)
- public StringCollection EnumDetachedLogFiles(string mdfName)
- public DataTable EnumDirectories(string path)
- public DataTable EnumErrorLogs()
- public DataTable EnumLocks()
- public DataTable EnumLocks(int processId)
- public StringCollection EnumMembers(RoleTypes roleType)
- public ObjectPermissionInfo[] EnumObjectPermissions()
- public ObjectPermissionInfo[] EnumObjectPermissions(string granteeName)
- public ObjectPermissionInfo[] EnumObjectPermissions(ObjectPermissionSet permissions)
- public ObjectPermissionInfo[] EnumObjectPermissions(string granteeName, ObjectPermissionSet permissions)
- public DataTable EnumPerformanceCounters()
- public DataTable EnumPerformanceCounters(string objectName)
- public DataTable EnumPerformanceCounters(string objectName, string counterName)
- public DataTable EnumPerformanceCounters(string objectName, string counterName, string instanceName)
- public DataTable EnumProcesses()
- public DataTable EnumProcesses(int processId)
- public DataTable EnumProcesses(bool excludeSystemProcesses)
- public DataTable EnumProcesses(string loginName)
- public DataTable EnumServerAttributes()
- public ServerPermissionInfo[] EnumServerPermissions()
- public ServerPermissionInfo[] EnumServerPermissions(string granteeName)
- public ServerPermissionInfo[] EnumServerPermissions(ServerPermissionSet permissions)
- public ServerPermissionInfo[] EnumServerPermissions(string granteeName, ServerPermissionSet permissions)
- public DataTable EnumStartupProcedures()
- public DataTable EnumWindowsDomainGroups()
- public DataTable EnumWindowsDomainGroups(string domain)
- public DataTable EnumWindowsGroupInfo()
- public DataTable EnumWindowsGroupInfo(string group)
- public DataTable EnumWindowsGroupInfo(string group, bool listMembers)
- public DataTable EnumWindowsUserInfo()
- public DataTable EnumWindowsUserInfo(string account)
- public DataTable EnumWindowsUserInfo(string account, bool listPermissionPaths)
- public int GetActiveDBConnectionCount(string dbName)
- public StringCollection GetDefaultInitFields(Type typeObject)
- public StringCollection GetPropertyNames(Type typeObject)
- public SqlSmoObject GetSmoObject(Urn urn)
- public IComparer GetStringComparer(string collationName)
- public void Grant(ServerPermissionSet permission, string[] granteeNames)
- public void Grant(ServerPermissionSet permission, string[] granteeNames, bool grantGrant)
- public void Grant(ServerPermissionSet permission, string[] granteeNames, bool grantGrant, string asRole)
- public void Grant(ServerPermissionSet permission, string granteeName)
- public void Grant(ServerPermissionSet permission, string granteeName, bool grantGrant)
- public void Grant(ServerPermissionSet permission, string granteeName, bool grantGrant, string asRole)
- public bool IsDetachedPrimaryFile(string mdfName)
- public bool IsWindowsGroupMember(string windowsGroup, string windowsUser)
- public void JoinAvailabilityGroup(string availabilityGroupName)
- public void KillAllProcesses(string databaseName)
- public void KillDatabase(string database)
- public void KillProcess(int processId)
- public ServerVersion PingSqlServerVersion(string serverName, string login, string password)
- public ServerVersion PingSqlServerVersion(string serverName)
- public DataTable ReadErrorLog()
- public DataTable ReadErrorLog(int logNumber)
- public void Revoke(ServerPermissionSet permission, string[] granteeNames)
- public void Revoke(ServerPermissionSet permission, string[] granteeNames, bool revokeGrant, bool cascade)
- public void Revoke(ServerPermissionSet permission, string[] granteeNames, bool revokeGrant, bool cascade, string asRole)
- public void Revoke(ServerPermissionSet permission, string granteeName)
- public void Revoke(ServerPermissionSet permission, string granteeName, bool revokeGrant, bool cascade)
- public void Revoke(ServerPermissionSet permission, string granteeName, bool revokeGrant, bool cascade, string asRole)
- public StringCollection Script()
- public StringCollection Script(ScriptingOptions scriptingOptions)
- public void SetDefaultInitFields(Type typeObject, StringCollection fields)
- public void SetDefaultInitFields(Type typeObject, string[] fields)
- public void SetDefaultInitFields(Type typeObject, bool allFields)
- public void SetDefaultInitFields(bool allFields)
- public void SetTraceFlag(int number, bool isOn)
-
public sealed class ServerActiveDirectory : SqlSmoObject
-
public class ServerAdapter : ServerAdapterBase, IDmfAdapter, IServerAuditFacet, IDmfFacet
-
public abstract class ServerAdapterBase : IAlterable, IRefreshable
-
public sealed class ServerAuditSpecification : AuditSpecification, ISfcSupportsDesignMode
-
public sealed class ServerAuditSpecificationCollection : SimpleObjectCollectionBase
-
public class ServerAuditSpecificationExtender : SmoObjectExtender<ServerAuditSpecification>, ISfcValidate
-
public class ServerConfigurationAdapter : ServerAdapterBase, IServerPerformanceFacet, IDmfAdapter, IServerConfigurationFacet, IDmfFacet
-
public sealed class ServerDdlTrigger : DdlTriggerBase, ISfcSupportsDesignMode
-
public sealed class ServerDdlTriggerCollection : SimpleObjectCollectionBase
-
public sealed class ServerEvent
-
public sealed class ServerEventArgs : EventArgs
-
public sealed delegate ServerEventHandler : MulticastDelegate
-
public sealed class ServerEvents
-
public sealed class ServerEventSet : EventSetBase
-
public sealed class ServerPermission
-
public class ServerPermissionInfo : PermissionInfo
-
public sealed class ServerPermissionSet : PermissionSetBase
-
public sealed class ServerProxyAccount : SqlSmoObject, IAlterable
-
public sealed class ServerRole : ScriptNameObjectBase, IObjectPermission, ICreatable, IDroppable, IAlterable, IRenamable, IScriptable
- public DateTime DateCreated { get; }
- public DateTime DateModified { get; }
- public ServerRoleEvents Events { get; }
- public int ID { get; }
- public bool IsFixedRole { get; }
- public string Owner { get; set; }
- public Server Parent { get; set; }
- public ServerRole()
- public ServerRole(Server server, string name)
- public void AddMember(string memberName)
- public void AddMembershipToRole(string roleName)
- public void Alter()
- public void Create()
- public void Deny(ObjectPermissionSet permission, string[] granteeNames)
- public void Deny(ObjectPermissionSet permission, string[] granteeNames, bool cascade)
- public void Deny(ObjectPermissionSet permission, string granteeName)
- public void Deny(ObjectPermissionSet permission, string granteeName, bool cascade)
- public void Drop()
- public void DropMember(string memberName)
- public void DropMembershipFromRole(string roleName)
- public DataTable EnumAgentProxyAccounts()
- public StringCollection EnumContainingRoleNames()
- public StringCollection EnumMemberNames()
- public ObjectPermissionInfo[] EnumObjectPermissions()
- public ObjectPermissionInfo[] EnumObjectPermissions(string granteeName)
- public ObjectPermissionInfo[] EnumObjectPermissions(ObjectPermissionSet permissions)
- public ObjectPermissionInfo[] EnumObjectPermissions(string granteeName, ObjectPermissionSet permissions)
- public StringCollection EnumServerRoleMembers()
- public DataTable EnumServerRolePermissions()
- public void Grant(ObjectPermissionSet permission, string[] granteeNames)
- public void Grant(ObjectPermissionSet permission, string[] granteeNames, bool grantGrant)
- public void Grant(ObjectPermissionSet permission, string[] granteeNames, bool grantGrant, string asRole)
- public void Grant(ObjectPermissionSet permission, string granteeName)
- public void Grant(ObjectPermissionSet permission, string granteeName, bool grantGrant)
- public void Grant(ObjectPermissionSet permission, string granteeName, bool grantGrant, string asRole)
- public void Rename(string newname)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames, bool revokeGrant, bool cascade)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames, bool revokeGrant, bool cascade, string asRole)
- public void Revoke(ObjectPermissionSet permission, string granteeName)
- public void Revoke(ObjectPermissionSet permission, string granteeName, bool revokeGrant, bool cascade)
- public void Revoke(ObjectPermissionSet permission, string granteeName, bool revokeGrant, bool cascade, string asRole)
- public StringCollection Script()
- public StringCollection Script(ScriptingOptions scriptingOptions)
-
public sealed class ServerRoleCollection : SimpleObjectCollectionBase
-
public class ServerRoleEvents
-
public class ServerRoleExtender : SmoObjectExtender<ServerRole>, ISfcValidate
-
public class ServerSecurityAdapter : ServerAdapterBase, IDmfAdapter, IServerSecurityFacet, IDmfFacet
-
public class ServerSelectionAdapter : ServerAdapterBase, IDmfAdapter, IServerSelectionFacet, IDmfFacet
-
public class ServerSetupAdapter : ServerAdapterBase, IDmfAdapter, IServerSetupFacet, IDmfFacet
-
public enum ServerStatus
-
public class ServerSurfaceAreaAdapter : ServerAdapterBase, IDmfAdapter, ISurfaceAreaFacet, IDmfFacet
-
public sealed class ServerTraceEvent
-
public sealed class ServerTraceEventSet : EventSetBase
-
public sealed class ServiceBrokerPayload : EndpointPayload
-
public sealed class ServiceMasterKey : SqlSmoObject
- public Server Parent { get; }
- public void ChangeAccount(string newAccount, string newPassword)
- public void Export(string path, string password)
- public void Import(string path, string password)
- public void Recover(string oldAccount, string oldPassword)
- public void Regenerate()
- public void Regenerate(bool forceRegeneration)
-
public sealed class ServiceQueueEvent
-
public sealed class ServiceQueueEventSet : EventSetBase
-
public sealed class ServiceRequestException : SmoException
-
public enum ServiceStartMode
-
public sealed class Settings : SqlSmoObject, IAlterable, IScriptable
-
public sealed class SfcDependencyException : SmoException
-
public enum ShrinkMethod
-
public abstract class SimpleObjectCollectionBase : SortedListCollectionBase
-
public class SmoApplication
-
public abstract class SmoCollectionBase : AbstractCollectionBase, ICollection, IEnumerable
-
public class SmoDmfAdapter
-
public class SmoEventArgs : EventArgs
-
public class SmoException : SqlServerManagementException
-
public enum SmoExceptionType
-
public abstract class SmoObjectBase : ISfcValidate
-
public class SmoObjectExtender<T> : SfcObjectExtender<T> where T : SqlSmoObject
-
public class SoapMethodCollectionBase : SimpleObjectCollectionBase
- public bool Contains(string name, string methodNamespace)
- public bool Contains(string name)
- public void Remove(string name)
- public void Remove(string name, string methodNamespace)
-
public class SoapMethodObject : ScriptNameObjectBase
-
public sealed class SoapPayload : EndpointPayload
-
public sealed class SoapPayloadMethod : SoapMethodObject, ICreatable, IDroppable, IAlterable
- public bool IsSystemObject { get; }
- public MethodLoginType MethodLoginType { get; set; }
- public MethodXsdSchemaOption MethodXsdSchemaOption { get; set; }
- public SoapPayload Parent { get; set; }
- public ResultFormat ResultFormat { get; set; }
- public string SqlMethod { get; }
- public SoapPayloadMethod()
- public SoapPayloadMethod(SoapPayload soapPayload, string name)
- public SoapPayloadMethod(SoapPayload soapPayload, string name, string methodNamespace)
- public SoapPayloadMethod(SoapPayload soapPayload, string name, string database, string schema, string sqlMethod)
- public SoapPayloadMethod(SoapPayload soapPayload, string name, string database, string schema, string sqlMethod, string methodNamespace)
- public void Alter()
- public void Create()
- public void Drop()
- public void SetSqlMethod(string database, string schema, string name)
-
public sealed class SoapPayloadMethodCollection : SoapMethodCollectionBase
-
public abstract class SortedListCollectionBase : SmoCollectionBase
-
public enum SortOrder
-
public sealed class SqlAssembly : ScriptNameObjectBase, ISfcSupportsDesignMode, IObjectPermission, IAlterable, IDroppable, IExtendedProperties, IScriptable
- public AssemblySecurityLevel AssemblySecurityLevel { get; set; }
- public DateTime CreateDate { get; }
- public string Culture { get; }
- public SqlAssemblyEvents Events { get; }
- public ExtendedPropertyCollection ExtendedProperties { get; }
- public int ID { get; }
- public bool IsSystemObject { get; }
- public bool IsVisible { get; set; }
- public string Owner { get; set; }
- public Database Parent { get; set; }
- public byte[] PublicKey { get; set; }
- public SqlAssemblyFileCollection SqlAssemblyFiles { get; }
- public Version Version { get; }
- public SqlAssembly()
- public SqlAssembly(Database database, string name)
- public void Alter()
- public void Alter(AssemblyAlterOptions assemblyAlterMethod)
- public void Alter(AssemblyAlterOptions assemblyAlterMethod, string primaryAssemblyServerPath)
- public void Alter(AssemblyAlterOptions assemblyAlterMethod, string[] assemblyLocalPaths)
- public void Create(string[] assemblyLocalPaths)
- public void Create(string primaryAssemblyServerPath)
- public void Deny(ObjectPermissionSet permission, string[] granteeNames)
- public void Deny(ObjectPermissionSet permission, string[] granteeNames, bool cascade)
- public void Deny(ObjectPermissionSet permission, string granteeName)
- public void Deny(ObjectPermissionSet permission, string granteeName, bool cascade)
- public void Drop()
- public ObjectPermissionInfo[] EnumObjectPermissions()
- public ObjectPermissionInfo[] EnumObjectPermissions(string granteeName)
- public ObjectPermissionInfo[] EnumObjectPermissions(ObjectPermissionSet permissions)
- public ObjectPermissionInfo[] EnumObjectPermissions(string granteeName, ObjectPermissionSet permissions)
- public void Grant(ObjectPermissionSet permission, string[] granteeNames)
- public void Grant(ObjectPermissionSet permission, string[] granteeNames, bool grantGrant)
- public void Grant(ObjectPermissionSet permission, string[] granteeNames, bool grantGrant, string asRole)
- public void Grant(ObjectPermissionSet permission, string granteeName)
- public void Grant(ObjectPermissionSet permission, string granteeName, bool grantGrant)
- public void Grant(ObjectPermissionSet permission, string granteeName, bool grantGrant, string asRole)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames, bool revokeGrant, bool cascade)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames, bool revokeGrant, bool cascade, string asRole)
- public void Revoke(ObjectPermissionSet permission, string granteeName)
- public void Revoke(ObjectPermissionSet permission, string granteeName, bool revokeGrant, bool cascade)
- public void Revoke(ObjectPermissionSet permission, string granteeName, bool revokeGrant, bool cascade, string asRole)
- public StringCollection Script()
- public StringCollection Script(ScriptingOptions scriptingOptions)
-
public sealed class SqlAssemblyCollection : SimpleObjectCollectionBase
-
public sealed class SqlAssemblyEvent
-
public class SqlAssemblyEvents
-
public sealed class SqlAssemblyEventSet : EventSetBase
-
public sealed class SqlAssemblyFile : ScriptNameObjectBase
-
public sealed class SqlAssemblyFileCollection : SimpleObjectCollectionBase
-
public enum SqlDataType
-
public class SqlPropertyCollection : PropertyCollection
-
public class SqlPropertyInfo
-
public enum SqlServerVersion
-
public enum SqlServerVersions
-
public abstract class SqlSmoObject : SmoObjectBase, ISfcPropertyProvider, ISfcNotifyPropertyMetadataChanged, INotifyPropertyChanged, IRefreshable, IAlienObject, ISqlSmoObjectInitialize
- protected ExtendedPropertyCollection m_ExtendedProperties
- protected SqlSmoObject singletonParent
- protected bool ExecuteForScalar { get; protected set; }
- protected bool IsTouched { get; }
- protected bool ObjectInSpace { get; }
- public SqlPropertyCollection Properties { get; }
- protected object[] ScalarResult { get; }
- public Urn Urn { get; }
- public event PropertyChangedEventHandler PropertyChanged
- public event EventHandler<SfcPropertyMetadataChangedEventArgs> PropertyMetadataChanged
- public static Type GetChildType(string objectName, string parentName)
- public static Type GetTypeFromUrnSkeleton(Urn urn)
- protected static bool IsCollectionDirty(ICollection col)
- protected void AddDatabaseContext(StringCollection queries)
- protected void AlterImpl()
- protected void AlterImplWorker()
- protected void BindDefaultImpl(string defaultSchema, string defaultName, bool bindColumns)
- protected void BindRuleImpl(string ruleSchema, string rule, bool bindColumns)
- protected void CheckObjectState()
- protected virtual void CheckObjectState(bool throwIfNotCreated)
- protected void CheckObjectStateImpl(bool throwIfNotCreated)
- protected void CheckVersion100()
- protected void CheckVersion110()
- protected void CheckVersion110(string propertyName)
- protected void CheckVersion80()
- protected void CheckVersion80SP3()
- protected void CheckVersion90()
- protected void CheckVersionBelow110()
- protected void CheckVersionBelow90()
- protected virtual void CleanObject()
- protected void CreateImpl()
- public List<object> Discover()
- protected void DropImpl()
- protected void DropImplWorker(ref Urn urn)
- protected void ExecuteNonQuery(StringCollection queries, bool includeDbContext)
- protected void GenerateAlterEvent(Urn urn, object innerObject)
- protected void GenerateAlterEvent()
- protected string GetFragOptionString(FragmentationOption fragmentationOption)
- protected object GetRealValue(Property prop, object oldValue)
- protected virtual string GetServerName()
- protected string GetSqlServerVersionName()
- protected virtual void GetUrnRecursive(StringBuilder urnbuilder)
- protected virtual void GetUrnRecursive(StringBuilder urnbuilder, UrnIdOption idOption)
- protected virtual bool ImplInitialize(string[] fields, OrderBy[] orderby)
- public bool Initialize()
- public bool Initialize(bool allProperties)
- protected virtual bool IsObjectDirty()
- protected bool IsVersion80SP3()
- protected bool IsVersion90AndAbove()
- protected virtual void MarkDropped()
- protected void MarkForDropImpl(bool dropOnAlter)
- protected virtual void PostAlter()
- protected virtual void PostCreate()
- protected virtual void PostDrop()
- public virtual void Refresh()
- protected StringCollection ScriptImpl()
- protected StringCollection ScriptImpl(ScriptingOptions so)
- protected virtual void TouchImpl()
- protected void UnbindDefaultImpl(bool bindColumns)
- protected void UnbindRuleImpl(bool bindColumns)
-
public enum SqlSmoState
-
public sealed class Statistic : ScriptNameObjectBase, ICreatable, IDroppable, IMarkForDrop, IScriptable, ISfcSupportsDesignMode
-
public sealed class StatisticCollection : SimpleObjectCollectionBase
-
public sealed class StatisticColumn : NamedSmoObject, ISfcSupportsDesignMode
-
public sealed class StatisticColumnCollection : ParameterCollectionBase
-
public class StatisticEvents
-
public enum StatisticsScanType
-
public enum StatisticsTarget
-
public sealed class StoredProcedure : ScriptSchemaObjectBase, ISfcSupportsDesignMode, IObjectPermission, ICreatable, IAlterable, IDroppable, IRenamable, IExtendedProperties, IScriptable, ITextObject
- public bool AnsiNullsStatus { get; set; }
- public string AssemblyName { get; set; }
- public string ClassName { get; set; }
- public DateTime CreateDate { get; }
- public DateTime DateLastModified { get; }
- public StoredProcedureEvents Events { get; }
- public ExecutionContext ExecutionContext { get; set; }
- public string ExecutionContextPrincipal { get; set; }
- public ExtendedPropertyCollection ExtendedProperties { get; }
- public bool ForReplication { get; set; }
- public int ID { get; }
- public ImplementationType ImplementationType { get; set; }
- public bool IsEncrypted { get; set; }
- public bool IsSchemaOwned { get; }
- public bool IsSystemObject { get; }
- public string MethodName { get; set; }
- public NumberedStoredProcedureCollection NumberedStoredProcedures { get; }
- public string Owner { get; set; }
- public StoredProcedureParameterCollection Parameters { get; }
- public Database Parent { get; set; }
- public bool QuotedIdentifierStatus { get; set; }
- public bool Recompile { get; set; }
- public bool Startup { get; set; }
- public string TextBody { get; set; }
- public string { get; set; }
- public bool TextMode { get; set; }
- public StoredProcedure()
- public StoredProcedure(Database database, string name)
- public StoredProcedure(Database database, string name, string schema)
- public void Alter()
- public void ChangeSchema(string newSchema)
- public void Create()
- public void Deny(ObjectPermissionSet permission, string[] granteeNames)
- public void Deny(ObjectPermissionSet permission, string[] granteeNames, bool cascade)
- public void Deny(ObjectPermissionSet permission, string granteeName)
- public void Deny(ObjectPermissionSet permission, string granteeName, bool cascade)
- public void Drop()
- public ObjectPermissionInfo[] EnumObjectPermissions()
- public ObjectPermissionInfo[] EnumObjectPermissions(string granteeName)
- public ObjectPermissionInfo[] EnumObjectPermissions(ObjectPermissionSet permissions)
- public ObjectPermissionInfo[] EnumObjectPermissions(string granteeName, ObjectPermissionSet permissions)
- public void Grant(ObjectPermissionSet permission, string[] granteeNames)
- public void Grant(ObjectPermissionSet permission, string[] granteeNames, bool grantGrant)
- public void Grant(ObjectPermissionSet permission, string[] granteeNames, bool grantGrant, string asRole)
- public void Grant(ObjectPermissionSet permission, string granteeName)
- public void Grant(ObjectPermissionSet permission, string granteeName, bool grantGrant)
- public void Grant(ObjectPermissionSet permission, string granteeName, bool grantGrant, string asRole)
- public void ReCompileReferences()
- public void Rename(string newname)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames, bool revokeGrant, bool cascade)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames, bool revokeGrant, bool cascade, string asRole)
- public void Revoke(ObjectPermissionSet permission, string granteeName)
- public void Revoke(ObjectPermissionSet permission, string granteeName, bool revokeGrant, bool cascade)
- public void Revoke(ObjectPermissionSet permission, string granteeName, bool revokeGrant, bool cascade, string asRole)
- public StringCollection Script()
- public StringCollection Script(ScriptingOptions scriptingOptions)
- public string (bool forAlter)
-
public sealed class StoredProcedureCollection : SchemaCollectionBase
-
public sealed class StoredProcedureEvent
-
public class StoredProcedureEvents
-
public sealed class StoredProcedureEventSet : EventSetBase
-
public sealed class StoredProcedureParameter : Parameter, ISfcSupportsDesignMode
-
public sealed class StoredProcedureParameterCollection : ParameterCollectionBase
-
public sealed class SymmetricKey : NamedSmoObject, IAlterable, IDroppable, IObjectPermission
- public DateTime CreateDate { get; }
- public DateTime DateLastModified { get; }
- public SymmetricKeyEncryptionAlgorithm EncryptionAlgorithm { get; }
- public int ID { get; }
- public bool IsOpen { get; }
- public Guid KeyGuid { get; }
- public int KeyLength { get; }
- public string Owner { get; set; }
- public Database Parent { get; set; }
- public string ProviderName { get; set; }
- public SymmetricKey()
- public SymmetricKey(Database database, string name)
- public void AddKeyEncryption(SymmetricKeyEncryption keyEncryption)
- public void AddKeyEncryption(SymmetricKeyEncryption[] keyEncryptions)
- public void Alter()
- public void Close()
- public void Create(SymmetricKeyEncryption keyEncryption, SymmetricKeyEncryptionAlgorithm keyEncryptionAlgorithm)
- public void Create(SymmetricKeyEncryption keyEncryption, SymmetricKeyEncryptionAlgorithm keyEncryptionAlgorithm, string passPhrase)
- public void Create(SymmetricKeyEncryption keyEncryption, SymmetricKeyEncryptionAlgorithm keyEncryptionAlgorithm, SecureString passPhrase)
- public void Create(SymmetricKeyEncryption keyEncryption, SymmetricKeyEncryptionAlgorithm keyEncryptionAlgorithm, string passPhrase, string identityPhrase)
- public void Create(SymmetricKeyEncryption keyEncryption, SymmetricKeyEncryptionAlgorithm keyEncryptionAlgorithm, SecureString passPhrase, string identityPhrase)
- public void Create(SymmetricKeyEncryption keyEncryption, string providerAlgorithm, string providerKeyName, CreateDispositionType createDispositionType)
- public void Create(SymmetricKeyEncryption[] keyEncryptions, SymmetricKeyEncryptionAlgorithm keyEncryptionAlgorithm)
- public void Create(SymmetricKeyEncryption[] keyEncryptions, SymmetricKeyEncryptionAlgorithm keyEncryptionAlgorithm, string passPhrase)
- public void Create(SymmetricKeyEncryption[] keyEncryptions, SymmetricKeyEncryptionAlgorithm keyEncryptionAlgorithm, SecureString passPhrase)
- public void Create(SymmetricKeyEncryption[] keyEncryptions, SymmetricKeyEncryptionAlgorithm keyEncryptionAlgorithm, string passPhrase, string identityPhrase)
- public void Create(SymmetricKeyEncryption[] keyEncryptions, SymmetricKeyEncryptionAlgorithm keyEncryptionAlgorithm, SecureString passPhrase, string identityPhrase)
- public void Deny(ObjectPermissionSet permission, string[] granteeNames)
- public void Deny(ObjectPermissionSet permission, string[] granteeNames, bool cascade)
- public void Deny(ObjectPermissionSet permission, string granteeName)
- public void Deny(ObjectPermissionSet permission, string granteeName, bool cascade)
- public void Drop()
- public void Drop(bool removeProviderKey)
- public void DropKeyEncryption(SymmetricKeyEncryption keyEncryption)
- public void DropKeyEncryption(SymmetricKeyEncryption[] keyEncryptions)
- public DataTable EnumKeyEncryptions()
- public ObjectPermissionInfo[] EnumObjectPermissions()
- public ObjectPermissionInfo[] EnumObjectPermissions(string granteeName)
- public ObjectPermissionInfo[] EnumObjectPermissions(ObjectPermissionSet permissions)
- public ObjectPermissionInfo[] EnumObjectPermissions(string granteeName, ObjectPermissionSet permissions)
- public void Grant(ObjectPermissionSet permission, string[] granteeNames)
- public void Grant(ObjectPermissionSet permission, string[] granteeNames, bool grantGrant)
- public void Grant(ObjectPermissionSet permission, string[] granteeNames, bool grantGrant, string asRole)
- public void Grant(ObjectPermissionSet permission, string granteeName)
- public void Grant(ObjectPermissionSet permission, string granteeName, bool grantGrant)
- public void Grant(ObjectPermissionSet permission, string granteeName, bool grantGrant, string asRole)
- public void Open(string password)
- public void OpenWithCertificate(string certificateName)
- public void OpenWithCertificate(string certificateName, string privateKeyPassword)
- public void OpenWithSymmetricKey(string symmetricKeyName)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames, bool revokeGrant, bool cascade)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames, bool revokeGrant, bool cascade, string asRole)
- public void Revoke(ObjectPermissionSet permission, string granteeName)
- public void Revoke(ObjectPermissionSet permission, string granteeName, bool revokeGrant, bool cascade)
- public void Revoke(ObjectPermissionSet permission, string granteeName, bool revokeGrant, bool cascade, string asRole)
-
public sealed class SymmetricKeyCollection : SimpleObjectCollectionBase
-
public class SymmetricKeyEncryption
-
public sealed class Synonym : ScriptSchemaObjectBase, ISfcSupportsDesignMode, IObjectPermission, ICreatable, IDroppable, IExtendedProperties, IScriptable, IAlterable
- public string BaseDatabase { get; set; }
- public string BaseObject { get; set; }
- public string BaseSchema { get; set; }
- public string BaseServer { get; set; }
- public SynonymBaseType BaseType { get; }
- public DateTime CreateDate { get; }
- public DateTime DateLastModified { get; }
- public SynonymEvents Events { get; }
- public ExtendedPropertyCollection ExtendedProperties { get; }
- public int ID { get; }
- public bool IsSchemaOwned { get; }
- public string Owner { get; set; }
- public Database Parent { get; set; }
- public Synonym()
- public Synonym(Database database, string name)
- public Synonym(Database database, string name, string schema)
- public Synonym(Database database, string name, string schema, string baseServer, string baseDatabase, string baseSchema, string baseObject)
- public Synonym(Database database, string name, string baseServer, string baseDatabase, string baseSchema, string baseObject)
- public void Alter()
- public void Create()
- public void Deny(ObjectPermissionSet permission, string[] granteeNames)
- public void Deny(ObjectPermissionSet permission, string[] granteeNames, bool cascade)
- public void Deny(ObjectPermissionSet permission, string granteeName)
- public void Deny(ObjectPermissionSet permission, string granteeName, bool cascade)
- public void Drop()
- public ObjectPermissionInfo[] EnumObjectPermissions()
- public ObjectPermissionInfo[] EnumObjectPermissions(string granteeName)
- public ObjectPermissionInfo[] EnumObjectPermissions(ObjectPermissionSet permissions)
- public ObjectPermissionInfo[] EnumObjectPermissions(string granteeName, ObjectPermissionSet permissions)
- public void Grant(ObjectPermissionSet permission, string[] granteeNames)
- public void Grant(ObjectPermissionSet permission, string[] granteeNames, bool grantGrant)
- public void Grant(ObjectPermissionSet permission, string[] granteeNames, bool grantGrant, string asRole)
- public void Grant(ObjectPermissionSet permission, string granteeName)
- public void Grant(ObjectPermissionSet permission, string granteeName, bool grantGrant)
- public void Grant(ObjectPermissionSet permission, string granteeName, bool grantGrant, string asRole)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames, bool revokeGrant, bool cascade)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames, bool revokeGrant, bool cascade, string asRole)
- public void Revoke(ObjectPermissionSet permission, string granteeName)
- public void Revoke(ObjectPermissionSet permission, string granteeName, bool revokeGrant, bool cascade)
- public void Revoke(ObjectPermissionSet permission, string granteeName, bool revokeGrant, bool cascade, string asRole)
- public StringCollection Script()
- public StringCollection Script(ScriptingOptions scriptingOptions)
-
public sealed class SynonymCollection : SchemaCollectionBase
-
public class SynonymEvents
-
public sealed class SystemDataType : NamedSmoObject, ISfcSupportsDesignMode
-
public sealed class SystemDataTypeCollection : SimpleObjectCollectionBase
-
public sealed class SystemMessage : MessageObjectBase
-
public class SystemMessageCollection : MessageCollectionBase
-
public sealed class Table : TableViewBase, ISfcSupportsDesignMode, IColumnPermission, IObjectPermission, IPropertyDataDispatch, ICreatable, IAlterable, IDroppable, IRenamable, ITableOptions, IDmfFacet
- public bool AnsiNullsStatus { get; set; }
- public bool ChangeTrackingEnabled { get; set; }
- public CheckCollection Checks { get; }
- public DateTime CreateDate { get; }
- public double DataSpaceUsed { get; }
- public DateTime DateLastModified { get; }
- public string DistributionName { get; set; }
- public TableEvents Events { get; }
- public bool FakeSystemTable { get; }
- public int FederationColumnID { get; }
- public string FederationColumnName { get; set; }
- public string FileGroup { get; set; }
- public string FileStreamFileGroup { get; set; }
- public string FileStreamPartitionScheme { get; set; }
- public string FileTableDirectoryName { get; set; }
- public string FileTableNameColumnCollation { get; set; }
- public bool FileTableNamespaceEnabled { get; set; }
- public ForeignKeyCollection ForeignKeys { get; }
- public bool HasAfterTrigger { get; }
- public bool HasClusteredIndex { get; }
- public bool HasCompressedPartitions { get; }
- public bool HasDeleteTrigger { get; }
- public bool HasIndex { get; }
- public bool HasInsertTrigger { get; }
- public bool HasInsteadOfTrigger { get; }
- public bool HasUpdateTrigger { get; }
- public int ID { get; }
- public double IndexSpaceUsed { get; }
- public bool IsFileTable { get; set; }
- public bool IsIndexable { get; }
- public bool IsPartitioned { get; }
- public bool IsSchemaOwned { get; }
- public bool IsSystemObject { get; }
- public bool IsVarDecimalStorageFormatEnabled { get; set; }
- public LockEscalationType LockEscalation { get; set; }
- public int MaximumDegreeOfParallelism { get; set; }
- public bool OnlineHeapOperation { get; set; }
- public string Owner { get; set; }
- public Database Parent { get; set; }
- public string PartitionScheme { get; set; }
- public PartitionSchemeParameterCollection PartitionSchemeParameters { get; }
- public PhysicalPartitionCollection PhysicalPartitions { get; }
- public bool QuotedIdentifierStatus { get; set; }
- public bool Replicated { get; }
- public long RowCount { get; }
- public double RowCountAsDouble { get; }
- public string TextFileGroup { get; set; }
- public bool TrackColumnsUpdatedEnabled { get; set; }
- public Table()
- public Table(Database database, string name)
- public Table(Database database, string name, string schema)
- public void Alter()
- public void AlterWithNoCheck()
- public void ChangeSchema(string newSchema)
- public StringCollection CheckIdentityValue()
- public StringCollection CheckTable()
- public StringCollection CheckTableDataOnly()
- public void Create()
- public void Deny(ObjectPermissionSet permission, string[] granteeNames)
- public void Deny(ObjectPermissionSet permission, string[] granteeNames, bool cascade)
- public void Deny(ObjectPermissionSet permission, string granteeName)
- public void Deny(ObjectPermissionSet permission, string granteeName, bool cascade)
- public void Deny(ObjectPermissionSet permission, string[] granteeNames, string[] columnNames)
- public void Deny(ObjectPermissionSet permission, string[] granteeNames, string[] columnNames, bool cascade)
- public void Deny(ObjectPermissionSet permission, string granteeName, string[] columnNames)
- public void Deny(ObjectPermissionSet permission, string granteeName, string[] columnNames, bool cascade)
- public void DisableAllIndexes()
- public void Drop()
- public void EnableAllIndexes(IndexEnableAction action)
- public ObjectPermissionInfo[] EnumColumnPermissions()
- public ObjectPermissionInfo[] EnumColumnPermissions(string granteeName)
- public ObjectPermissionInfo[] EnumColumnPermissions(ObjectPermissionSet permissions)
- public ObjectPermissionInfo[] EnumColumnPermissions(string granteeName, ObjectPermissionSet permissions)
- public DataTable EnumForeignKeys()
- public DataTable EnumLastStatisticsUpdates()
- public DataTable EnumLastStatisticsUpdates(string statname)
- public ObjectPermissionInfo[] EnumObjectPermissions()
- public ObjectPermissionInfo[] EnumObjectPermissions(string granteeName)
- public ObjectPermissionInfo[] EnumObjectPermissions(ObjectPermissionSet permissions)
- public ObjectPermissionInfo[] EnumObjectPermissions(string granteeName, ObjectPermissionSet permissions)
- public IEnumerable<string> EnumScript()
- public IEnumerable<string> EnumScript(ScriptingOptions scriptingOptions)
- public void Grant(ObjectPermissionSet permission, string[] granteeNames)
- public void Grant(ObjectPermissionSet permission, string[] granteeNames, bool grantGrant)
- public void Grant(ObjectPermissionSet permission, string[] granteeNames, bool grantGrant, string asRole)
- public void Grant(ObjectPermissionSet permission, string granteeName)
- public void Grant(ObjectPermissionSet permission, string granteeName, bool grantGrant)
- public void Grant(ObjectPermissionSet permission, string granteeName, bool grantGrant, string asRole)
- public void Grant(ObjectPermissionSet permission, string[] granteeNames, string[] columnNames)
- public void Grant(ObjectPermissionSet permission, string[] granteeNames, string[] columnNames, bool grantGrant)
- public void Grant(ObjectPermissionSet permission, string[] granteeNames, string[] columnNames, bool grantGrant, string asRole)
- public void Grant(ObjectPermissionSet permission, string granteeName, string[] columnNames)
- public void Grant(ObjectPermissionSet permission, string granteeName, string[] columnNames, bool grantGrant)
- public void Grant(ObjectPermissionSet permission, string granteeName, string[] columnNames, bool grantGrant, string asRole)
- public void Rebuild(int partitionNumber)
- public void Rebuild()
- public void RebuildIndexes(int fillFactor)
- public void RecalculateSpaceUsage()
- public void Rename(string newname)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames, bool revokeGrant, bool cascade)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames, bool revokeGrant, bool cascade, string asRole)
- public void Revoke(ObjectPermissionSet permission, string granteeName)
- public void Revoke(ObjectPermissionSet permission, string granteeName, bool revokeGrant, bool cascade)
- public void Revoke(ObjectPermissionSet permission, string granteeName, bool revokeGrant, bool cascade, string asRole)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames, string[] columnNames)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames, string[] columnNames, bool revokeGrant, bool cascade)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames, string[] columnNames, bool revokeGrant, bool cascade, string asRole)
- public void Revoke(ObjectPermissionSet permission, string granteeName, string[] columnNames)
- public void Revoke(ObjectPermissionSet permission, string granteeName, string[] columnNames, bool revokeGrant, bool cascade)
- public void Revoke(ObjectPermissionSet permission, string granteeName, string[] columnNames, bool revokeGrant, bool cascade, string asRole)
- public void SwitchPartition(int sourcePartitionNumber, Table targetTable, int targetPartitionNumber)
- public void SwitchPartition(int sourcePartitionNumber, Table targetTable)
- public void SwitchPartition(Table targetTable, int targetPartitionNumber)
- public void SwitchPartition(Table targetTable)
- public void TruncateData()
-
public sealed class TableCollection : SchemaCollectionBase
-
public sealed class TableEvent
-
public class TableEvents
-
public sealed class TableEventSet : EventSetBase
-
public class TableViewBase : TableViewTableTypeBase, IExtendedProperties, IScriptable
-
public class TableViewTableTypeBase : ScriptSchemaObjectBase, IExtendedProperties, IScriptable
-
public sealed class TcpProtocol : EndpointProtocol
-
public enum TerminationClause
-
public enum TransactionTypes
-
public sealed class Trigger : ScriptNameObjectBase, ICreatable, IAlterable, IDroppable, IMarkForDrop, IExtendedProperties, IScriptable, ITextObject, ISfcSupportsDesignMode
-
public class TriggerCollection : SimpleObjectCollectionBase
-
public class TriggerEvents
-
public sealed class UnknownPropertyException : SmoException
-
public sealed class UnsupportedEngineTypeException : SmoException
-
public sealed class UnsupportedFeatureException : SmoException
-
public sealed class UnsupportedObjectNameException : SmoException
-
public sealed class UnsupportedVersionException : SmoException
-
public class UrnCollection : IList<Urn>, ICollection<Urn>, IEnumerable<Urn>, IEnumerable
-
public enum UrnIdOption
-
public sealed class User : ScriptNameObjectBase, ISfcSupportsDesignMode, IObjectPermission, ICreatable, IDroppable, IAlterable, IRenamable, IExtendedProperties, IScriptable, IUserOptions, IDmfFacet
- public string AsymmetricKey { get; set; }
- public AuthenticationType AuthenticationType { get; }
- public string Certificate { get; set; }
- public DateTime CreateDate { get; }
- public DateTime DateLastModified { get; }
- public DefaultLanguage DefaultLanguage { get; }
- public string DefaultSchema { get; set; }
- public UserEvents Events { get; }
- public ExtendedPropertyCollection ExtendedProperties { get; }
- public bool HasDBAccess { get; }
- public int ID { get; }
- public bool IsSystemObject { get; }
- public string Login { get; set; }
- public LoginType LoginType { get; }
- public Database Parent { get; set; }
- public byte[] Sid { get; }
- public UserType UserType { get; set; }
- public User()
- public User(Database database, string name)
- public void AddToRole(string role)
- public void Alter()
- public void ChangePassword(string newPassword)
- public void ChangePassword(SecureString newPassword)
- public void ChangePassword(string oldPassword, string newPassword)
- public void ChangePassword(SecureString oldPassword, SecureString newPassword)
- public void Create()
- public void Create(string password)
- public void Create(SecureString password)
- public void Deny(ObjectPermissionSet permission, string[] granteeNames)
- public void Deny(ObjectPermissionSet permission, string[] granteeNames, bool cascade)
- public void Deny(ObjectPermissionSet permission, string granteeName)
- public void Deny(ObjectPermissionSet permission, string granteeName, bool cascade)
- public void Drop()
- public ObjectPermissionInfo[] EnumObjectPermissions()
- public ObjectPermissionInfo[] EnumObjectPermissions(string granteeName)
- public ObjectPermissionInfo[] EnumObjectPermissions(ObjectPermissionSet permissions)
- public ObjectPermissionInfo[] EnumObjectPermissions(string granteeName, ObjectPermissionSet permissions)
- public Urn[] EnumOwnedObjects()
- public StringCollection EnumRoles()
- public void Grant(ObjectPermissionSet permission, string[] granteeNames)
- public void Grant(ObjectPermissionSet permission, string[] granteeNames, bool grantGrant)
- public void Grant(ObjectPermissionSet permission, string[] granteeNames, bool grantGrant, string asRole)
- public void Grant(ObjectPermissionSet permission, string granteeName)
- public void Grant(ObjectPermissionSet permission, string granteeName, bool grantGrant)
- public void Grant(ObjectPermissionSet permission, string granteeName, bool grantGrant, string asRole)
- public bool IsMember(string role)
- public void MakeContained(bool copyLoginName, bool disableLogin)
- public void Rename(string newname)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames, bool revokeGrant, bool cascade)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames, bool revokeGrant, bool cascade, string asRole)
- public void Revoke(ObjectPermissionSet permission, string granteeName)
- public void Revoke(ObjectPermissionSet permission, string granteeName, bool revokeGrant, bool cascade)
- public void Revoke(ObjectPermissionSet permission, string granteeName, bool revokeGrant, bool cascade, string asRole)
- public StringCollection Script()
- public StringCollection Script(ScriptingOptions scriptingOptions)
-
public sealed class UserCollection : SimpleObjectCollectionBase
-
public sealed class UserDefinedAggregate : ScriptSchemaObjectBase, ISfcSupportsDesignMode, IObjectPermission, ICreatable, IDroppable, IExtendedProperties, IScriptable, IAlterable
- public string AssemblyName { get; set; }
- public string ClassName { get; set; }
- public DateTime CreateDate { get; }
- public DataType DataType { get; set; }
- public DateTime DateLastModified { get; }
- public ExtendedPropertyCollection ExtendedProperties { get; }
- public int ID { get; }
- public bool IsSchemaOwned { get; }
- public string Owner { get; set; }
- public UserDefinedAggregateParameterCollection Parameters { get; }
- public Database Parent { get; set; }
- public UserDefinedAggregate()
- public UserDefinedAggregate(Database database, string name)
- public UserDefinedAggregate(Database database, string name, string schema)
- public void Alter()
- public void ChangeSchema(string newSchema)
- public void Create()
- public void Deny(ObjectPermissionSet permission, string[] granteeNames)
- public void Deny(ObjectPermissionSet permission, string[] granteeNames, bool cascade)
- public void Deny(ObjectPermissionSet permission, string granteeName)
- public void Deny(ObjectPermissionSet permission, string granteeName, bool cascade)
- public void Drop()
- public ObjectPermissionInfo[] EnumObjectPermissions()
- public ObjectPermissionInfo[] EnumObjectPermissions(string granteeName)
- public ObjectPermissionInfo[] EnumObjectPermissions(ObjectPermissionSet permissions)
- public ObjectPermissionInfo[] EnumObjectPermissions(string granteeName, ObjectPermissionSet permissions)
- public void Grant(ObjectPermissionSet permission, string[] granteeNames)
- public void Grant(ObjectPermissionSet permission, string[] granteeNames, bool grantGrant)
- public void Grant(ObjectPermissionSet permission, string[] granteeNames, bool grantGrant, string asRole)
- public void Grant(ObjectPermissionSet permission, string granteeName)
- public void Grant(ObjectPermissionSet permission, string granteeName, bool grantGrant)
- public void Grant(ObjectPermissionSet permission, string granteeName, bool grantGrant, string asRole)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames, bool revokeGrant, bool cascade)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames, bool revokeGrant, bool cascade, string asRole)
- public void Revoke(ObjectPermissionSet permission, string granteeName)
- public void Revoke(ObjectPermissionSet permission, string granteeName, bool revokeGrant, bool cascade)
- public void Revoke(ObjectPermissionSet permission, string granteeName, bool revokeGrant, bool cascade, string asRole)
- public StringCollection Script()
- public StringCollection Script(ScriptingOptions scriptingOptions)
-
public sealed class UserDefinedAggregateCollection : SchemaCollectionBase
-
public sealed class UserDefinedAggregateParameter : ParameterBase, ISfcSupportsDesignMode
-
public sealed class UserDefinedAggregateParameterCollection : ParameterCollectionBase
-
public sealed class UserDefinedDataType : ScriptSchemaObjectBase, ICreatable, IAlterable, IDroppable, IRenamable, IExtendedProperties, IScriptable, ISfcSupportsDesignMode, IObjectPermission
- public bool AllowIdentity { get; }
- public string Collation { get; }
- public string Default { get; set; }
- public string DefaultSchema { get; set; }
- public ExtendedPropertyCollection ExtendedProperties { get; }
- public int ID { get; }
- public bool IsSchemaOwned { get; }
- public int Length { get; set; }
- public short MaxLength { get; }
- public bool Nullable { get; set; }
- public int NumericPrecision { get; set; }
- public int NumericScale { get; set; }
- public string Owner { get; set; }
- public Database Parent { get; set; }
- public string Rule { get; set; }
- public string RuleSchema { get; set; }
- public string SystemType { get; set; }
- public bool VariableLength { get; }
- public UserDefinedDataType()
- public UserDefinedDataType(Database database, string name)
- public UserDefinedDataType(Database database, string name, string schema)
- public void Alter()
- public void BindDefault(string defaultSchema, string defaultName)
- public void BindDefault(string defaultSchema, string defaultName, bool bindColumns)
- public void BindRule(string ruleSchema, string ruleName)
- public void BindRule(string ruleSchema, string ruleName, bool bindColumns)
- public void Create()
- public void Deny(ObjectPermissionSet permission, string[] granteeNames)
- public void Deny(ObjectPermissionSet permission, string[] granteeNames, bool cascade)
- public void Deny(ObjectPermissionSet permission, string granteeName)
- public void Deny(ObjectPermissionSet permission, string granteeName, bool cascade)
- public void Drop()
- public SqlSmoObject[] EnumBoundColumns()
- public ObjectPermissionInfo[] EnumObjectPermissions()
- public ObjectPermissionInfo[] EnumObjectPermissions(string granteeName)
- public ObjectPermissionInfo[] EnumObjectPermissions(ObjectPermissionSet permissions)
- public ObjectPermissionInfo[] EnumObjectPermissions(string granteeName, ObjectPermissionSet permissions)
- public void Grant(ObjectPermissionSet permission, string[] granteeNames)
- public void Grant(ObjectPermissionSet permission, string[] granteeNames, bool grantGrant)
- public void Grant(ObjectPermissionSet permission, string[] granteeNames, bool grantGrant, string asRole)
- public void Grant(ObjectPermissionSet permission, string granteeName)
- public void Grant(ObjectPermissionSet permission, string granteeName, bool grantGrant)
- public void Grant(ObjectPermissionSet permission, string granteeName, bool grantGrant, string asRole)
- public void Rename(string newname)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames, bool revokeGrant, bool cascade)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames, bool revokeGrant, bool cascade, string asRole)
- public void Revoke(ObjectPermissionSet permission, string granteeName)
- public void Revoke(ObjectPermissionSet permission, string granteeName, bool revokeGrant, bool cascade)
- public void Revoke(ObjectPermissionSet permission, string granteeName, bool revokeGrant, bool cascade, string asRole)
- public StringCollection Script()
- public StringCollection Script(ScriptingOptions scriptingOptions)
- public void UnbindDefault()
- public void UnbindDefault(bool bindColumns)
- public void UnbindRule()
- public void UnbindRule(bool bindColumns)
-
public sealed class UserDefinedDataTypeCollection : SchemaCollectionBase
-
public class UserDefinedDataTypeResolver
-
public sealed class UserDefinedFunction : ScriptSchemaObjectBase, ICreatable, IAlterable, IRenamable, IDroppable, IExtendedProperties, IScriptable, ITextObject, ISfcSupportsDesignMode, IColumnPermission, IObjectPermission
- public bool AnsiNullsStatus { get; set; }
- public string AssemblyName { get; set; }
- public CheckCollection Checks { get; }
- public string ClassName { get; set; }
- public ColumnCollection Columns { get; }
- public DateTime CreateDate { get; }
- public DataType DataType { get; set; }
- public DateTime DateLastModified { get; }
- public UserDefinedFunctionEvents Events { get; }
- public ExecutionContext ExecutionContext { get; set; }
- public string ExecutionContextPrincipal { get; set; }
- public ExtendedPropertyCollection ExtendedProperties { get; }
- public UserDefinedFunctionType FunctionType { get; set; }
- public int ID { get; }
- public ImplementationType ImplementationType { get; set; }
- public IndexCollection Indexes { get; }
- public bool IsDeterministic { get; }
- public bool IsEncrypted { get; set; }
- public bool IsSchemaBound { get; set; }
- public bool IsSchemaOwned { get; }
- public bool IsSystemObject { get; }
- public string MethodName { get; set; }
- public OrderColumnCollection OrderColumns { get; }
- public string Owner { get; set; }
- public UserDefinedFunctionParameterCollection Parameters { get; }
- public Database Parent { get; set; }
- public bool QuotedIdentifierStatus { get; set; }
- public bool ReturnsNullOnNullInput { get; set; }
- public string TableVariableName { get; set; }
- public string TextBody { get; set; }
- public string { get; set; }
- public bool TextMode { get; set; }
- public UserDefinedFunction()
- public UserDefinedFunction(Database database, string name)
- public UserDefinedFunction(Database database, string name, string schema)
- public void Alter()
- public void ChangeSchema(string newSchema)
- public void Create()
- public void Deny(ObjectPermissionSet permission, string[] granteeNames)
- public void Deny(ObjectPermissionSet permission, string[] granteeNames, bool cascade)
- public void Deny(ObjectPermissionSet permission, string granteeName)
- public void Deny(ObjectPermissionSet permission, string granteeName, bool cascade)
- public void Deny(ObjectPermissionSet permission, string[] granteeNames, string[] columnNames)
- public void Deny(ObjectPermissionSet permission, string[] granteeNames, string[] columnNames, bool cascade)
- public void Deny(ObjectPermissionSet permission, string granteeName, string[] columnNames)
- public void Deny(ObjectPermissionSet permission, string granteeName, string[] columnNames, bool cascade)
- public void Drop()
- public ObjectPermissionInfo[] EnumColumnPermissions()
- public ObjectPermissionInfo[] EnumColumnPermissions(string granteeName)
- public ObjectPermissionInfo[] EnumColumnPermissions(ObjectPermissionSet permissions)
- public ObjectPermissionInfo[] EnumColumnPermissions(string granteeName, ObjectPermissionSet permissions)
- public ObjectPermissionInfo[] EnumObjectPermissions()
- public ObjectPermissionInfo[] EnumObjectPermissions(string granteeName)
- public ObjectPermissionInfo[] EnumObjectPermissions(ObjectPermissionSet permissions)
- public ObjectPermissionInfo[] EnumObjectPermissions(string granteeName, ObjectPermissionSet permissions)
- public void Grant(ObjectPermissionSet permission, string[] granteeNames)
- public void Grant(ObjectPermissionSet permission, string[] granteeNames, bool grantGrant)
- public void Grant(ObjectPermissionSet permission, string[] granteeNames, bool grantGrant, string asRole)
- public void Grant(ObjectPermissionSet permission, string granteeName)
- public void Grant(ObjectPermissionSet permission, string granteeName, bool grantGrant)
- public void Grant(ObjectPermissionSet permission, string granteeName, bool grantGrant, string asRole)
- public void Grant(ObjectPermissionSet permission, string[] granteeNames, string[] columnNames)
- public void Grant(ObjectPermissionSet permission, string[] granteeNames, string[] columnNames, bool grantGrant)
- public void Grant(ObjectPermissionSet permission, string[] granteeNames, string[] columnNames, bool grantGrant, string asRole)
- public void Grant(ObjectPermissionSet permission, string granteeName, string[] columnNames)
- public void Grant(ObjectPermissionSet permission, string granteeName, string[] columnNames, bool grantGrant)
- public void Grant(ObjectPermissionSet permission, string granteeName, string[] columnNames, bool grantGrant, string asRole)
- public void Rename(string newname)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames, bool revokeGrant, bool cascade)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames, bool revokeGrant, bool cascade, string asRole)
- public void Revoke(ObjectPermissionSet permission, string granteeName)
- public void Revoke(ObjectPermissionSet permission, string granteeName, bool revokeGrant, bool cascade)
- public void Revoke(ObjectPermissionSet permission, string granteeName, bool revokeGrant, bool cascade, string asRole)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames, string[] columnNames)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames, string[] columnNames, bool revokeGrant, bool cascade)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames, string[] columnNames, bool revokeGrant, bool cascade, string asRole)
- public void Revoke(ObjectPermissionSet permission, string granteeName, string[] columnNames)
- public void Revoke(ObjectPermissionSet permission, string granteeName, string[] columnNames, bool revokeGrant, bool cascade)
- public void Revoke(ObjectPermissionSet permission, string granteeName, string[] columnNames, bool revokeGrant, bool cascade, string asRole)
- public StringCollection Script()
- public StringCollection Script(ScriptingOptions scriptingOptions)
- public string (bool forAlter)
-
public sealed class UserDefinedFunctionCollection : SchemaCollectionBase
-
public sealed class UserDefinedFunctionEvent
-
public class UserDefinedFunctionEvents
-
public sealed class UserDefinedFunctionEventSet : EventSetBase
-
public sealed class UserDefinedFunctionParameter : Parameter, ISfcSupportsDesignMode
-
public sealed class UserDefinedFunctionParameterCollection : ParameterCollectionBase
-
public sealed class UserDefinedMessage : MessageObjectBase, ICreatable, IDroppable, IAlterable, IScriptable
- public int ID { get; set; }
- public bool IsLogged { get; set; }
- public string Language { get; set; }
- public int LanguageID { get; set; }
- public Server Parent { get; set; }
- public int Severity { get; set; }
- public string Text { get; set; }
- public UserDefinedMessage()
- public UserDefinedMessage(Server server, int id)
- public UserDefinedMessage(Server server, int id, string language)
- public UserDefinedMessage(Server server, int id, string language, int severity, string message)
- public UserDefinedMessage(Server server, int id, string language, int severity, string message, bool isLogged)
- public UserDefinedMessage(Server server, int id, int language, int severity, string message)
- public UserDefinedMessage(Server server, int id, int language, int severity, string message, bool isLogged)
- public void Alter()
- public void Create()
- public void Drop()
- public StringCollection Script()
- public StringCollection Script(ScriptingOptions scriptingOptions)
-
public sealed class UserDefinedMessageCollection : MessageCollectionBase
-
public sealed class UserDefinedTableType : TableViewTableTypeBase, ICreatable, IAlterable, IRenamable, IDroppable, IScriptable, IExtendedProperties, ISfcSupportsDesignMode, IObjectPermission
- public CheckCollection Checks { get; }
- public string Collation { get; }
- public DateTime CreateDate { get; }
- public DateTime DateLastModified { get; }
- public int ID { get; }
- public bool IsSchemaOwned { get; }
- public bool IsUserDefined { get; set; }
- public short MaxLength { get; }
- public bool Nullable { get; set; }
- public string Owner { get; set; }
- public Database Parent { get; set; }
- public UserDefinedTableType()
- public UserDefinedTableType(Database database, string name)
- public UserDefinedTableType(Database database, string name, string schema)
- public void Alter()
- public void Create()
- public void Deny(ObjectPermissionSet permission, string[] granteeNames)
- public void Deny(ObjectPermissionSet permission, string[] granteeNames, bool cascade)
- public void Deny(ObjectPermissionSet permission, string granteeName)
- public void Deny(ObjectPermissionSet permission, string granteeName, bool cascade)
- public void Drop()
- public ObjectPermissionInfo[] EnumObjectPermissions()
- public ObjectPermissionInfo[] EnumObjectPermissions(string granteeName)
- public ObjectPermissionInfo[] EnumObjectPermissions(ObjectPermissionSet permissions)
- public ObjectPermissionInfo[] EnumObjectPermissions(string granteeName, ObjectPermissionSet permissions)
- public void Grant(ObjectPermissionSet permission, string[] granteeNames)
- public void Grant(ObjectPermissionSet permission, string[] granteeNames, bool grantGrant)
- public void Grant(ObjectPermissionSet permission, string[] granteeNames, bool grantGrant, string asRole)
- public void Grant(ObjectPermissionSet permission, string granteeName)
- public void Grant(ObjectPermissionSet permission, string granteeName, bool grantGrant)
- public void Grant(ObjectPermissionSet permission, string granteeName, bool grantGrant, string asRole)
- public void Rename(string newname)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames, bool revokeGrant, bool cascade)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames, bool revokeGrant, bool cascade, string asRole)
- public void Revoke(ObjectPermissionSet permission, string granteeName)
- public void Revoke(ObjectPermissionSet permission, string granteeName, bool revokeGrant, bool cascade)
- public void Revoke(ObjectPermissionSet permission, string granteeName, bool revokeGrant, bool cascade, string asRole)
- public StringCollection Script()
- public StringCollection Script(ScriptingOptions so)
-
public sealed class UserDefinedTableTypeCollection : SchemaCollectionBase
-
public class UserDefinedTableTypeResolver
-
public sealed class UserDefinedType : ScriptSchemaObjectBase, ISfcSupportsDesignMode, IObjectPermission, ICreatable, IDroppable, IExtendedProperties, IScriptable, IAlterable
- public string AssemblyName { get; set; }
- public byte[] BinaryTypeIdentifier { get; }
- public string ClassName { get; set; }
- public string Collation { get; }
- public UserDefinedTypeEvents Events { get; }
- public ExtendedPropertyCollection ExtendedProperties { get; }
- public int ID { get; }
- public bool IsBinaryOrdered { get; }
- public bool IsComVisible { get; }
- public bool IsFixedLength { get; }
- public bool IsNullable { get; }
- public bool IsSchemaOwned { get; }
- public int MaxLength { get; }
- public int NumericPrecision { get; }
- public int NumericScale { get; }
- public string Owner { get; set; }
- public Database Parent { get; set; }
- public UserDefinedTypeFormat UserDefinedTypeFormat { get; }
- public UserDefinedType()
- public UserDefinedType(Database database, string name)
- public UserDefinedType(Database database, string name, string schema)
- public void Alter()
- public void ChangeSchema(string newSchema)
- public void Create()
- public void Deny(ObjectPermissionSet permission, string[] granteeNames)
- public void Deny(ObjectPermissionSet permission, string[] granteeNames, bool cascade)
- public void Deny(ObjectPermissionSet permission, string granteeName)
- public void Deny(ObjectPermissionSet permission, string granteeName, bool cascade)
- public void Drop()
- public ObjectPermissionInfo[] EnumObjectPermissions()
- public ObjectPermissionInfo[] EnumObjectPermissions(string granteeName)
- public ObjectPermissionInfo[] EnumObjectPermissions(ObjectPermissionSet permissions)
- public ObjectPermissionInfo[] EnumObjectPermissions(string granteeName, ObjectPermissionSet permissions)
- public void Grant(ObjectPermissionSet permission, string[] granteeNames)
- public void Grant(ObjectPermissionSet permission, string[] granteeNames, bool grantGrant)
- public void Grant(ObjectPermissionSet permission, string[] granteeNames, bool grantGrant, string asRole)
- public void Grant(ObjectPermissionSet permission, string granteeName)
- public void Grant(ObjectPermissionSet permission, string granteeName, bool grantGrant)
- public void Grant(ObjectPermissionSet permission, string granteeName, bool grantGrant, string asRole)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames, bool revokeGrant, bool cascade)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames, bool revokeGrant, bool cascade, string asRole)
- public void Revoke(ObjectPermissionSet permission, string granteeName)
- public void Revoke(ObjectPermissionSet permission, string granteeName, bool revokeGrant, bool cascade)
- public void Revoke(ObjectPermissionSet permission, string granteeName, bool revokeGrant, bool cascade, string asRole)
- public StringCollection Script()
- public StringCollection Script(ScriptingOptions scriptingOptions)
-
public sealed class UserDefinedTypeCollection : SchemaCollectionBase
-
public class UserDefinedTypeEvents
-
public class UserDefinedTypeResolver
-
public class UserEvents
-
public sealed class UserOptions : SqlSmoObject, IAlterable, IScriptable, ISfcSupportsDesignMode
-
public class VersionSerializationAdapter : IXmlSerializationAdapter
-
public sealed class View : TableViewBase, ISfcSupportsDesignMode, IColumnPermission, IObjectPermission, ICreatable, IAlterable, IDroppable, IRenamable, IExtendedProperties, ITextObject, IViewOptions, IDmfFacet
- public bool AnsiNullsStatus { get; set; }
- public DateTime CreateDate { get; }
- public DateTime DateLastModified { get; }
- public ViewEvents Events { get; }
- public bool HasAfterTrigger { get; }
- public bool HasColumnSpecification { get; }
- public bool HasDeleteTrigger { get; }
- public bool HasIndex { get; }
- public bool HasInsertTrigger { get; }
- public bool HasInsteadOfTrigger { get; }
- public bool HasUpdateTrigger { get; }
- public int ID { get; }
- public bool IsEncrypted { get; set; }
- public bool IsIndexable { get; }
- public bool IsSchemaBound { get; set; }
- public bool IsSchemaOwned { get; }
- public bool IsSystemObject { get; }
- public string Owner { get; set; }
- public Database Parent { get; set; }
- public bool QuotedIdentifierStatus { get; set; }
- public bool ReturnsViewMetadata { get; set; }
- public string TextBody { get; set; }
- public string { get; set; }
- public bool TextMode { get; set; }
- public View()
- public View(Database database, string name)
- public View(Database database, string name, string schema)
- public void Alter()
- public void ChangeSchema(string newSchema)
- public void Create()
- public void Deny(ObjectPermissionSet permission, string[] granteeNames)
- public void Deny(ObjectPermissionSet permission, string[] granteeNames, bool cascade)
- public void Deny(ObjectPermissionSet permission, string granteeName)
- public void Deny(ObjectPermissionSet permission, string granteeName, bool cascade)
- public void Deny(ObjectPermissionSet permission, string[] granteeNames, string[] columnNames)
- public void Deny(ObjectPermissionSet permission, string[] granteeNames, string[] columnNames, bool cascade)
- public void Deny(ObjectPermissionSet permission, string granteeName, string[] columnNames)
- public void Deny(ObjectPermissionSet permission, string granteeName, string[] columnNames, bool cascade)
- public void Drop()
- public ObjectPermissionInfo[] EnumColumnPermissions()
- public ObjectPermissionInfo[] EnumColumnPermissions(string granteeName)
- public ObjectPermissionInfo[] EnumColumnPermissions(ObjectPermissionSet permissions)
- public ObjectPermissionInfo[] EnumColumnPermissions(string granteeName, ObjectPermissionSet permissions)
- public DataTable EnumColumns()
- public ObjectPermissionInfo[] EnumObjectPermissions()
- public ObjectPermissionInfo[] EnumObjectPermissions(string granteeName)
- public ObjectPermissionInfo[] EnumObjectPermissions(ObjectPermissionSet permissions)
- public ObjectPermissionInfo[] EnumObjectPermissions(string granteeName, ObjectPermissionSet permissions)
- public void Grant(ObjectPermissionSet permission, string[] granteeNames)
- public void Grant(ObjectPermissionSet permission, string[] granteeNames, bool grantGrant)
- public void Grant(ObjectPermissionSet permission, string[] granteeNames, bool grantGrant, string asRole)
- public void Grant(ObjectPermissionSet permission, string granteeName)
- public void Grant(ObjectPermissionSet permission, string granteeName, bool grantGrant)
- public void Grant(ObjectPermissionSet permission, string granteeName, bool grantGrant, string asRole)
- public void Grant(ObjectPermissionSet permission, string[] granteeNames, string[] columnNames)
- public void Grant(ObjectPermissionSet permission, string[] granteeNames, string[] columnNames, bool grantGrant)
- public void Grant(ObjectPermissionSet permission, string[] granteeNames, string[] columnNames, bool grantGrant, string asRole)
- public void Grant(ObjectPermissionSet permission, string granteeName, string[] columnNames)
- public void Grant(ObjectPermissionSet permission, string granteeName, string[] columnNames, bool grantGrant)
- public void Grant(ObjectPermissionSet permission, string granteeName, string[] columnNames, bool grantGrant, string asRole)
- public void Refresh(bool refreshViewMetadata)
- public void Rename(string newName)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames, bool revokeGrant, bool cascade)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames, bool revokeGrant, bool cascade, string asRole)
- public void Revoke(ObjectPermissionSet permission, string granteeName)
- public void Revoke(ObjectPermissionSet permission, string granteeName, bool revokeGrant, bool cascade)
- public void Revoke(ObjectPermissionSet permission, string granteeName, bool revokeGrant, bool cascade, string asRole)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames, string[] columnNames)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames, string[] columnNames, bool revokeGrant, bool cascade)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames, string[] columnNames, bool revokeGrant, bool cascade, string asRole)
- public void Revoke(ObjectPermissionSet permission, string granteeName, string[] columnNames)
- public void Revoke(ObjectPermissionSet permission, string granteeName, string[] columnNames, bool revokeGrant, bool cascade)
- public void Revoke(ObjectPermissionSet permission, string granteeName, string[] columnNames, bool revokeGrant, bool cascade, string asRole)
- public string (bool forAlter)
-
public sealed class ViewCollection : SchemaCollectionBase
-
public sealed class ViewEvent
-
public class ViewEvents
-
public sealed class ViewEventSet : EventSetBase
-
public sealed class WorkloadGroup : ScriptNameObjectBase, ISfcSupportsDesignMode, ICreatable, IDroppable, IAlterable, IScriptable
-
public sealed class WorkloadGroupCollection : SimpleObjectCollectionBase
-
public sealed class WrongPropertyValueException : SmoException
-
public sealed class XmlSchemaCollection : ScriptSchemaObjectBase, ISfcSupportsDesignMode, IObjectPermission, ICreatable, IDroppable, IAlterable, IScriptable, IExtendedProperties
- public DateTime CreateDate { get; }
- public DateTime DateLastModified { get; }
- public ExtendedPropertyCollection ExtendedProperties { get; }
- public int ID { get; }
- public Database Parent { get; set; }
- public string Text { get; set; }
- public XmlSchemaCollection()
- public XmlSchemaCollection(Database database, string name)
- public XmlSchemaCollection(Database database, string name, string schema)
- public XmlSchemaCollection(Database database, string name, string schema, string xmlSchemaDocument)
- public void AddSchemaDocument(string xmlSchemaDocument)
- public void Alter()
- public void Create()
- public void Deny(ObjectPermissionSet permission, string[] granteeNames)
- public void Deny(ObjectPermissionSet permission, string[] granteeNames, bool cascade)
- public void Deny(ObjectPermissionSet permission, string granteeName)
- public void Deny(ObjectPermissionSet permission, string granteeName, bool cascade)
- public void Drop()
- public DataTable EnumNamespaces()
- public ObjectPermissionInfo[] EnumObjectPermissions()
- public ObjectPermissionInfo[] EnumObjectPermissions(string granteeName)
- public ObjectPermissionInfo[] EnumObjectPermissions(ObjectPermissionSet permissions)
- public ObjectPermissionInfo[] EnumObjectPermissions(string granteeName, ObjectPermissionSet permissions)
- public DataTable EnumTypes()
- public DataTable EnumTypes(string xmlNamespace)
- public void Grant(ObjectPermissionSet permission, string[] granteeNames)
- public void Grant(ObjectPermissionSet permission, string[] granteeNames, bool grantGrant)
- public void Grant(ObjectPermissionSet permission, string[] granteeNames, bool grantGrant, string asRole)
- public void Grant(ObjectPermissionSet permission, string granteeName)
- public void Grant(ObjectPermissionSet permission, string granteeName, bool grantGrant)
- public void Grant(ObjectPermissionSet permission, string granteeName, bool grantGrant, string asRole)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames, bool revokeGrant, bool cascade)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames, bool revokeGrant, bool cascade, string asRole)
- public void Revoke(ObjectPermissionSet permission, string granteeName)
- public void Revoke(ObjectPermissionSet permission, string granteeName, bool revokeGrant, bool cascade)
- public void Revoke(ObjectPermissionSet permission, string granteeName, bool revokeGrant, bool cascade, string asRole)
- public StringCollection Script()
- public StringCollection Script(ScriptingOptions scriptingOptions)
-
public sealed class XmlSchemaCollectionCollection : SchemaCollectionBase
Microsoft.SqlServer.Management.Smo.Agent
-
public class AgentObjectBase : NamedSmoObject
-
public sealed class Alert : AgentObjectBase, ICreatable, IDroppable, IAlterable, IRenamable, IScriptable
-
public sealed class AlertCategory : CategoryBase
-
public sealed class AlertCategoryCollection : SimpleObjectCollectionBase
-
public sealed class AlertCollection : SimpleObjectCollectionBase
-
public sealed class AlertSystem : AgentObjectBase, IAlterable, IScriptable
-
public class CategoryBase : AgentObjectBase, ICreatable, IDroppable, IRenamable, IScriptable
-
public enum FindOperand
-
public sealed class Job : AgentObjectBase, IAlterable, ICreatable, IDroppable, IRenamable, IScriptable
-
public sealed class JobCategory : CategoryBase
-
public sealed class JobCategoryCollection : SimpleObjectCollectionBase
-
public class JobCollection : ArrayListCollectionBase
-
public sealed class JobFilter
-
public sealed class JobHistoryFilter
-
public sealed class JobSchedule : ScheduleBase, IAlterable, ICreatable, IDroppable, IRenamable, IScriptable
-
public sealed class JobScheduleCollection : JobScheduleCollectionBase
-
public sealed class JobServer : SqlSmoObject, IAlterable, IScriptable
-
public sealed class JobStep : AgentObjectBase, IAlterable, ICreatable, IDroppable, IRenamable, IScriptable
-
public sealed class JobStepCollection : ParameterCollectionBase
-
public enum NotifyType
-
public sealed class Operator : AgentObjectBase, ICreatable, IDroppable, IAlterable, IRenamable, IScriptable
-
public sealed class OperatorCategory : CategoryBase
-
public sealed class OperatorCategoryCollection : SimpleObjectCollectionBase
-
public sealed class OperatorCollection : SimpleObjectCollectionBase
-
public sealed class ProxyAccount : AgentObjectBase, IAlterable, ICreatable, IDroppable, IRenamable, IScriptable
- public int CredentialID { get; }
- public string CredentialIdentity { get; }
- public string CredentialName { get; set; }
- public string Description { get; set; }
- public int ID { get; }
- public bool IsEnabled { get; set; }
- public JobServer Parent { get; set; }
- public ProxyAccount()
- public ProxyAccount(JobServer jobServer, string name)
- public ProxyAccount(JobServer jobServer, string proxyName, string credentialName, bool enabled, string description)
- public ProxyAccount(JobServer jobServer, string proxyName, string credentialName, bool enabled)
- public ProxyAccount(JobServer jobServer, string proxyName, string credentialName)
- public void AddLogin(string loginName)
- public void AddMsdbRole(string msdbRoleName)
- public void AddServerRole(string serverRoleName)
- public void AddSubSystem(AgentSubSystem subSystem)
- public void Alter()
- public void Create()
- public void Drop()
- public DataTable EnumLogins()
- public DataTable EnumMsdbRoles()
- public DataTable EnumServerRoles()
- public DataTable EnumSubSystems()
- public void Reassign(string targetProxyAccountName)
- public void RemoveLogin(string loginName)
- public void RemoveMsdbRole(string msdbRoleName)
- public void RemoveServerRole(string serverRoleName)
- public void RemoveSubSystem(AgentSubSystem subSystem)
- public void Rename(string newName)
- public StringCollection Script()
- public StringCollection Script(ScriptingOptions scriptingOptions)
-
public sealed class ProxyAccountCollection : SimpleObjectCollectionBase
-
public class ScheduleBase : AgentObjectBase
- public int ID { get; }
- protected void SetId(int id)
-
public sealed class TargetServer : AgentObjectBase
-
public sealed class TargetServerCollection : SimpleObjectCollectionBase
-
public sealed class TargetServerGroup : AgentObjectBase, ICreatable, IDroppable, IRenamable
-
public sealed class TargetServerGroupCollection : SimpleObjectCollectionBase
Microsoft.SqlServer.Management.Smo.Broker
-
public class BrokerObjectBase : ScriptNameObjectBase, IScriptable
-
public sealed class BrokerPriority : BrokerObjectBase, IObjectPermission, ICreatable, IAlterable, IDroppable, IScriptable
- public string ContractName { get; set; }
- public int ID { get; }
- public string LocalServiceName { get; set; }
- public ServiceBroker Parent { get; set; }
- public byte PriorityLevel { get; set; }
- public string RemoteServiceName { get; set; }
- public BrokerPriority()
- public BrokerPriority(ServiceBroker serviceBroker, string name)
- public void Alter()
- public void Create()
- public void Deny(ObjectPermissionSet permission, string[] granteeNames)
- public void Deny(ObjectPermissionSet permission, string[] granteeNames, bool cascade)
- public void Deny(ObjectPermissionSet permission, string granteeName)
- public void Deny(ObjectPermissionSet permission, string granteeName, bool cascade)
- public void Drop()
- public ObjectPermissionInfo[] EnumObjectPermissions()
- public ObjectPermissionInfo[] EnumObjectPermissions(string granteeName)
- public ObjectPermissionInfo[] EnumObjectPermissions(ObjectPermissionSet permissions)
- public ObjectPermissionInfo[] EnumObjectPermissions(string granteeName, ObjectPermissionSet permissions)
- public void Grant(ObjectPermissionSet permission, string[] granteeNames)
- public void Grant(ObjectPermissionSet permission, string[] granteeNames, bool grantGrant)
- public void Grant(ObjectPermissionSet permission, string[] granteeNames, bool grantGrant, string asRole)
- public void Grant(ObjectPermissionSet permission, string granteeName)
- public void Grant(ObjectPermissionSet permission, string granteeName, bool grantGrant)
- public void Grant(ObjectPermissionSet permission, string granteeName, bool grantGrant, string asRole)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames, bool revokeGrant, bool cascade)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames, bool revokeGrant, bool cascade, string asRole)
- public void Revoke(ObjectPermissionSet permission, string granteeName)
- public void Revoke(ObjectPermissionSet permission, string granteeName, bool revokeGrant, bool cascade)
- public void Revoke(ObjectPermissionSet permission, string granteeName, bool revokeGrant, bool cascade, string asRole)
-
public sealed class BrokerPriorityCollection : SimpleObjectCollectionBase
-
public class BrokerPriorityExtender : SmoObjectExtender<BrokerPriority>, ISfcValidate
-
public sealed class BrokerService : BrokerObjectBase, IObjectPermission, IExtendedProperties, ICreatable, IAlterable, IDroppable
- public BrokerServiceEvents Events { get; }
- public ExtendedPropertyCollection ExtendedProperties { get; }
- public int ID { get; }
- public bool IsSystemObject { get; }
- public string Owner { get; set; }
- public ServiceBroker Parent { get; set; }
- public string QueueName { get; set; }
- public string QueueSchema { get; set; }
- public ServiceContractMappingCollection ServiceContractMappings { get; }
- public BrokerService()
- public BrokerService(ServiceBroker serviceBroker, string name)
- public void Alter()
- public void Create()
- public void Deny(ObjectPermissionSet permission, string[] granteeNames)
- public void Deny(ObjectPermissionSet permission, string[] granteeNames, bool cascade)
- public void Deny(ObjectPermissionSet permission, string granteeName)
- public void Deny(ObjectPermissionSet permission, string granteeName, bool cascade)
- public void Drop()
- public ObjectPermissionInfo[] EnumObjectPermissions()
- public ObjectPermissionInfo[] EnumObjectPermissions(string granteeName)
- public ObjectPermissionInfo[] EnumObjectPermissions(ObjectPermissionSet permissions)
- public ObjectPermissionInfo[] EnumObjectPermissions(string granteeName, ObjectPermissionSet permissions)
- public void Grant(ObjectPermissionSet permission, string[] granteeNames)
- public void Grant(ObjectPermissionSet permission, string[] granteeNames, bool grantGrant)
- public void Grant(ObjectPermissionSet permission, string[] granteeNames, bool grantGrant, string asRole)
- public void Grant(ObjectPermissionSet permission, string granteeName)
- public void Grant(ObjectPermissionSet permission, string granteeName, bool grantGrant)
- public void Grant(ObjectPermissionSet permission, string granteeName, bool grantGrant, string asRole)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames, bool revokeGrant, bool cascade)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames, bool revokeGrant, bool cascade, string asRole)
- public void Revoke(ObjectPermissionSet permission, string granteeName)
- public void Revoke(ObjectPermissionSet permission, string granteeName, bool revokeGrant, bool cascade)
- public void Revoke(ObjectPermissionSet permission, string granteeName, bool revokeGrant, bool cascade, string asRole)
-
public sealed class BrokerServiceCollection : SimpleObjectCollectionBase
-
public class BrokerServiceEvents
-
public class BrokerServiceExtender : SmoObjectExtender<BrokerService>, ISfcValidate
-
public sealed class MessageType : BrokerObjectBase, IObjectPermission, IExtendedProperties, ICreatable, IAlterable, IDroppable
- public MessageTypeEvents Events { get; }
- public ExtendedPropertyCollection ExtendedProperties { get; }
- public int ID { get; }
- public bool IsSystemObject { get; }
- public MessageTypeValidation MessageTypeValidation { get; set; }
- public string Owner { get; set; }
- public ServiceBroker Parent { get; set; }
- public string ValidationXmlSchemaCollection { get; set; }
- public string ValidationXmlSchemaCollectionSchema { get; set; }
- public MessageType()
- public MessageType(ServiceBroker serviceBroker, string name)
- public void Alter()
- public void Create()
- public void Deny(ObjectPermissionSet permission, string[] granteeNames)
- public void Deny(ObjectPermissionSet permission, string[] granteeNames, bool cascade)
- public void Deny(ObjectPermissionSet permission, string granteeName)
- public void Deny(ObjectPermissionSet permission, string granteeName, bool cascade)
- public void Drop()
- public ObjectPermissionInfo[] EnumObjectPermissions()
- public ObjectPermissionInfo[] EnumObjectPermissions(string granteeName)
- public ObjectPermissionInfo[] EnumObjectPermissions(ObjectPermissionSet permissions)
- public ObjectPermissionInfo[] EnumObjectPermissions(string granteeName, ObjectPermissionSet permissions)
- public void Grant(ObjectPermissionSet permission, string[] granteeNames)
- public void Grant(ObjectPermissionSet permission, string[] granteeNames, bool grantGrant)
- public void Grant(ObjectPermissionSet permission, string[] granteeNames, bool grantGrant, string asRole)
- public void Grant(ObjectPermissionSet permission, string granteeName)
- public void Grant(ObjectPermissionSet permission, string granteeName, bool grantGrant)
- public void Grant(ObjectPermissionSet permission, string granteeName, bool grantGrant, string asRole)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames, bool revokeGrant, bool cascade)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames, bool revokeGrant, bool cascade, string asRole)
- public void Revoke(ObjectPermissionSet permission, string granteeName)
- public void Revoke(ObjectPermissionSet permission, string granteeName, bool revokeGrant, bool cascade)
- public void Revoke(ObjectPermissionSet permission, string granteeName, bool revokeGrant, bool cascade, string asRole)
-
public sealed class MessageTypeCollection : SimpleObjectCollectionBase
-
public class MessageTypeEvents
-
public class MessageTypeExtender : SmoObjectExtender<MessageType>, ISfcValidate
-
public sealed class MessageTypeMapping : NamedSmoObject, ISfcSupportsDesignMode, IMarkForDrop
-
public sealed class MessageTypeMappingCollection : SimpleObjectCollectionBase
-
public sealed class RemoteServiceBinding : BrokerObjectBase, IObjectPermission, IExtendedProperties, ICreatable, IAlterable, IDroppable
- public string CertificateUser { get; set; }
- public RemoteServiceBindingEvents Events { get; }
- public ExtendedPropertyCollection ExtendedProperties { get; }
- public int ID { get; }
- public bool IsAnonymous { get; set; }
- public string Owner { get; set; }
- public ServiceBroker Parent { get; set; }
- public string RemoteService { get; set; }
- public RemoteServiceBinding()
- public RemoteServiceBinding(ServiceBroker serviceBroker, string name)
- public void Alter()
- public void Create()
- public void Deny(ObjectPermissionSet permission, string[] granteeNames)
- public void Deny(ObjectPermissionSet permission, string[] granteeNames, bool cascade)
- public void Deny(ObjectPermissionSet permission, string granteeName)
- public void Deny(ObjectPermissionSet permission, string granteeName, bool cascade)
- public void Drop()
- public ObjectPermissionInfo[] EnumObjectPermissions()
- public ObjectPermissionInfo[] EnumObjectPermissions(string granteeName)
- public ObjectPermissionInfo[] EnumObjectPermissions(ObjectPermissionSet permissions)
- public ObjectPermissionInfo[] EnumObjectPermissions(string granteeName, ObjectPermissionSet permissions)
- public void Grant(ObjectPermissionSet permission, string[] granteeNames)
- public void Grant(ObjectPermissionSet permission, string[] granteeNames, bool grantGrant)
- public void Grant(ObjectPermissionSet permission, string[] granteeNames, bool grantGrant, string asRole)
- public void Grant(ObjectPermissionSet permission, string granteeName)
- public void Grant(ObjectPermissionSet permission, string granteeName, bool grantGrant)
- public void Grant(ObjectPermissionSet permission, string granteeName, bool grantGrant, string asRole)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames, bool revokeGrant, bool cascade)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames, bool revokeGrant, bool cascade, string asRole)
- public void Revoke(ObjectPermissionSet permission, string granteeName)
- public void Revoke(ObjectPermissionSet permission, string granteeName, bool revokeGrant, bool cascade)
- public void Revoke(ObjectPermissionSet permission, string granteeName, bool revokeGrant, bool cascade, string asRole)
-
public sealed class RemoteServiceBindingCollection : SimpleObjectCollectionBase
-
public class RemoteServiceBindingEvents
-
public class RemoteServiceBindingExtender : SmoObjectExtender<RemoteServiceBinding>, ISfcValidate
-
public sealed class ServiceBroker : SqlSmoObject
-
public sealed class ServiceContract : BrokerObjectBase, IObjectPermission, IExtendedProperties, ICreatable, IAlterable, IDroppable
- public ServiceContractEvents Events { get; }
- public ExtendedPropertyCollection ExtendedProperties { get; }
- public int ID { get; }
- public bool IsSystemObject { get; }
- public MessageTypeMappingCollection MessageTypeMappings { get; }
- public string Owner { get; set; }
- public ServiceBroker Parent { get; set; }
- public ServiceContract()
- public ServiceContract(ServiceBroker serviceBroker, string name)
- public void Alter()
- public void Create()
- public void Deny(ObjectPermissionSet permission, string[] granteeNames)
- public void Deny(ObjectPermissionSet permission, string[] granteeNames, bool cascade)
- public void Deny(ObjectPermissionSet permission, string granteeName)
- public void Deny(ObjectPermissionSet permission, string granteeName, bool cascade)
- public void Drop()
- public ObjectPermissionInfo[] EnumObjectPermissions()
- public ObjectPermissionInfo[] EnumObjectPermissions(string granteeName)
- public ObjectPermissionInfo[] EnumObjectPermissions(ObjectPermissionSet permissions)
- public ObjectPermissionInfo[] EnumObjectPermissions(string granteeName, ObjectPermissionSet permissions)
- public void Grant(ObjectPermissionSet permission, string[] granteeNames)
- public void Grant(ObjectPermissionSet permission, string[] granteeNames, bool grantGrant)
- public void Grant(ObjectPermissionSet permission, string[] granteeNames, bool grantGrant, string asRole)
- public void Grant(ObjectPermissionSet permission, string granteeName)
- public void Grant(ObjectPermissionSet permission, string granteeName, bool grantGrant)
- public void Grant(ObjectPermissionSet permission, string granteeName, bool grantGrant, string asRole)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames, bool revokeGrant, bool cascade)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames, bool revokeGrant, bool cascade, string asRole)
- public void Revoke(ObjectPermissionSet permission, string granteeName)
- public void Revoke(ObjectPermissionSet permission, string granteeName, bool revokeGrant, bool cascade)
- public void Revoke(ObjectPermissionSet permission, string granteeName, bool revokeGrant, bool cascade, string asRole)
-
public sealed class ServiceContractCollection : SimpleObjectCollectionBase
-
public class ServiceContractEvents
-
public class ServiceContractExtender : SmoObjectExtender<ServiceContract>, ISfcValidate
-
public sealed class ServiceContractMapping : NamedSmoObject, ISfcSupportsDesignMode, IMarkForDrop
-
public sealed class ServiceContractMappingCollection : SimpleObjectCollectionBase
-
public sealed class ServiceQueue : ScriptSchemaObjectBase, ISfcSupportsDesignMode, IObjectPermission, IExtendedProperties, ICreatable, IAlterable, IDroppable, IScriptable
- public ActivationExecutionContext ActivationExecutionContext { get; set; }
- public DateTime CreateDate { get; }
- public DateTime DateLastModified { get; }
- public ServiceQueueEvents Events { get; }
- public string ExecutionContextPrincipal { get; set; }
- public ExtendedPropertyCollection ExtendedProperties { get; }
- public string FileGroup { get; set; }
- public int ID { get; }
- public bool IsActivationEnabled { get; set; }
- public bool IsEnqueueEnabled { get; set; }
- public bool IsPoisonMessageHandlingEnabled { get; set; }
- public bool IsRetentionEnabled { get; set; }
- public bool IsSystemObject { get; }
- public short MaxReaders { get; set; }
- public ServiceBroker Parent { get; set; }
- public string ProcedureDatabase { get; set; }
- public string ProcedureName { get; set; }
- public string ProcedureSchema { get; set; }
- public long RowCount { get; }
- public double RowCountAsDouble { get; }
- public ServiceQueue()
- public ServiceQueue(ServiceBroker serviceBroker, string name)
- public ServiceQueue(ServiceBroker serviceBroker, string name, string schema)
- public void Alter()
- public void Create()
- public void Deny(ObjectPermissionSet permission, string[] granteeNames)
- public void Deny(ObjectPermissionSet permission, string[] granteeNames, bool cascade)
- public void Deny(ObjectPermissionSet permission, string granteeName)
- public void Deny(ObjectPermissionSet permission, string granteeName, bool cascade)
- public void Drop()
- public ObjectPermissionInfo[] EnumObjectPermissions()
- public ObjectPermissionInfo[] EnumObjectPermissions(string granteeName)
- public ObjectPermissionInfo[] EnumObjectPermissions(ObjectPermissionSet permissions)
- public ObjectPermissionInfo[] EnumObjectPermissions(string granteeName, ObjectPermissionSet permissions)
- public void Grant(ObjectPermissionSet permission, string[] granteeNames)
- public void Grant(ObjectPermissionSet permission, string[] granteeNames, bool grantGrant)
- public void Grant(ObjectPermissionSet permission, string[] granteeNames, bool grantGrant, string asRole)
- public void Grant(ObjectPermissionSet permission, string granteeName)
- public void Grant(ObjectPermissionSet permission, string granteeName, bool grantGrant)
- public void Grant(ObjectPermissionSet permission, string granteeName, bool grantGrant, string asRole)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames, bool revokeGrant, bool cascade)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames, bool revokeGrant, bool cascade, string asRole)
- public void Revoke(ObjectPermissionSet permission, string granteeName)
- public void Revoke(ObjectPermissionSet permission, string granteeName, bool revokeGrant, bool cascade)
- public void Revoke(ObjectPermissionSet permission, string granteeName, bool revokeGrant, bool cascade, string asRole)
- public StringCollection Script()
- public StringCollection Script(ScriptingOptions scriptingOptions)
-
public sealed class ServiceQueueCollection : SchemaCollectionBase
-
public class ServiceQueueEvents
-
public class ServiceQueueExtender : SmoObjectExtender<ServiceQueue>, ISfcValidate
-
public sealed class ServiceRoute : BrokerObjectBase, IObjectPermission, IExtendedProperties, ICreatable, IAlterable, IDroppable
- public string Address { get; set; }
- public string BrokerInstance { get; set; }
- public ServiceRouteEvents Events { get; }
- public DateTime ExpirationDate { get; set; }
- public ExtendedPropertyCollection ExtendedProperties { get; }
- public int ID { get; }
- public string MirrorAddress { get; set; }
- public string Owner { get; set; }
- public ServiceBroker Parent { get; set; }
- public string RemoteService { get; set; }
- public ServiceRoute()
- public ServiceRoute(ServiceBroker serviceBroker, string name)
- public void Alter()
- public void Create()
- public void Deny(ObjectPermissionSet permission, string[] granteeNames)
- public void Deny(ObjectPermissionSet permission, string[] granteeNames, bool cascade)
- public void Deny(ObjectPermissionSet permission, string granteeName)
- public void Deny(ObjectPermissionSet permission, string granteeName, bool cascade)
- public void Drop()
- public ObjectPermissionInfo[] EnumObjectPermissions()
- public ObjectPermissionInfo[] EnumObjectPermissions(string granteeName)
- public ObjectPermissionInfo[] EnumObjectPermissions(ObjectPermissionSet permissions)
- public ObjectPermissionInfo[] EnumObjectPermissions(string granteeName, ObjectPermissionSet permissions)
- public void Grant(ObjectPermissionSet permission, string[] granteeNames)
- public void Grant(ObjectPermissionSet permission, string[] granteeNames, bool grantGrant)
- public void Grant(ObjectPermissionSet permission, string[] granteeNames, bool grantGrant, string asRole)
- public void Grant(ObjectPermissionSet permission, string granteeName)
- public void Grant(ObjectPermissionSet permission, string granteeName, bool grantGrant)
- public void Grant(ObjectPermissionSet permission, string granteeName, bool grantGrant, string asRole)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames, bool revokeGrant, bool cascade)
- public void Revoke(ObjectPermissionSet permission, string[] granteeNames, bool revokeGrant, bool cascade, string asRole)
- public void Revoke(ObjectPermissionSet permission, string granteeName)
- public void Revoke(ObjectPermissionSet permission, string granteeName, bool revokeGrant, bool cascade)
- public void Revoke(ObjectPermissionSet permission, string granteeName, bool revokeGrant, bool cascade, string asRole)
-
public sealed class ServiceRouteCollection : SimpleObjectCollectionBase
-
public class ServiceRouteEvents
-
public class ServiceRouteExtender : SmoObjectExtender<ServiceRoute>, ISfcValidate
Microsoft.SqlServer.Management.Smo.Mail
-
public sealed class ConfigurationValue : NamedSmoObject, IAlterable, IScriptable
-
public sealed class ConfigurationValueCollection : SimpleObjectCollectionBase
-
public sealed class MailAccount : ScriptNameObjectBase, IAlterable, ICreatable, IDroppable, IRenamable, IScriptable
-
public sealed class MailAccountCollection : SimpleObjectCollectionBase
-
public sealed class MailProfile : ScriptNameObjectBase, IAlterable, ICreatable, IDroppable, IRenamable, IScriptable
-
public sealed class MailProfileCollection : SimpleObjectCollectionBase
-
public sealed class MailServer : ScriptNameObjectBase, IRenamable, IAlterable, IScriptable
-
public sealed class MailServerCollection : SimpleObjectCollectionBase
-
public sealed class SqlMail : SqlSmoObject, IScriptable
ProviderImplementation.ProvidedTypes
Samples.FSharp.ProvidedTypes