Similar to Luis brilliant solution, but without the where clause:

select 'ALTER TABLE ' + so.name + ' DROP CONSTRAINT ' + sc.name

from sysobjects so

inner join sysobjects sc on sc.parent_obj =...

datediff returns the difference between two datetime values.

It seems to me the timezone table contains just hours (no dates!) and that's why you won't get the expected results.

In order to...