Hi.
I'm wondering whether it's safe to set the MS/SQL database that FME works with to single-user while processing it ?
I.e., sets the DB to "single-user" before pushing data into it, and to "multi-user" after FME's done.
Are there any serious caveats that I should be aware of ?
Cheers.
I don't think we can really answer that as it depends on your organisations use of SQL Server and the protocols you have for maintenance. SQL Server database single user mode is designed for database maintenance - so would generally be restricted to black out periods for database maintenance. If you switch to single use mode then all other users are logged off the database and no longer have access until the database reverts to multi-user mode.