Creating Models › Target Servers for Physical Models › Database Property Editors › SQL Server Property Editors › SQL Server Property Editors › Define a Database in SQL Server › Define SQL Server Files

Define SQL Server Files

Use the SQL Server File Editor to define the physical location of a file that is used in a database in a SQL Server physical model.

To define a SQL Server file

1. Click Target - SQL Server, Files on the Model menu.

   The SQL Server File Editor opens.

2. Select the file in the Navigation Grid that you want to define and work with the following options:

   Note: Click New on the toolbar to create a new file.

   Name

   Displays the file name. You can change the file name in this field.

   SQL Server Type

   Specifies the type of SQL Server file that it is. Select the SQL Server file type from the drop-down.

3. (Optional) Click the Comment tab and enter any comments that you want to associate with the object.
4. (Optional) Click the Where Used tab to view where the object is used within the model.
5. (Optional) Click the UDP tab to work with user-defined properties for the object.
6. (Optional) Click the Notes tab to view and edit user notes.
7. (Optional) Click the Extended Notes tab to view or edit user notes.
8. Click Close.

   The file is defined and the SQL Server File Editor closes.