I have seen this error in the past. I have had jobs run for years without any issue then all of sudden it stopped working. Unfortunately I cannot...

Is it me or are you guys missing a trick here?

There is a system table named sysmessages where all error descriptions are stored (both system errors and user errors), ...

Is there an equivalent for SQL Server 2000?

The main table that contains 191,000 to 400,000 is more than just two columns, I trimmed it down for ease of reading but below is the full table structure with...

Hi John

the table TempLoadRawCmsCallHistory has anything from 191,000 through to 400,000 depending on the number of calls the business receives.

TheSQLGuru

There are no Identity Keys on the tables.

Cheers

Mark

John

Thank you I will try your code and get back to you.

Cheers

Mark

Sorry John

You are correct you will get in the groupid column 1 then two. The value 12, 13 were just random numbers for example purposes only.

Hi John here you go:

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

|CallID|UCID|GroupID|

===============

| 1230 |aaaa| 12 |

| 1230 |bbbb| 12 |

| 2520 |bbbb| 12 |

| 5555 |bbbb| 12...

Cheers for this.

Kind regards

Talk about timing......

I have just created a server health check process that runs every morning, this health check is stored in a scheduled DTS package and it needed to be...

Thanks for this.  If this is the case anyone help with following then:

The data is pulled from an IVR Unix box in a flat file format:

CallDate, Calltime,InVDN, outVDN, MIpoint1, MIpoint2, MIpoint3.....

The...

Thank you, the issue was down to the default language of the domain account running the job.

Once again thank you!!!!!!!

Forgot to add that the collation for all databases and tables are set to SQL_Latin1_General_Cp1_CI_AS

Try using an "SQL Server Performance Condition Alert" from the Alert section in Enterprise Manager, this is found under "management" - "SQL Server Agent" - "Alert".  In here you can specify...