Invalid colimn add scripting for new columns
If new colums have a sparse they will be scrithed without.
At second syng diff can be detected and scripted as :
ALTER TABLE [dbo].[lalala]
ALTER
COLUMN [lala] ADD SPARSE
GO
IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
4
votes
JGooLaaR
shared this idea
-
JGooLaaR
commented
*second sync