How to enable feature access for some layers from .mxd document

[AnatoliiTerentiev]

Dear Gurus!
I have .mxd document with 3 kind of layers.
1. topo layers
2. layers with constant information (cities, for example) with need to provide feature access for enabling query
3. layers with dinamic data, wich are changing in real time, for example, table of forest fires.
Can I publish 3 type of services from one .mxd file or I must create 3 .mxd files?
Can you get any reference to understand with this problem?

[JonathanQuinn]

If you're just querying data, you can create one map service with all layers in it.  A map service supports querying for data.  If you need to edit, you'll need to separate the data that you'd like to edit in a separate map document, and publish that map document with feature access enabled.

[AnatoliiTerentiev]

Thank you! Now I am finding how to create a layer on x,y -table in geodatabase (SQL server)

[AnatoliiTerentiev]

I introduced in the x, y- table "events" field, which contains geometry (loc) with the following query :

update events set loc = geometry :: STGeomFromText (concat ('Point (', ltrim (STR (x, 99, 11 )), '', ltrim (STR (y, 99, 11) ) , ')' ) , 28406 );

where srid = 28406 for Pulkovo 1942 Gauss-Kruger zone 6 (took away http://cs2cs.mygeodata.eu/)
And simply drag a table of events from the connection Catalog on the Map. Points layer - appeared .
But in order to publish a layer it's  needed to register table in gdb. I am tried from the context menu in the Catalog - Manage -> Register with Geodatabase but get an error

Failed to register with the Geodatabase.
Underlying DBMS error [Microsoft SQL Server Native Client 11.0]: the metadata could not be derermined because statement 'EXEC (@ ececstring) in procedure' sp_renamed 'contains dynamic SQL. Consider using WITH RESULT SETS clause to explicitly describe the result set '

What could be the reason?

[AnatoliiTerentiev]

Could it be the fact that the field names are not correct?  What are the options for finding a solution to the problem? The table and the field of type "geometry", I have created in sql server 2012 managemant studio. The connection have made from the sa.