Excellent....thanks Bill Bryan Stevenson VP & Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] --------------------------------------------------------- Allaire Alliance Partner www.allaire.com
----- Original Message ----- From: "Bill Grover" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, November 28, 2001 9:57 AM Subject: RE: SQL Server upgrade (7-2000) > We have had problems doing our upgrade. After the software is installed SQL > runs some scripts that upgrade the various tables. Ours would fail with the > message "Error executing script upgrade.sql (1)". After talking to > MicroSoft support the only solution is to uninstall SQL7 and then install > SQL2000 as a clean install. > > What we did that finally worked was: > > 1. Stop SQL7 > 2. Copy all database and log files into another directory. > 3. Uninstalled SQL7 > 4. Installed SQL2000 > 5. Copied all of the database and log files into the new data and log > directories (ours were on different drives). > 6. Recreated all users from the old system keeping passwords etc. > 7. Attached each database into the server. > > The only issue we had was we had 2 purchased programs that had special > security settings and stored procedures in the master database. We had to > manually recreate this information. One thing that helped was each of the > programs had a utility that once we gave the "admin" user rights to master > would recreate all of the security settings needed for each user. > > But all of our internal programs worked like a dream without any special > work. > > Bill Grover > Supervisor, IS > EU Services, Inc. > 649 N Horners Ln > Rockville MD 20850 > > Phone: 301-424-3300 x396 > FAX: 301-424-3300 x1396# > E-Mail: [EMAIL PROTECTED] > > > > -----Original Message----- > > From: Bryan Stevenson [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, November 27, 2001 6:39 PM > > To: CF-Talk > > Subject: OT: SQL Server upgrade (7-2000) > > > > > > Hey All, > > > > Sorry for the OT, but has anybody had any glitches upgrading from SQL > > Server 7 to SQL Server 2000 (database side not CF)? > > Specifically loss > > of data or anything nasty when just installing over top SQL Server 7? > > > > TIA > > > > Bryan Stevenson > > VP & Director of E-Commerce Development > > Electric Edge Systems Group Inc. > > p. 250.920.8830 > > e. [EMAIL PROTECTED] > > --------------------------------------------------------- > > Allaire Alliance Partner > > www.allaire.com > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
