Database reported: The transaction log for database 'tempdb' is full due to 'ACTIVE_TRANSACTION'.
General SQL Error
The transaction log for database 'tempdb' is full due to 'ACTIVE_TRANSACTION'.
declare @GN int
declare @ContentItemID int
declare @NavTree table (
declare @Items table (
ContentItemID int primary key,
/* Select the group number, based on the content template */
select @GN = NavGroupNum
where TemplateID = ?
/* Query the nav structure to find the set of items that will be returned */
insert into @NavTree
S.AncestorContentItemID, S.ParentContentItemID, S.ChildContentItemID,
S.Depth, S.DisplayOrder, S.NavGroupNum, PCI.ItemNumber
from SM_NavigationStructure S
left join CM_ContentItems PCI ON S.ParentContentItemID = PCI.EntityID
where S.NavGroupNum = @GN
and S.AncestorContentItemID is null
and Depth <= ?
/* Pick out the exact set of items to return */
insert into @Items ( ContentItemID, DisplayOrder, Depth, ParentItemNumber )
select CI.EntityID, S.DisplayOrder, S.Depth, S.ParentItemNumber
from Entities E
join CM_ContentItems CI ON E.EntityID = CI.EntityID
join @NavTree as S on CI.EntityID =
where E.IsActive = 1
and CI.EntityID not in (
from SM_NavigationStructure join Entities on SM_NavigationStructure.AncestorContentItemID = Entities.EntityID
where Entities.IsActive = 0
and CI.EditableProduct = 0
and CI.DatePublished is not null
and ( CI.ReleaseDate is null or DateDiff(d,ReleaseDate,getdate()) >= 0 )
and ( CI.ExpireDate is null or DateDiff(d,getdate(),ExpireDate) > 0 )
and CI.DateArchived is null
/* Now, select all of the actual content item data, as determined by the nav tree */
CI.TemplateID, CI.ItemNumber, CI.DatePublished,
CI.LoginRequired, CI.VisibilityException, CI.VisibilityRestriction,
F.FieldID, IsNull(F.GroupNum,1) AS GroupNum,
F.FieldName, F.FieldType, F.Maximum,
CIF.ContentItemFieldID, IsNull(CIF.RepNum,1) AS RepNum,
CIF.FldString, CIF.FldText, CIF.FldInt,
CIF.FldDate, CIF.FldDecimal, I.Depth, I.ParentItemNumber,
NIC.TargetURL, NIC.TargetWindow, NIC.UseURLVariables, I.displayorder
from CM_ContentItems CI
join Resources R ON CI.EntityID = R.EntityID
join @Items as I on CI.EntityID = I.ContentItemID
left join CM_Fields F ON CI.TemplateID = F.TemplateID
left join CM_ContentItemFields CIF ON CI.EntityID = CIF.ContentItemID AND F.FieldID = CIF.FieldID
left join SM_NavItemConfiguration NIC on NIC.EntityID = CI.EntityID
order by I.DisplayOrder ASC, CI.ItemNumber, GroupNum, RepNum, F.FieldID
President Obama signed into law his top domestic priority: a sweeping overhaul of the nation's health care system. The new law will ultimately affect every American in some way, but some of its featur ...
TSA representatives, Paul Leyh, Aviation Director Office of Security Policy and Industry Engagement, and Jerry Koehler, Division Director, Marketing Office of Risk Based Security discuss the various w ...
ASTAs Director of Research, Melissa Teates discusses the most effective marketing methods used by fellow travel agencies, presenting case studies of successful marketing strategies used by ASTA member ...
Jerry Koehler of TSAs Risk-Based Security Office talks about the various ways your clients can enroll in the PreCheck programs, where its being implemented and when, and the steps you have to take thr ...
To many people, the term "PAC" conjures up images of smoke-filled rooms and corrupt politicians. But the reality is more complicated. When it comes to influencing public policy, ASTA faces a choice r ...
Heather Dudick, Alaska Railroads Passenger Sales Manager, presents the Inside Track Alaska Rail Specialist: your ticket to learning about the many ways your clients can explore Alaska by rail, and gre ...