ChgLog How to gather statistics

[hkeric.wci (Haso Keric)]

Try:

How do I trim the log text from the change log?

I had to put this together for an Audit, just throwing it in for reference =) Not the prettiest all I could come up with in 15 minutes SELECT *, WhoChangedItQuery.LogSplit AS WhoChangedIt, WhatWasChangedQuery.LogSplit AS WhatWasChanged FROM ( SELECT * FROM ( SELECT Company, Identifier, TableName, DateStampedOn, LTRIM(RTRIM(m.n.value('.[1]','varchar(8000)'))) AS LogSplit FROM ( SELECT Ice.Chg…