Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
<LogicalName> Element (<FileSpec>)
Collapse the table of content
Expand the table of content

<LogicalName> Element (<FileSpec>)

SQL Server 2000

Specifies the logical name that will be used in SQL Server to refer to the filegroup defined in the <FileSpec> node.

Structure
<Database>
   <NamedFileGroup>
      ...
      <FileSpec>
         <LogicalName>

Element Characteristics
Characteristic Description
Data Type string, between 1 and 260 characters in length.
Default Value None.
Occurrence Required once per <FileSpec> node.
Updates Cannot be added, deleted, or modified.
Element Relationships
Relationship Elements
Parent Node <FileSpec> Node
Remarks

You must specify the logical name of the application database data file in the <LogicalName> element. The logical name is used to refer to the file in all Transact-SQL statements.

See Also
Defining a <NamedFileGroup> Node
Show:
© 2015 Microsoft