Prev: Change Data Capture: Preserve capture instance data when adding co
Next: SQLIO crashing Windows 2008 R2 cluster
From: Plamen Ratchev on 17 Apr 2010 09:50
What do you get when you run the following query:

SELECT image_data
FROM OPENROWSET(BULK N'M:\Data\My Pictures\EG\CAI\019_19.JPG', SINGLE_BLOB) AS T(image_data);

Also, using Access linked DB is not the best way to view SQL Server data. I suggest to query directly in SSMS query.

--
Plamen Ratchev
http://www.SQLStudio.com
 | 
Pages: 1
Prev: Change Data Capture: Preserve capture instance data when adding co
Next: SQLIO crashing Windows 2008 R2 cluster