Hi @jerryfaust
I just tested this on PostGIS and dynamic loading works. It seems this is a SQLServer problem. Maybe GDAL driver related. Or perhaps because of the issues you reported relating to projection mismatch (Issues reprojecting OGR layers from SQL Server)?
cheers,
Mathijs