Is it possible to restore only the schema and stored procedures from a MS SQL database backup?

Question

I have a full MS SQL Backup file that I would like to extract the stored procedures and schema from. Is there a way to restore only the schema definitions and stored procedures without restoring the data/table rows?

Answer 1

I don't think so, but you could restore it to a temporary database and then script it all from there.

Answer 2

What SQL Server version (and tools) are you using? Under SQL 2000, I remember the "Import/Export Data" wizard, that let you specify which objects you wanted to import and where. You could even perform queries to obtain a subset of data.

Answer 3

I suppose this capibility is not present in the standard toolset. Perhaps in a third party tool. Thank you for your responses.