You don't need it for SQL Server 7.0 and up. It was needed for 6.5 to guarentee that the data and log pages were restored to the correct segments. With 7.0, the physical implementation has changed.

If you want to restore a database, SQL Server can create the database from information stored within the backup.

If you just want a script to create the database w/o object, you can use the SEM. Right-click on the database and chose All Tasks | Generate SQL Script... From the Dialog, make sure that the Script Database option is checked on the Options page. Clicking Preview from the first tab will generate a script that creates the database.

-Mike


>In SQL6.5, we used sp_help_revdatabase to create the SQL script to recreate the databases.
>But I can find this in SQL7.
>
>Which sp do we use in SQL7 to create the script to recrate databases.
>
>
>Thanks
>
>
>Jim