Column Modification Checklist

This is one of those things that I always forget part of, so because I just went through this, I thought I would document what needs to be done to sync your application whenever you modify any column in your database.

This tutorial is designed for:

• MS SQL Server
• Visual Studio (for web or desktop)

Quick Checklist:

1. In SQL Server Management Studio (SSMS)
1. Check for source and destination columns (for instance if widening "Address1" from 40 to 50, make sure all the columns in the order table, shipping, address book, Shipping and Billing etc are all the same)
2. Update All Views that depend on this column. (SQL Server does not do this automatically)
3. Update all stored procedures that operate on this column (for instance in and out parameters that access the changed column)
2. In your Desktop App:
1. Check all dataset xsd files to ensure the result column maxlengths are updated.
2. Check all dataset xsd files to ensure the query parameter maxlengths are updated.
3. Ensure all databound textboxes are set to the correct MaxLength.
4. Ensure all DataGridView Columns are set to the correct MaxInputLength.

Yahoo ID: Commander_Bombast

Opportunity is missed by most because it is dressed in overalls and looks like work.

--THOMAS ALVA EDISON

Coloum modification checklist can easily build it with using a html language in programing with using some tags.

Available here https://docsbaseca.com/ Translation Services in Vancouver CA