-
Script to generate schema, sp's, views on schedule
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!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|