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
Materials that will provide you, the professional agency owner, manager, or home-based business owner, with the essential business tools to run your business in a more efficient and profitable way. Co ...
This analysis provides guidelines for determining whether the government will view a travel-agency worker as an independent contractor or as an employee. It will also familiarize agents with some of t ...
This Premium Member report provides information on PayPal and its potential use for travel agents. Provided in the report is a detailed comparison of three payment options: ARC TASF, a typical merchan ...
Conducted by the University of South Carolina's Travel & Tourism Industry Center, the ASTA/Sloan Foundation study gives a detailed look at the key strengths of highly successful American travel ag ...
Focusing on the laws of eleven states that ban credit card surcharges in specific transactions, this report examines how those laws affect travel agencies and airlines. The report also includes an ana ...
Currently, seventeen states including the District of Columbia impose some type of regulation on travel sellers and tour operators. Due to the perceived rampart abuse of consumers, states began enacti ...
What Travel Agencies need to know about the Red Flags Rule. The Red Flags Rule goes into effect in December 2010. This document covers information on what you need to have in place ... regarding ident ...
In recent months, federal and state lawmakers have stepped up efforts to significantly raise the stakes on businesses that misclassify their workers as independent contractors. The ramped-up pressure ...
Trusted Traveler is the umbrella under which several risk-based security programs operate. TSA's PreCheck program is designed to expedite the flow of "trusted" and low-risk travelers through airport s ...