> On MSSQL 2K you can right-click the database and chose "All Tasks > > Generate SQL Script..." to generate TSQL scripts. You can do this for > individual objects, too. Query Analyzer has similar functionality if > you left click an object in the object browser pane.
This can create a database creation script, but it can't create a database update script. I need an adaptable script that will detect the current state of the database(what fields, indexes, etc. are present), and update accordingly to the current version. Thanks. -- Derek _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
