We're using SQL Server 2000 and currently script one of our database's objects (procedures, functions, and views, and table structures) to a script file. All of the data in those tables is populated from other databases using those procedures, so I don't need to backup the data, just the table structures. So here's my question:
Can I somehow automate the generation of that object generation script? On some kind of a schedule or as part of a backup or maintenance job? Any help would be greatly appriciated.
-------------------------------------------------------
Ryan McCauley
Business Systems Engineer
Peter Piper, Inc.
(480) 609-6456
RMcCauley@PeterPiperPizza.com
-------------------------------------------------------