"image" limitation of 510 bytes

Hello,

I have a field in my SQL Server 2000 with type "varbinary(8000)" which I merge onto my SQL CE 2.0 database. On my SQL CE 2.0, this field becomes "image".

Based on Microsoft's site: http://msdn2.microsoft.com/en-us/library/aa257477(SQL.80).aspx, "image" is used if the size is not over 510; however, when I populate this field in SQL CE, the maximum size that is stored is 510 bytes. I have verified my source data was complete (2622 butes) when again when I check the size of the field after an insert, it had only 510 bytes.

What's the work-around?

Thank you.

Try to have a look at this post:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=538886&SiteID=1

|||Thanks. I was using "SqlDbType.Binary" in my Parameters. "SqlDbType.Image" fixed it.

## How to acquire the SQL Server 2000 Performance data? ##

I want to write a application monitering program to collect the SQL
Server 2000 performance data,
such as pages/sec, bytes total/sec, etc, BUT I don't know how to do it
, In Oracle , there are the v$ views and DBA view , which I can find
the information I interested, the question is , is there a similar suit
of view in SQL Server 2000 to provide the performance information ?
Thank you very much, I will be mad by this question, for I have googled
all the day , but in vain(wangzhi0417@.gmail.com) writes:
> I want to write a application monitering program to collect the SQL
> Server 2000 performance data,
> such as pages/sec, bytes total/sec, etc, BUT I don't know how to do it
> , In Oracle , there are the v$ views and DBA view , which I can find
> the information I interested, the question is , is there a similar suit
> of view in SQL Server 2000 to provide the performance information ?
> Thank you very much, I will be mad by this question, for I have googled
> all the day , but in vain

Look at the table sysperfinfo.

In SQL 2005 this changes drastically. SQL 2005 exposes a lot more
information of this kind.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx