The limit is 100kb, any transaction that is more than 100kb will not be broadcasted,
The limit is now 400,000 weight units, not 100 KB. That's the default maximum standard transaction weight and nodes will likely reject your transaction if it has a larger weight.
It may worth mentioning that the protocol allow a transaction to have larger weight and nothing prevents a miner to include a transaction with larger weight.