>I would use this:
>

>DECLARE @ConstraintName nvarchar(128)
>DECLARE @Command nvarchar(max)
>SET @Command = ''
>Select @Command = @Command + 
>       'ALTER TABLE '+tab.name+' DROP CONSTRAINT '+sysobjects.name+CHAR(13)+CHAR(10)
>FROM SysObjects
>INNER JOIN (Select [Name],[ID] From SysObjects Where XType = 'U')  Tab
>       ON Tab.[ID] = Sysobjects.[Parent_Obj] 
>Inner Join sysconstraints On sysconstraints.Constid = Sysobjects.[ID] 
>Inner Join SysColumns Col On Col.[ColID] = sysconstraints.[ColID] And Col.[ID] = Tab.[ID]
>
>EXEC sp_executesql @Command
>

>
>but that is a matter of preferences :-)
>
>In your case you could add a print @Command before executing each line to see where you get the error.

Thanks, this is much simpler.