Strange Error

Giganews Newsgroups
Subject: Strange Error
Posted by:  NumbLock (gal…@hendersonsystemsinc.com)
Date: Mon, 4 Apr 2011

Hello.  I have the following proc:

USE [IISLogs]
GO
/****** Object:  StoredProcedure [dbo].[ShowInetLogs]    Script Date:
04/04/2011 10:14:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[ShowInetLogs]

AS
BEGIN

    SET NOCOUNT ON;
/****** Script for SelectTopNRows command from SSMS  ******/
SELECT [ClientHost]
      ,[ipinfo].[ResolvesTo]
      ,[username]
      ,[LogTime]
      ,[service]
      ,[machine]
      ,[serverip]
      ,[processingtime]
      ,[bytesrecvd]
      ,[bytessent]
      ,[servicestatus]
      ,[win32status]
      ,[operation]
      ,[target]
      ,[parameters]
  FROM [IISLogs].[dbo].[InterNetLog]
  INNER JOIN ipinfo ON ipinfo.IPAddress = internetlog.ClientHost
  ORDER BY LogTime ASC

END

It gets created successfully but when I try to execute it I get the
following:

Msg 4104, Level 16, State 1, Line 3
The multi-part identifier "ipinfo.ResolvesTo" could not be bound.

Anyone have any ideas?  This is SS 2008R2 I am working with.  When I
execute the query in the sql editor, it works correctly.

Thanks,

NumbLock

Replies