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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
