If the stored procedure is performing a join between any two databases with different collations on certain data types you'll get this issue. You can force it to try...

Hi,

If I've understood correctly:

SELECT

* --replace with what you want if not all

FROM

recent_student RS

JOIN

recent_student_graduate_2330 SG2 ON RS.individual_id = SG2.individual_id

JOIN

recent_student_professional SP ON RS.individual_id = SP.individual_id

JOIN

recent_individual RI ON RS.individual_id =...

There are some known issues with SQL2005 upgrade advisor on a cluster, but I think the errors you're seeing are more security based.

Try running as a user with both sysadmin...

I started to type a response, but though this link did it much better. The other thing you need to ensure is that your logins from the primary are...

You could always remove the built in notifcation and create a new TSQL job step such to be something like:

If SQLMail is configured:

exec master.dbo.xp_sendmail

@recipients = 'SQLAlerts@mycompany.com',

@Subject = 'master backup...

For this I'd make the assumption that a 0 for a day means that nothing happens.

P.S, I finished ealy too 😛

That's spot on Jack.

Thanks for the responses guys. I'm still trying to solve this myself too.

First one to a solution get's to go home early?

Ah, I'm liking the soltion, but comany 3 should take the longest...

It makes more sense if I explain the [DaystoDeliver]. It is the number of days that a delivery...

I'll gladly buy you a pint sir, if you can tell me what date the item will be delivered! I'm not catching your drift on the solution ... Fridays...