人人社区!

Prevent saving changes that require table re-creation

f08b7a8477184b7cb1e8831e448ed1f9.PNG


Steps to reproduce the problem

  • In SQL Server Management Studio, create a table that contains a primary key in the Table Designer tool.

  • Right-click the database that contains this table, and then click Properties.

  • In the Database Properties dialog box, click Change Tracking.

  • Set the value of the Change Tracking item to True, and then click OK.

  • Right-click the table, and then click Properties.

  • In the Table Properties dialog box, click Change Tracking.

  • Set the value of the Change Tracking item to True, and then click OK.

  • On the Tools menu, click Options.

  • In the Options dialog box, click Designers.

  • Click to select the Prevent saving changes that require table re-creation check box, and then click OK.

  • In the Table Designer tool, change the Allow Nulls setting on an existing column.

  • Try to save the change to the table.



回复
回复 楼主
顶部