How To

How to create a SQL Server 7.0 compatible script (Enterprise Manager)

To create a SQL Server 7.0 compatible script

  1. Expand a server group, and then expand a server.

  2. Expand Databases.

  3. Right-click a database, point to All Tasks, and then click Generate SQL Script.

  4. On the General tab, click Show All to show all objects to script.

  5. Select the type of object to script, or select the Script all objects check box.

  6. Click the Formatting tab, and then select the Only script 7.0 compatible features check box.

    This option is only available on Microsoft® SQL Server™ 2000.