Are you sure that the Dwg_Ref and Title columns actually contain the string value 'NULL'? If they contain actual
null
values, then they will not match, and the WHERE clause will fail. Perhaps you meant:
DELETE FROM PIMS.dbo.Dwg_Register
WHERE Dwg_Ref IS NULL AND Title IS NULL AND [Status] = 'Approved As Noted'