Saving changes is not permitted | Prevent saving changes that require table re-creation - Sql server

Mar 07, 2019 BY SOL

This problem occurs when the Prevent saving changes that require the table re-creation option is enabled, and you make one or more of the following changes to the table:You change the Allow Nulls setting for a column.You reorder columns in the table.You change the column data type.You add a new colu...

Drop all tables n stored procedure in Sql Server

Feb 18, 2019 BY xtreme

Can Remove all Tables and Store Procedure for a Database at once. Drop all user defined tables EXEC sp_MSforeachtable @command1 = "DROP TABLE ?"Drop all user defined Stored ProceduresDeclare @pName varchar(500) Declare sqlcur Cursor For Select [name] From sys.objects where type = 'p' Open sqlcu...