Originally posted by timothymo
my server is have user login (by services) 5~8 times per second, and all these events are logged in sql log and system application events log.
will this cause problem to the server? as each entry will cause a open/close action.
if yes, how can i disable them?
Open / Close of DB file is not an issue its an configuration setting in Select DB Right click /Property / Options tab - Auto Close on-Off. This is to release the resource while DB is not in use. When any user use this DB the DB file will be opened.
If you don't want to use the login to be logged disable Server property / Security - Audit level (None or failure)