SqlAssembly Members

The SqlAssembly class represents an assembly in the Microsoft .NET environment.

The following tables list the members exposed by the SqlAssembly type.

Public Constructors

	Nombre	Description
	SqlAssembly	Overloaded. Initializes a new instance of the SqlAssembly class.

Arriba

Protected Fields

	Nombre	Description
	m_ExtendedProperties	(inherited from SqlSmoObject )

Arriba

Public Properties

(see also Protected Properties )

	Nombre	Description
	AssemblySecurityLevel	Gets or sets the security level for the assembly.
	CreateDate	Gets the date and time when the assembly was registered wit the database.
	Culture	Gets the culture information about the referenced assembly.
	Events	Gets the events associated with the referenced assembly.
	ExtendedProperties	References a collection of ExtendedProperty objects. Each ExtendedProperty object represents an extended property of the SqlAssembly object.
	ID	Gets the ID value that uniquely identifies the referenced assembly.
	IsVisible	Gets the Boolean property that specifies whether the assembly is visible after registration.
	Name	Gets or sets the name of the object. (inherited from NamedSmoObject)
	Owner	Gets or sets the user (principal) that is the owner of the referenced assembly.
	Parent	Gets or sets the Database object that is the parent of the SqlAssembly object.
	Properties	Gets a collection of Property objects that represent the object properties. (inherited from SqlSmoObject)
	PublicKey	Gets the public key of the referenced assembly.
	SqlAssemblyFiles	Represents a collection of SqlAssemblyFile objects. Each SqlAssemblyFile object represents an assembly file associated with the referenced assembly.
	State	Gets the state of the referenced object. (inherited from SmoObjectBase)
	Urn	Gets the Uniform Resource Name (URN) address value that uniquely identifies the object. (inherited from SqlSmoObject)
	UserData	Gets or sets user-defined data associated with the referenced object. (inherited from SmoObjectBase)
	Version	Gets the version value of the referenced assembly.

Arriba

Protected Properties

	Nombre	Description
	ExecuteForScalar	Gets or sets the Boolean property value that specifies whether the object is set to the execute for scalar option. (inherited from SqlSmoObject)
	ObjectInSpace	Gets the Boolean property value that specifies whether the object exists in isolation or whether it is connected to the instance of Microsoft SQL Server directly or indirectly. (inherited from SqlSmoObject)
	PresetProperties	Gets or sets the preset properties of the referenced object. (inherited from SqlSmoObject)
	ScalarResult	Gets the scalar result for the referenced object. (inherited from SqlSmoObject)

Arriba

Public Methods

(see also Protected Methods )

	Nombre	Description
	Alter	Overloaded. Updates any SqlAssembly object property changes on the instance of Microsoft SQL Server.
	Create	Overloaded. Creates an assembly on the instance of Microsoft SQL Server as defined by the SqlAssembly object.
	Deny	Overloaded. Denies the specified set of permissions for the specified grantees on the assembly.
	Drop	Removes the assembly from the instance of Microsoft SQL Server.
	EnumObjectPermissions	Overloaded. Enumerates a list of object permissions for the assembly.
	Equals	Overloaded. (inherited from Object )
	GetHashCode	(inherited from Object )
	GetType	(inherited from Object )
	Grant	Overloaded. Grants the specified set of permissions to the specified grantees on the assembly.
	Initialize	Overloaded. Initializes the object and forces the properties be loaded. (inherited from SqlSmoObject)
	ReferenceEquals	(inherited from Object )
	Refresh	Refreshes the script name. (inherited from ScriptNameObjectBase)
	Revoke	Overloaded. Revokes a previously granted set of permissions from a grantee or grantees on the assembly.
	Script	Overloaded. Generates a Transact-SQL script that can be used to re-create the assembly.
	ToString	Returns a String that represents the referenced object. (inherited from SqlSmoObject)

Arriba

