Anyone out there have a script that will generate a SQL script of the DDL (Tables and views) and SP's in a database as a scheduled job? I've got a development server that we're interested in saving the tables, views, and procs on, but not necessarily the data, and have been asked to find a way to backup the DDL and procs on a scheduled basis. I tried the sp_generate_script from chapter 17 of Ken Henderson's 'Guru's Guide' but I get OLE DB errors. I'm running SQL Server 7.0 with SP3 and the hotfix (7.00.996).

Thanks everybody!