What is the theoretical storage limit of a smart contract?

It is 2^261 bytes. Check out this Stack Exchange post for more information.