Typical TV out settings are 640x480 since that's the best match to NTSC. However, some cards/systems don't seem to be able to go lower than 800x600. Just be aware that anything above ~480 lines will have to be scaled down to <=480 for TV out. Maximum horizontal resolution will depend on the output format. Composite is ~320, S-Video is ~640, component could go much higher.
Digital TVs (LCD, Plasma, DLP) and HDTVs will be limited both but the connection type and the "native" resolution of the display.