Like several other posts here, we are having an issue with ANSI_WARNINGS and ANSI_NULLS when trying to create a report definition against a linked server in CUIC 10.x.I understand from previous posts, that we need to have these set on the connection,...
That is not working. It still says we have to set it in connection properties, which we can do, but just wondering if it is supported to change a server-wide setting- Paige DelkSent from my iPhone(please excuse typos)
SELECT A.EnterpriseName, aed.SkillTargetID, A.PeripheralNumber, aed.LoginDateTime, Event = CASE Event WHEN 1 THEN 'Login (1)' WHEN 2 THEN 'Logout(2)' WHEN 3 THEN 'NotReady (3)' END , EventStart = DATEADD(ss,-Duration,DateTime), EventEnd = D...
