Theoretically, a telescope can see forever! But our eyes and cameras are the limiting factor. As objects get fainter, it's harder to see them. But they are there.
Your limiting Magnitude doesn't only depend on your scope. It depends on Light pollution, Moon glow, seeing, transparency, quality of EP's, etc etc.
So the question has a broad answer
