thers is somehting i am struggling with While upsizing from access to SQL all the IsActive fields that are of bit type are upsized with null not allowed and we need them to allow null is there a script that would do this as of now i going into each table and allowing null on each table
and also the memo fields on access are trasnferred as ntext can we change them all with a script to nvarchar(MAX),i.e all the columns IsActive Columns are set to Allow null and all the ntext fields are set as nvarchar(max). As of now i have been doing the alter one at a time.
thanks