Convert all Ntext to nvarchar(max) and Allow null in all is active field

  • 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

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply