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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 transaction log

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2003-01-27 : 08:18:39
David writes "NT 4.0 service pack 6, SQL Server 7.0 service pack 3
what are the three values that comprise the lsn, eg:
00000115:00036613:0001? how/when does the lsn get reset? I swear I checked every web resource I could find and BOL before asking this question."

JamesH
Posting Yak Master

149 Posts

Posted - 2003-01-27 : 08:35:33
LSN shows the location and sequence number. You can try the backoffice resource kit for more information on how it is actually generated or maybe check lumigent's website, they might have info since their Log Explorer actually reads the log.

JamesH.

Go to Top of Page
   

- Advertisement -