That's not ENTIRELY true.
If your'e using Spectra (I know this isn't that list.. But it's worth
the mention) you're in for a surprise. And actually seems to do the
same thing on either SQL 7 or 2000, but doesn't seem to manifest itself
until after the upgrade (i.e., if you go back to 7 from 2000.. It will
still occur)...
Problem is that the Data Transformation features stop working from the
Enterprise Manager or from the DTS Wizard itself. Doing the processing
automatically (i.e., scheduled) or programmatically seems to work fine.
Only the gui's stop working.
Other than that.. It's nicer.. For certain.
Lee Fuller
Chief Technical Officer
PrimeDNA Corporation
> -----Original Message-----
> From: Paul Hastings [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, April 17, 2001 10:40 PM
> To: CF-Talk
> Subject: Re: From MSSQL7 To SQL 2000
>
>
> > Anyone know effect if change from MSSQL7 to SQL 2000
> > Is effect to coldfusion code ?
>
> almost none. you do get better text indexing, user defined functions,
> & new datatypes (like a table datatype) which you might want to
> incorporate into your apps.
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
