December 17, 2003 at 10:02 am
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
-------------------------------------------------------
Ryan
December 22, 2003 at 12:00 pm
This was removed by the editor as SPAM
December 22, 2003 at 3:42 pm
you can do it with DMO (I think Andy has an article on this) and then run the script from a job.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply