Condividi tramite

  • Articolo

Metodo Script

Generates a Transact-SQL script that can be executed to create or delete the TransArticle object or the MergeArticle object on the server.

Spazio dei nomi:  Microsoft.SqlServer.Replication
Assembly:  Microsoft.SqlServer.Rmo (in Microsoft.SqlServer.Rmo.dll)

Sintassi

'Dichiarazione
Public Function Script ( _
    scriptOption As ScriptOptions _
) As String
'Utilizzo
Dim instance As Article
Dim scriptOption As ScriptOptions
Dim returnValue As String

returnValue = instance.Script(scriptOption)

public string Script(
    ScriptOptions scriptOption
)

public:
String^ Script(
    ScriptOptions scriptOption
)

member Script : 
        scriptOption:ScriptOptions -> string 

public function Script(
    scriptOption : ScriptOptions
) : String

Parametri

Valore restituito

Tipo: System. . :: . .String
A String value that contains the Transact-SQL script.

Osservazioni

The scriptOption parameter determines whether to return a creation script or a deletion script. The Script method can be used for an existing article on the server or it can be used before you create a new article on the server. For an existing article, call Load or LoadProperties to retrieve article properties from the server before calling Script.

You must specify a value of Creation or Deletion for ScriptOptions.

Any user can call the Script method. However, a script for an existing object on the server is returned only for members of the sysadmin fixed server role at the Publisher and at the Subscriber (for republishing Subscribers). A script also is returned for members of the db_owner fixed database role on the publication database and by users who are members of the PAL. For a MergeArticle object, a script will be returned for members of the replmonitor fixed database role on the Distributor.

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