There are many ways to get image files into your image column. Among the easiest is the Textcopy utility located in the Program FilesMicrosoft SQL ServerMSSQLBinn directory. Use the command "textcopy /?" to get the command line syntax for this utility.
Another way to get image files in and out of SQL Server is to write your own program using ADO or ADO.Net, or create an ActiveX dll that can be called by SQL Server's sp_OA* extended stored procedures.
Do you have comments on this Ask the Expert Q&A? Let us know.
Dig Deeper on Microsoft SQL Server Installation
Related Q&A from Andrew Novick
If you've had trouble connecting Visual Basic to SQL Server, let expert Andrew Novick offer some basic advice to get you started. Continue Reading
Expert Andrew Novick reveals how to execute a store procedure in one database look at tables in another database. Continue Reading
Expert Andrew Novick determines whether a stored procedure is also a remote procedure call. Continue Reading