I removed all the triggers associated with the HostAdID field. The ExitID
field stated to give the the same trouble, so I had to remove all triggers
on that field as well. And it worked fine, anyone any idea why I had to
remove the triggers?
jeff
-----Original Message-----
From: Jeff Green [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 21, 2001 12:52 PM
To: CF-Talk
Subject: OT: SQL Server DTS question
Hi all got a SQL Server DTS question for ya
Im trying to DTS my DB from my dev SQL to production SQL.
Im this error:
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name'HostAdID'
Is HostAdID some sort of reserved word?
When I do this DTS I transfer objects not just tables. (I want my triggers
and all that good stuff)
btw - even when this does work my relationship properties dont get
transfered
So I renamed the column to AHID and it still breaks, Im thinking cause of a
trigger or something maybe?
When I strictly just copy the tables it works fine, even with my column
named HostAdID.
Can anyone offer me any advice?
Thanks in advance,
Jeff
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists