I have published the lat long data in 10.0, but when it comes to 10.1 it does not seem to work correctly. When attempting to publish, it will not let you register the layer's data source with the server, which makes it copy the data to the server. Since the data is dynamic, it totally defeats the purpose of getting the data from SQL.
Is there a way to publish a mxd made up of a query layer?
Chris