Unanswered: LINKED_SERVER query failed after install Slammer Virus hotfix
The following code works on SQL 2000 with SP2, but not with SQL 2000 SP2 with the Slammer Virus hotfix. Does anyone have any ideas about how to get this working without changing the code. Will SP3 solve the problem or will it add other ones.
dc1.CalendarDate between '2 Dec 2002' and '2 Dec 2002'
and dc2.CalendarDate = (select
max(dc3.CalendarDate) as maxCalendarDate
dc3.CalendarWorkingDay = '1'
and dc3.CalendarDate <= dc1.CalendarDate)
The error message is
Server: Msg 207, Level 16, State 3, Line 1
Invalid column name 'Col1027'.
Server: Msg 8180, Level 16, State 1, Line 1
Statement(s) could not be prepared.