SQL 2000 MSX To 2008 TSX

• bruce.l.pettus

  Old Hand

  Points: 366

  More actions

  January 21, 2010 at 12:31 pm

  #229273

  Ya, ya, ya - I know I'm still using a SQL 2000 MSX :crazy:. I'm working on it.

  Anyway, is it possible to push jobs to a 2008 TSX from a 2000 MSX? I'm able to point the 2008 TSX at the 2000 MSX but my jobs are not getting processed. The MSX is reporting unread instructions by the 2008 instances. Am I missing something?

  thanks

  BLP

• bruce.l.pettus

  Old Hand

  Points: 366

  More actions

  January 21, 2010 at 2:05 pm

  #1106958

  I'm on to something. I checked the agent log and it was complaining about a syntax error near "(". I ran the Profiler against the activity between the TSX and the MSX and it showed a call to sp_execsql where the query was similar to "select top (@p1)". The TOP clause in SQL 2008 includes the parenthesis where it doesn't in SQL 2000 - hence the syntax error. Now I need to figure a way around it.