>>need to have pictures in a table, never done this before like some ideas. need to make a gui for the user, etc.
>>
>>your thoughts would be helpful....
>>
>>Thanks
>
>Do not store the pictures or any binary file in a table UNLESS you are using SQL2008 Katmai to do this. If you would use Katmai then IMHO store them in database rather than just storing the paths and/or the file itself in a BLOB field. Katmai has many new features and FileStream attribute is just for this type of necessity (if pictures are over 1Mb on the average - otherwise MSSQL suggest directly storing as a varbinary(max) column).
>Cetin

Cetin, I always wonder HOW to keep images OUT of the database when using SQL Server.
I have NO shared folders at all. NO access to any other computer resources. I have only SQL Server IP, username and pass.
The SQL Server could be at the other side of the world. So HOW to save pictures in it?
Believe me I hate to have such files stored in tables.