It's up to the company I think.... but would be pretty harsh if they didn't let you transfer to your husband's sponsorship. I'm in a similar situation, my company said they're happy to give the NOC, just waiting for my husband's visa to be sorted so I can transfer....