OPENROWSET and SINGLE BLOB in SQL SERVER 2005 -

OPENROWSET and SINGLE BLOB in SQL SERVER 2005 -

i using sqlserver 2005 here wrote simple mass image upload query using openrowset single blob function. query not executing. showing t-sql not back upwards sql server 2005 , below version.

here using query like,

create table student_images(image_id int identity,images image primary key(image_id)) insert student_images(images) select * openrowset(bulk n'e:\coe\images\uhsa1406.jpg',single_blob) images

can u suggest reference link. in advance :)

judging actual error message posted in comment, seems trying run query sql server management studio higher version server running. because thge machine you're attempting run query has later installation.

to resolve error, install 2005 sql server management studio, or run query straight on server using sql server 2005 management studio.

sql-server sql-server-2005