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 |
|
hi_naroor
Starting Member
4 Posts |
 Posted - 2005-08-30 : 13:57:01
|
| Hello Friends , I tried running DBCC LOG (mydatabase,TYPEID) with all the TYPEID's from -1 to 4 .And i got the resultsets with the folowing column heads.Please tell me what these column names refer to .Current LSN : Current Log Sequence Number Operation : The kind of operation like inserting rows ,updating etcContext : Transaction context Transaction ID : A hexadecimal Transaction IDTag bits ??Log Record length ??Flag bits??Object name ??Index name ??Page ID ??Slot ID ??Data Offset ??Record data ??Please help me out,Naroor Rathish |
|
|
ryanston
Microsoft SQL Server Product Team
89 Posts |
Posted - 2005-08-31 : 01:14:11
|
| Can I ask why you're using DBCC LOG? It is wholly undocumented and unsupported. The fields you're seeing in the output contain contextual information about the log record generated. Thanks,----------------------Ryan StonecipherDeveloper, Microsoft SQL Server Storage Engine, DBCC(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.) |
 |
|
|
|
|
|
DBCC Log Column Meanings