I use their SQL-Prompt software (It's free) to get intelligence type prompts in Query Analyzer!
Timothy Fleck Axium Entertainment Payroll Axium International Inc. 818-531-3080 -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Lou Syracuse Sent: Wednesday, April 25, 2007 12:49 PM To: [EMAIL PROTECTED] Subject: RE: MSSQL database creation/modification/maintenance scripting/functions? Check out SQL Compare: http://www.red-gate.com/ We use it to generate update scripts when updating our studios POS software. Pick two databases and it scripts the differences: tables, stored procs, users... handles it all. Highly recommended. Lou -----Original Message----- From: Derek Kalweit [mailto:[EMAIL PROTECTED] > 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 _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ This e-mail and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this e-mail in error please notify the originator of the message. This footer also confirms that this e-mail message has been scanned for the presence of computer viruses. Any views expressed in this message are those of the individual sender, except where the sender specifies and with authority, states them to be the views of Merle Norman Cosmetics. [excessive quoting removed by server] _______________________________________________ Post Messages to: ProFox@leafe.com 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.