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 |
|
Antonio Broughton
Starting Member
6 Posts |
 Posted - 2002-05-06 : 17:45:45
|
| Hi, I am wondering if it was possible to view the transaction log for a database using Transact-SQL in MS SQL Server 2000.I believe that a similar technique like this was possible in MS SQL Server < 6.5, but the ability to do this in MS SQL 7.0 was not included.Is this the case for MS SQL Server 2000 also?ThankyouAntonio Broughton |
|
|
VyasKN
SQL Server MVP & SQLTeam MVY
313 Posts |
Posted - 2002-05-06 : 18:41:06
|
| Antonio, the transaction log architecture is not published by Microsoft, so there's no documentation available. However, there are a couple of undocumented commands. DBCC LOG(pubs, 2)GOIn SQL Server 2000, here's a new command:SELECT * FROM ::fn_dblog(NULL, NULL)GOIt's hard to make any sense out of the output though. Strangely enough, Lumigent.com guys made some sense out of it, and made a product called Log Explorer, that you might want to take a look at.--HTH,Vyashttp://vyaskn.tripod.com |
 |
|
|
shsmonteiro
Constraint Violating Yak Guru
290 Posts |
Posted - 2002-05-29 : 13:11:09
|
| Hi,Some dig will make more sense of dbcc log output, but the ::fn_dblog() function does not return correctly the Row Data column, that is the important one (You can use dbcc page undocummented command to see the same info), So I recomend that you always use dbcc log(dbname, -1) or dbcc log(dbname, 4). BTW, don't forget to enable output to scree using dbcc traceon(3604) flag.regards,Sérgio Monteiro"don't take this life very seriously, for sure you will not go out live from her." Man, Is this real English???? |
|
|
|
|
|
|
|
|
Transaction Log