Post reply

SQL 2000 MSX To 2008 TSX

  • 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

  • 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.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply