| Tony Rogerson 2006-04-07, 11:28 am |
| Please post the stored procedure and the full CREATE TABLE definition -
including indexes, constraints etc...
Tony
--
Tony Rogerson
SQL Server MVP
http://sqlserverfaq.com - free video tutorials
"ZRexRider" <jerryg@ptd.net> wrote in message
news:1144415792.035582.134890@z34g2000cwc.googlegroups.com...
> Hi,
>
> I have a .NET application that I want to save the Config.EXE contents
> to my SQL database for remote review/testing. This config file is
> 3700+ bytes long. I created a field in one of my tables with a VARCHAR
> 4800 and then created a stored procedure that receives a parameter
> (also VARCHAR(4800).
>
> However it fails to write anything if the length of the value that I
> pass is anything greater than 900. If I pass exactly 900 characters or
> less - the data is written to the field. If I pass 901 characters I
> get nothing.
>
> I'm suspicious since it is exactly 900. I seriously doubt it's some
> limitation of MS-SQL so I need a nudge in the right direction.
>
> Thanks
>
|