Posted by ZRexRider on 09/29/92 11:44

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

• Next in forum: Re: SQL Server needs help from MS Access (or something)
• Prev in forum: Re: SQL: how to display top 5 then sum the rest
• Thread view: Help: 900 byte limit on stored procedure parameter?

[Reply to this message]