Underwater Sonar Range?

Does anyone know what the limits of detection for underwater sonar are (if it has any); or at least an educated guess at what depth the information it would bring back would be useless for determining the location of an object.