Don't make assumptions you don't know are correct. OP said he had DVI-I single link cable. If he had a DVI-I cable and moved to DVI-D, the cable would still fit.
The new DVI-D cable would fit, but the original DVI-I cable would not have fit, and therefore he would not have been getting 960×1080 or any other resolution through it.
There are plenty of systems out there, albeit mostly older, using DVI-I
Graphics cards certainly, but not monitors. Monitors almost always use DVI-D. DVI-I is just a combo port used for saving space, it's generally only used on graphics cards, where space is limited. When monitors want VGA capability, they usually just put an actual VGA port. There are a few exceptions (some Eizo monitors), but they're very rare.
we have MANY members using older hardware, so don't assume you know anything.
I don't need to assume anything about his hardware, he told us in the first sentence he is using an MG248QR, which has a DVI-D port. DVI-I cables would not fit in that monitor, so that leads me to believe that he was mistaken when he said he was using a DVI-I cable previously. I have seen this mixup happen many times, it isn't that much of a stretch.
You COULD be right, but you could just as easily be 100% wrong.
Of course. That's why, even given the reasoning above, I said:
I think the OP probably meant he was using a Single-Link DVI cable instead of a Dual-Link cable, rather than using DVI-I instead of DVI-D. People get confused between the two pairs a lot.
Given that "DVI-I cables" are practically nonexistent (for this exact reason), I'd be very surprised if he had one.