"tshad" wrote:

> I have a stored procedure that works fine.
>
> I take the code and move it to Query analyser and I get a message saying my
> Variable is too long.
> ********************************************************
> Declare @FromDate DateTime,
>  @ToDate DateTime,
>  @Sql VarChar(8000)
>
> Select @FromDate = '09-13-06',@ToDate = '09-13-06'
> Select @Sql = "
>  Select HistoryLogID,SessionID,hl.UserID,p.CompanyID,hl.ApplicantID,
> **********************************************************
>
> Server: Msg 103, Level 15, State 7, Line 6
> The identifier that starts with '
>  Select HistoryLogID,SessionID,hl.UserID,p.CompanyID,hl.ApplicantID,
>   HistoryFullName=hl.FirstName + ' ' + hl.LastName,Histo' is too long.
> Maximum length is 128.
>
> It is talking about @Sql (I assume).
>
> Is this a limitation of Query Analyser?
>
> Thanks,
>
> Tom
>
>
>