StoredProcedure.Script Method ()

Generates a Transact-SQL script that can be used to re-create the stored procedure. Generates a Transact-SQL script that can be used to re-create the OLE DB provider settings.

Namespace: Microsoft.SqlServer.Management.Smo
Assembly : Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)

Syntax

'Declaration
Public Function Script As StringCollection

public StringCollection Script ()

public:
virtual StringCollection^ Script () sealed

public final StringCollection Script ()

public final function Script () : StringCollection

Rückgabewert

A StringCollection system object value that contains a list of Transact-SQL statements in the script.

Rückgabewert

A StringCollection system object value that contains a list of Transact-SQL statements in the script.

Hinweise

Note   The generated script may contain undocumented, internal procedures, which are required for the complete script output.

Der Namespace, die Klasse oder das Element wird nur in der Version 2.0 von Microsoft .NET Framework unterstützt.

Hinweise

Note The generated script may contain undocumented, internal procedures, which are required for the complete script output.

This namespace, class, or member is supported only in version 2.0 of the Microsoft .NET Framework.

Beispiel

How to: Script Out the Dependencies for a Database in Visual Basic .NET

Beispiel

How to: Link to an OLE-DB Provider Server in Visual Basic .NET

Threadsicherheit

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Plattformen

Entwicklungsplattformen

Eine Liste der unterstützten Plattformen finden Sie unterHardware- und Softwareanforderungen für die Installation von SQL Server 2005.

Zielplattforme

Eine Liste der unterstützten Plattformen finden Sie unterHardware- und Softwareanforderungen für die Installation von SQL Server 2005.

Siehe auch

Verweis

StoredProcedure Class
StoredProcedure Members
Microsoft.SqlServer.Management.Smo Namespace

Andere Ressourcen

Scripting
CREATE PROCEDURE (Transact-SQL)
Using Linked Servers in SMO