Hi,

In MS Access, we can insert image in the table by using right click + insert object on OLE datatype.

But, SQL Server, we don't have option to do that.

Please let me know about it.

Thanks.

You need to use the image data type (there is no OLE Data type in SQL Server). Like with Jet the SQL table only holds a 4 byte pointer to the images which are stored in data pages.

Regards

Jon