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 |
|
rohitmathur11
Yak Posting Veteran
77 Posts |
 Posted - 2009-12-07 : 02:46:25
|
| Hi, database is in full recovery model.. Can we check that what all sql queries ran in to database between 10 am to 11 am ..like any time ...Is it possible by reading transaction log..How to read sql queries in transaction log..?any idea..? |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-12-07 : 09:26:00
|
| The transaction log does not log queries. It logs the data modifications that occur. Any select query will not affect the log at all, insert/update/delete queries you'll see the changes that happened, not the queries themselves. If you want: SELECT * FROM fn_dblog(null, null). Beware, it's not intended to be easily readable.If you want to know what queries run, you should set up a server-side trace--Gail ShawSQL Server MVP |
 |
|
|
rohitmathur11
Yak Posting Veteran
77 Posts |
Posted - 2009-12-08 : 01:46:31
|
| thanks a lot for helping ... so for checking errors or things happened ..i need to check error log under --management studio--management--server logs -- for this sql server agent must be running ...? |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-12-08 : 03:34:36
|
| Errors will go into the SQL error log. Other generic things happening may not.SQL agent has nothing to do with the error log. It's a separate component.--Gail ShawSQL Server MVP |
|
|
|
rohitmathur11
Yak Posting Veteran
77 Posts |
Posted - 2009-12-11 : 04:54:23
|
| Thanks a lot Gail ...for impoving my knowledge..... |
|
|
|
rohitmathur11
Yak Posting Veteran
77 Posts |
Posted - 2009-12-14 : 23:47:43
|
| Hi,I am sql server 2008 installed and 5 databases are running on it.I want to check any error or activity occur on one database ... is we have only sql server log file under management ... for checking activity...? or any other files we have which can tell us about all activities on database ...? i am using sql server management studio for dong all work.. any idea..oracle |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-12-15 : 04:44:24
|
| There's only one error log per instance. It doesn't log activity, just errors and interesting/useful messages. If you want to check activity you'll likely need a server-side trace. Give some more info on what you're after and I should be able to advise you more.--Gail ShawSQL Server MVP |
|
|
|
|
|
|
Reading transaction log