> I don't see anything like that. Do you have any diagrams with lines connecting the tables? Those lines usually create constraints that would cause fields to throw errors if you try to drop them. Also, IIRC, when you change the field type in SQL Server it actually creates a new temporary column, moves the database, drops the original, and then renames the temp to whatever the source column was called. It follows that if there is a constraint you would not be able to change the data type.
It's been a while since I had to mess with the innards of SQL Server, so I could be mistaken. ----------------------------------- Justin D. Scott Vice President Sceiron Interactive, Inc. www.sceiron.com [EMAIL PROTECTED] 941.378.5341 - office 941.320.2402 - mobile 877.678.6011 - facsimile ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:193991 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
