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
ASTAs Government Affairs team works tirelessly to protect the interests of travel agents across the country before the U.S. Congress, the White House, federal agencies, all 50 state legislatures and e ...
Who uses travel agents, who wants to use travel agents and how to market to both. ASTAs Value of Travel Agents study surveyed over 8,000 U.S. Travelers and found out who uses travel agents and who do ...
In 2013, travel agencies of various sizes were assessed civil penalties ranging from $20,000 to $125,000, and on day two of 2014 DOT levied a $95,000 fine on a single agency. The risk is real. This pr ...
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 ...