I have one SQL Server 2017 feature dataset where I can use the data in maps and edit it, but the publish operation fails after packaging. Previously created services using this data suddenly stopped working between a Friday and Monday. Esri Tech Support helped me troubleshoot permissions, etc, and isolate the issue to my most often used feature dataset. Other SQL data outside that feature dataset publish just fine.
I tried exporting the data to file geodatabases, then creating a new feature dataset and importing the feature classes into that. This had same issue of publishing.
I also tried importing the data that was exported to file geodatabases back to the database but not inside a feature dataset, same issue of publishing.
My only SQL Server experience has been installing it and upgrading from 2008 R2 to 2017. I don't know my way around SQL Server.
I'm looking for someone with more SQL Server knowledge to tell me if there's anything I can do to make this data behave again, tell me what the operation is called, point me in the right direction. Thanks!