Reed Posted February 15, 2012 Share Posted February 15, 2012 I've set up ESS with a SQL server 2008 database, and viewing/editing records seems to be working fine. The problem I've encountered is that when I try to delete a record via ESS, it appears to delete, but when I search for the record again it is still there (and it's there if I look for it in SQL server management studio) I get no error messages when deleting, and if I run a delete query in the SQL server management studio, the record really does delete in that case. Has anyone encountered an issue like this where ESS does not allow deletion? Link to comment Share on other sites More sharing options...
Reed Posted April 16, 2012 Author Share Posted April 16, 2012 So a partial answer to my own question is that the data which I couldn't delete is being audited in SQL server. There are other tables which are not audited in which I'm able to delete records just fine. I just can't delete records in audited tables via ODBC or ESS. Still not sure why that is though. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 4385 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now