Results 1 to 1 of 1
  1. #1
    Join Date
    Oct 2002

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

    Many thanks

    select *
    aLinkServer.MISDatamart.dbo.dimCalendarTbl dc1,
    aLinkServer.MISDatamart.dbo.dimCalendarTbl dc2
    dc1.CalendarDate between '2 Dec 2002' and '2 Dec 2002'
    and dc2.CalendarDate = (select
    max(dc3.CalendarDate) as maxCalendarDate
    aLinkServer.MISDatamart.dbo.dimCalendarTbl dc3
    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.
    Last edited by IainC; 02-24-03 at 09:04.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts