Standard condition number (SCN) detector is an efficient detector in multi-dimensional cognitive radio systems since no a priori knowledge is needed. The earlier studies usually assume a large number of dimensions and a large number of samples per dimension and use random matrix theory (RMT) to derive asymptotic distributions of the SCN metric. In practice, the number of dimensions may not be large enough for the SCN distribution to be well approximated by the asymptotic ones. In this context, the false alarm probability is considered in literature and formulas for 2D, 3D, and infinite-dimensional systems have been derived. However, the detection probability, which is of great importance in cognitive radio, has not been well discussed in literature. In this paper, we discuss, analytically, the detection probability of the SCN detector. Since the probability of detection is totally related to the SCN distribution, we derive new results on the joint ordered eigenvalues and SCN distributions for central semi-correlated Wishart matrices. These results are used to approximate the detection probability by the non-central/central approximation. We consider systems with three or more dimensions, and we give an approximated form of the detection probability. The analytical results of this paper on probability of detection along with those on probability of false alarm present a complete performance analysis and are validated through simulations. We show that the proposed analytical expressions provide high accuracy and that the SCN detector outperforms the well-known energy detector and the largest eigenvalue detector even with a small number of dimensions and low noise uncertainty environments.