Re: is there any limit to how long of a string SqlDataReader.GetString() can return?

I don't believe there is a limit other than available memory.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"Nathan H. Omukwenyi" <nathan@xxxxxxxxxxx> wrote in message
news:eXO8V8wZGHA.428@xxxxxxxxxxxxxxxxxxxxxxx
Only 8000 characters. No more

Nathan H. Omukwenyi

"Daniel" <softwareengineer98037@xxxxxxxxx> wrote in message
news:uTdm7M2YGHA.500@xxxxxxxxxxxxxxxxxxxxxxx
is there any limit to how long of a string SqlDataReader.GetString() can
return?






.

Relevant Pages

  • Re: Status Column in sysobjects table...SQL2000
    ... Please post a sample proc that demonstrates the ... >> Dan Guzman ... >> SQL Server MVP ... even though there are no compilation errors. ...
    (microsoft.public.sqlserver.programming)
  • Re: Status Column in sysobjects table...SQL2000
    ... The QUOTED_IDENTIFER setting may or may not prevent the proc from being ... > Quoted_Identifiers and/or ANSI_NULLS it would not even compile. ... >> Dan Guzman ... >> SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: Database recovery with data file only
    ... Basically using that command breaks your business logic as there's no ... "Dan Guzman" wrote in message ... >> database Backup as well as ... >>> SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: how to scramble data in a table
    ... >> accomplish this with set-based processing using CASE expressions. ... >> Dan Guzman ... >> SQL Server MVP ... >>> Does anyone have a neat way to scramble data in one table? ...
    (microsoft.public.sqlserver.programming)
  • Re: Read log files
    ... for ad-hoc analysis. ... >> Dan Guzman ... >> SQL Server MVP ... can't we read the log file without this. ...
    (microsoft.public.sqlserver.server)