Is that syntax error coming from SQL Server or from the Cmd Exec? Please post the exact error message.

Thanks

John

1. You must know the file name and path in order to import it in the first place, mustn't you?

2. You'll need to set the task so it doesn't cause...

Here is your clue:

EXEC @retVal = xp_cmdshell @TmpPurgeCommand, no_output;

IF (@retVal = 1) -- Error occured

BEGIN

RAISERROR (50001, -- Message id.

16, -- Severity,

1, -- State,

N'xp_cmdshell call in [dbo].[adminManagePartition_Trace] failed. Purge not complete.');...

Have you looked in the default trace?

John

The only thing I can think of is that a trigger on table A is deleting some of the rows, or modifying what is copied to table A.

John

Donald Bouchard (11/16/2011)

---

I understand and agree with all your points, but if I have a million customers that have shopped on average in about 10 departments each, I'm going to...

drew.allen (11/16/2011)

---

Actually, as Jeff Moden points out in his excellent article Solving the Running Total and Ordinal Rank Problems (Rewritten)[/url] the whole reason that the quirky update works at all...

Why not have one row in the DeptShopped table for each customer who has shopped in each department? That's the tried and trusted way of doing it, and it...

That UPDATE statement won't loop through the rows in @Dept - it will use the first row in @Depts that it finds and then stop. That explains why the...

OK, I see - severity up to 10 is information or warning; 11 or greater is error. Have you tried an onInformation event handler instead? If that doesn't...

If the stored procedure is raising an error, would the OnError event handler work, instead of OnWarning?

John

Does the column(s) indexed in index ID 7 contain any NULLs? This would explain the difference, although it doesn't explain why it disappears after you rebuild the index.

John

Can you show us the exact queries you're running to get the counts, please?

Thanks

John

If it's a datetime column, won't this work?

CONVERT(datetime,MyCol,120)

John

If you think that would be useful, then by all means add it. But I wouldn't use third-party add-ins to achieve something that can be done with out-of-the-box functionality.

John