Just curious about this because at the when I started this app, I spent a lot of time in SQL Profiler trying to figure out why things were not working as I expected them to That was when I noticed that Strataframe was sending a lot of exec SP_EXECUTESQL commands to the server. Now, with my current client and since this is a winforms app, allowing Strataframe to do this does not concern me. However, my husband performed as DBA for Charles Schwab for 18 months and there is absolutely no way that they would allow a user access to system stored procesures (especially with the threat of SQL injection) - the database was totally locked down.
So how does Strataframe get around this situation?