Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
balasqlteam
Starting Member
4 Posts |
 Posted - 2007-08-09 : 17:37:51
|
| Hello, I want to know a way to view the logs created by a MSDE database. I want to see information like number of users connected, number of connections, data modification operations etc. where do i start looking for this information?How do i control the logging feature in a MSDE database. I suppose it is configurable but not sure where to look at to change the setting.Please help! |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-09 : 23:34:50
|
| There are no such info in sql server log, you can use sp_who2 to list user connections. To dig in db transaction log, you need third party tools. |
 |
|
|
balasqlteam
Starting Member
4 Posts |
Posted - 2007-08-10 : 13:09:51
|
| Thanks for the reply.Are you saying that that i cannot control the the information logged into MSDE? For example can i not say sql server log only "error" or "info" messages?Pls throw some light.Thanks again! |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-08-10 : 13:53:25
|
| if you want to see what changes have been made to your data then implement auditing.also SQL Express is a free version Of SQL Server 2005. think about using it since it offers a lot of new stuff compared to MSDE_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-11 : 01:45:53
|
| You have some options but not much control. |
|
|
|
balasqlteam
Starting Member
4 Posts |
Posted - 2007-08-13 : 10:27:01
|
| What are the options available. I dug the internet for the past 2 days without much information. Can you elucidate me on these options?Thanks! |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-13 : 23:15:38
|
| You can enable/disable login auditing, can modify system messages to enable/disable logging them in sql server log. |
|
|
|
|
|
|
MSDE Logging