At 04:57 PM 08/26/2001 -0700, you wrote:
>We have just joined a hosted environment and although we have access to SQL
>Server via enterprise manager, we do not have the facility to import/export
>tables via enterprise manager.
Can't you just use DTS to create the table objects via Enterprise
Manager? You should be able to use it to copy over all your tables,
including identities, triggers, default values, and I believe stored
procedures ( And just about any database object you want to )
>Can anyone point me to a resource or give some good tips on using CF to
>manipulate-add-delete tables in a SQL Database?
Well, if you want to write T-SQL to do it, you can. And that code
should run without any problems in a CFQUERY.
--
Jeffry Houser | mailto:[EMAIL PROTECTED]
AIM: Reboog711 | ICQ: 5246969 | Phone: 860-229-2781
--
I'm looking for a room-mate in the Hartford CT area, starting in August
--
Instant ColdFusion 5.0 | ISBN: 0-07-213238-8
http://www.instantcoldfusion.com
--
DotComIt, LLC
database driven web data using ColdFusion, Lotus Notes/Domino
--
Far Cry Fly, Alternative Folk Rock
http://www.farcryfly.com | http://www.mp3.com/FarCryFly
--
Change is good
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
