
/*------ ATD 383526 ------*/
IF EXISTS (SELECT 1 FROM SYSCOLUMNS WHERE name = 'TEXTO01' AND id IN (SELECT ID FROM SYSOBJECTS WHERE xtype = 'U' AND name = 'ProdGescad'))
BEGIN
IF (SELECT cdefault FROM SYSCOLUMNS WHERE name = 'TEXTO01' AND id IN (SELECT ID FROM SYSOBJECTS WHERE xtype = 'U' AND name = 'ProdGescad'))> 0
BEGIN
     exec sp_unbindefault 'ProdGescad.TEXTO01'
END
    ALTER TABLE ProdGescad ALTER COLUMN TEXTO01 VARCHAR(MAX)
  --  exec sp_binefault ' ', 'ProdGescad.TEXTO01'
END
GO