Protected Methods

	Nombre	Description
	AlterImpl	(inherited from SqlSmoObject )
	AlterImplFinish	(inherited from SqlSmoObject )
	AlterImplInit	(inherited from SqlSmoObject )
	AlterImplWorker	(inherited from SqlSmoObject )
	AppendCommaText	(inherited from ScriptNameObjectBase )
	AppendWithCommaText	(inherited from ScriptNameObjectBase )
	AppendWithOption	(inherited from ScriptNameObjectBase )
	BindDefaultImpl	(inherited from SqlSmoObject )
	BindRuleImpl	(inherited from SqlSmoObject )
	CheckCollation	(inherited from SqlSmoObject )
	CheckObjectState	Overloaded. Validates the state of the referenced object. (inherited from SqlSmoObject)
	CheckObjectStateImpl	(inherited from SqlSmoObject )
	CheckTextCorectness	(inherited from ScriptNameObjectBase )
	CheckTextModeSupport	(inherited from ScriptNameObjectBase )
	CheckVersion80	Checks the validity of the object on Microsoft SQL Server 2000. (inherited from SqlSmoObject)
	CheckVersion80SP3	Checks the validity of the object on Microsoft SQL Server 2000 SP3. (inherited from SqlSmoObject)
	CheckVersion90	Check the validity of the object on Microsoft SQL Server 2005. (inherited from SqlSmoObject)
	CheckVersionBelow90	(inherited from SqlSmoObject )
	CleanObject	Cleans the referenced object. (inherited from ScriptNameObjectBase)
	CreateImpl	(inherited from SqlSmoObject )
	CreateImplFinish	(inherited from SqlSmoObject )
	CreateImplInit	(inherited from SqlSmoObject )
	DropImpl	(inherited from SqlSmoObject )
	DropImplWorker	(inherited from SqlSmoObject )
	Finalize	(inherited from Object )
	ForceTextModeOnTextBody	Enforces text mode on the text body. (inherited from ScriptNameObjectBase)
	FormatSqlVariant	(inherited from SqlSmoObject )
	GenerateDataSpaceScript	(inherited from SqlSmoObject )
	GetBindDefaultScript	(inherited from SqlSmoObject )
	GetBindRuleScript	(inherited from SqlSmoObject )
	GetBoolParameter	Overloaded. (inherited from SqlSmoObject )
	GetBraketNameForText	(inherited from ScriptNameObjectBase )
	GetDateTimeParameter	(inherited from SqlSmoObject )
	GetDateTimeParameterAsInt	(inherited from SqlSmoObject )
	GetDBName	Gets the database name associated with the object. (inherited from SqlSmoObject)
	GetEnumParameter	(inherited from SqlSmoObject )
	GetFragOptionString	(inherited from SqlSmoObject )
	GetGuidParameter	(inherited from SqlSmoObject )
	GetIsTextDirty	Determines whether the text value is consistent with stored value. (inherited from ScriptNameObjectBase)
	GetParameter	Overloaded. (inherited from SqlSmoObject )
	GetPropValue	(inherited from SqlSmoObject )
	GetPropValueOptional	(inherited from SqlSmoObject )
	GetPropValueOptionalAllowNull	(inherited from SqlSmoObject )
	GetRealValue	(inherited from SqlSmoObject )
	GetScriptIncludeExists	(inherited from ScriptNameObjectBase )
	GetScriptingOptionsForCreate	(inherited from SqlSmoObject )
	GetServerName	Gets the name of the instance of Microsoft SQL Server with which the object is associated. (inherited from SqlSmoObject)
	GetSqlServerVersionName	Gets the version name of the instance of Microsoft SQL Server with which the object is associated. (inherited from SqlSmoObject)
	GetStringParameter	Overloaded. (inherited from SqlSmoObject )
	GetTextBody	Overloaded. Returns the text body. (inherited from ScriptNameObjectBase)
	GetTextForScript	(inherited from ScriptNameObjectBase )
	GetTextHeader	(inherited from ScriptNameObjectBase )
	GetTextMode	Determines whether the script name is using text mode. (inherited from ScriptNameObjectBase)
	GetTextProperty	(inherited from ScriptNameObjectBase )
	GetTimeSpanParameterAsInt	(inherited from SqlSmoObject )
	GetUrnRecursive	Overloaded. (inherited from SqlSmoObject )
	ImplInitialize	(inherited from SqlSmoObject )
	IsCollectionDirty	(inherited from SqlSmoObject )
	IsObjectDirty	Determines whether the referenced object is consistent with the stored object. (inherited from ScriptNameObjectBase)
	IsObjectInitialized	Verifies whether the object has been initialized. (inherited from SqlSmoObject)
	IsObjectInSpace	Verifies whether the object is isolated or connected to the instance of Microsoft SQL Server. (inherited from SqlSmoObject)
	IsVersion80SP3	(inherited from SqlSmoObject )
	MarkDropped	(inherited from SqlSmoObject )
	MarkForDropImpl	(inherited from SqlSmoObject )
	MemberwiseClone	(inherited from Object )
	PostAlter	(inherited from SqlSmoObject )
	PostCreate	(inherited from SqlSmoObject )
	PostDrop	(inherited from SqlSmoObject )
	RenameImpl	(inherited from NamedSmoObject )
	RenameImplWorker	(inherited from NamedSmoObject )
	ScriptAlter	(inherited from SqlSmoObject )
	ScriptAnsiQI	(inherited from ScriptNameObjectBase )
	ScriptChangeOwner	(inherited from NamedSmoObject )
	ScriptCreate	(inherited from SqlSmoObject )
	ScriptDdl	(inherited from SqlSmoObject )
	ScriptDrop	(inherited from SqlSmoObject )
	ScriptImpl	Overloaded. (inherited from SqlSmoObject )
	ScriptImplWorker	(inherited from SqlSmoObject )
	ScriptInformativeHeaders	(inherited from ScriptNameObjectBase )
	ScriptRename	(inherited from NamedSmoObject )
	SetCollectionTextMode	(inherited from ScriptNameObjectBase )
	SetParentImpl	(inherited from SqlSmoObject )
	SetTextBody	(inherited from ScriptNameObjectBase )
	SetTextHeader	(inherited from ScriptNameObjectBase )
	SetTextMode	(inherited from ScriptNameObjectBase )
	SwitchTextMode	(inherited from ScriptNameObjectBase )
	ThrowIfTextIsDirtyForAlter	(inherited from ScriptNameObjectBase )
	Trace	(inherited from SqlSmoObject )
	UnbindDefaultImpl	(inherited from SqlSmoObject )
	UnbindRuleImpl	(inherited from SqlSmoObject )
	UpdateCollectionState2	(inherited from SqlSmoObject )

Arriba

Vea también

Referencia

SqlAssembly Class
Microsoft.SqlServer.Management.Smo Namespace

Otros recursos

CREATE ASSEMBLY (Transact-SQL)