This topic has not yet been rated - Rate this topic

ScriptingOptions.FileName Property

Gets or sets the name of the file to which the generated script is output.

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

Syntax

C++

JScript

Copy


public string FileName { get; set; }

Property Value

Type: System.String
A String value that specifies the name of the file to which the generated script is output.

Examples

The following code example sets the name of the scripts output file.

Visual Basic

Copy

Dim scOps As New ScriptingOptions()
scOps.FileName = "C:\Program Files\Microsoft SQL Server\100\DTS\ForEachEnumerators\SampleFileName.sql"

PowerShell

Copy

$scOps = New-Object Microsoft.SqlServer.Management.Smo.ScriptingOptions
$scOps.FileName = "C:\Program Files\Microsoft SQL Server\100\DTS\ForEachEnumerators\SampleFileName.sql"

Reference

ScriptingOptions Class

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Scripting

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Content Add

FAQ