Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sovixi
Starting Member
1 Post |
 Posted - 2009-02-17 : 17:42:17
|
| Is there any chance to add picture to image in SQL without using BULK?When I am using this query I get this message:"You do not have permission to use the bulk load statement"INSERT INTO PHOTOS (tx_photo1) SELECT * FROM OPENROWSET(BULK N'h:\photo.jpg', SINGLE_BLOB) AS i |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-02-17 : 17:54:29
|
It means you are not authorized to bulk load data.Ask your DBA to grant you permission to bulk load.
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
|
|
|
How to add picture to image column in SQL 2005