Microsoft® SQL Server® 2012 Bible

810

Part V: Enterprise Data Management

3. In the list of objects in Figure 31-3, expand the Tables and Stored Procedures nodes,
   and select the following objects:

■ (^) Tables: Contact, Employee
■ Stored procedures: uspGetManagerEmployees

4. Click Next on the Choose Objects page.


5. On the Set Scripting Objects page, select the Save to New Query Window option, as
   shown in Figure 31-4, and then click the Advanced button.

FIGURE 31-4

Set Scripting Options.

Setting Advanced Options

Clicking the Advanced button brings up the Advanced Scripting Options dialog, as shown in

Figure 31-5. Select the following options:

c31.indd 810c31.indd 810 7/31/2012 10:00:24 AM7/31/2012 10:00:24 AM

http://www.it-ebooks.info