[Solved] SqlDependency isn’t firing

It is possible for you to be database owner and still have your account’s security settings screwed up. To fix this, delete the user (not the login), then recreate it.