Angelo, thank you for your Reply.
Can you please elabrate this SQL-Server 2012 is NOT supported by ArcGIS Server 10.0 (in fact, it won't be fully supported until a service pack of 10.1) and...
We are having the set of incident location detail in SQL Table which contains lat, lang information as mentioned in previous post, my task is to Convert (First time) all these data into SDE feature class , and every day we have to update this feature class from the SQL table (since, the data is directly stored into SQL Table not in SDE) without any human interaction, then i have to refresh the published map service and do the analysis on the updated layer.. I need the basic idea and some guidelines to do this.