I tried updated the geometry in my Feature Class using geometry:STPointFromText and it looked as though it worked but then the MXD wouldn't publish. I fixed it by exporting to a FGDB then re importing.
Are you allowed to at least edit the tabular data in SQL Server Management Studio (text, int, guid, etc)? Or are you required to do everything through ArcMap? I just don't want this to happen again.