In Stargate and SG-1 the Goa'uld use a healing device, called a sarcophagus, for various purposes (provide long life to their host, reward sycophants, etc). One of the more unpleasant uses Goa'uld have for it, however, is to torture someone to death and then use the sarcophagus to restore life to the dead body. This way they can continuously torture someone to death for as long as they wish.
Presumably this feature of the sarcophagus could be used by anyone wishing to bring someone else back from death (loved ones, friends, enemies, etc). But is there a limit to how long the body can be dead before a sarcophagus is able to restore life to it? For example, in one episode Jack contracts a disease from an Ancient and can only be saved by a Tok'ra symbiote. But considering Jack's oft-repeated opinion regarding having a "snake" in one's head, couldn't they have let him die, stuck him on ice and then found a Sarcophagus later to revive him in?