Creating Models › Target Servers for Physical Models › Database Property Editors › SQL Server Property Editors › Common Property Pages › Browser Dialog for Functions, Script Templates, and Stored Procedures

Browser Dialog for Functions, Script Templates, and Stored Procedures

When you are in the Function Editor, Script Template Editor, or Stored Procedure Editor, you can click the Browser button to open the Browser dialog.

Use the browser to see the tables and views that are attached to a function, script template, or stored procedure, and to view the code used by a particular template. You can also attach tables and views in your model to existing functions, script templates, or stored procedures.

The following describes the options available for this browser:

Template Name/Template Code

Displays the name of each function template, script template, or stored procedure template in the model, with the first line of code from any of these templates. This field can include SQL statements and macros.

Unattached Object

Lists all tables and views in the model that are not attached to the selected function template, script template, or stored procedure template.

Attached Object

Lists the tables and views that are attached to the selected function template, script template, or stored procedure template.

Template (Read Only)

Displays the template code for the selected function template, script template, or stored procedure template.

Template Expansion (Read Only)

Displays the expanded template code for the selected function template, script template, or stored procedure template.