SQL Enterprise - SQL Server Log questions

[StevenK]

I work against SQL server 7.0 databases on a number of servers (some running locally). Using 'SQL Server Enterprise Manager' I am able to view the 'SQL Server Logs' from the 'Management' tree. This shows me the current 'SQL Server Log'. In this I am seeing a number of logged entries indicating that various databases have been opened and closed, i.e. :
Opening database D:\MSSQL7\Data\Database_1.mdf
Closing database D:\MSSQL7\Data\Database_1.mdf
(or something like this .....)
What is causing these entries to be logged. I am only seeing this for some of the databases (not all of them). However on one of the machines (SQL Server running locally) I am seeing such entries for all databases when I open up SQL Server Enterprise Manager itself).
On our server that everyone in the company can access through the network we have seen that two particular databases are being opened and closed often (during the standard 9-5 working day). I was wondering what triggers such an entry to be logged in the 'SQL Server Log'. ?
Is it when a user makes a connection to the database or when a user runs a query against the connected database.
This may sound like a daft question but it's something I want to understand better - is it the same rules for each server + each database or can they be set differently such taht log entries are made under different circumstances for the specific server and database ?
Any pointers would be helpful ....
Thanks in advance.
Steve

 

[foxdev]

There is a setting like "Close database on exit" that may come into play here. Also, the EM's SQL Server Registration Properties setting for Show System Tables might filter the results from the log for Master, MSDB, etc, though I have my doubts. Robert Bradley
Sr. DBA, some big company
cheap prints and oil paintings:

http://www.lowcostprints.com

 

[tlbroadbent]

Check Auto Close under the database Options. Terry

http://members.home.net/tlbroadbent/prog.htm

The reason why worry kills more people than work is that more people worry than work. - Robert Frost

 

[foxdev]

Thanks, Terry - now that I'm working in a Sybase shop, I don't have the tools in front of me and have to work off an aging memory bank. Robert Bradley
Sr. DBA, some big company
cheap prints and oil paintings:

http://www.lowcostprints.com