Trigger Code:

BEGIN

SET ANSI_PADDING ON

SET CONCAT_NULL_YIELDS_NULL ON

SET ANSI_WARNINGS ON

DECLARE @LogonTriggerData xml,

@PostTime datetime,

...

If you are referring to Microsoft CAT as the professional, we are considering it. We cannot disable the logon trigger due to audit compliance. What we have done is disabled...

Good Information, I will take a look the connections for this particular application. Thanks again!

Hello Gail and Paul,

I am some more information detail regarding this problem.

--------------------------------------------------------------------------

Recap:

Error message during DBCC CHECKDB:

Msg 2533, Sev 16: Table error: Page (1:717080) allocated to object ID 181575685, index...

Hi Gail and Paul,

Just wanted to follow-up. Our internal hardware and storage team’s insists there are no issues with any of the drivers and hardware between the server and the...

Hi Gail and Paul,

Thanks for the great feedback.

The IT hardware team finally reviewed the server found that the array controller has outdated drivers, > 5years old. They are going...

Hello Gail,

The server environment is listed in my original post above.

The SAN configuration I am trying to obtain. I have inherited this server.

There are no errors in the SQL...

In my original post I mentioned that once the nightly maintenance runs whereby issuing a DBCC CHECKDB, prior to backing up the database, the error is generated. Soon after we...

I appreciate your response. When rerunning DBCC CHECKDB the output displays no corruption.

With help from a friend, here is the answer

select max(case when (c-1)%3 = 0 then c else NULL end)

      ,max(case when (c-1)%3 = 1 then c else NULL end)

      ,max(case...

I have the same problem. However, where do you apply the APPEND hint when the MSSQL DTS package is handling the data load?