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 |
|
vinny45
Starting Member
1 Post |
 Posted - 2004-04-16 : 18:21:39
|
| Does anyone know how to export multiple images (jpg) in SQL Server and save it to the hard drive. We decided not to store images there anymore but would like to export the existing ones into a folder. We have a solution that uses a aspx page, but we're looking for a solution within SQL SErver tools. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-04-16 : 18:39:28
|
| You can't export images inside SQL Server using SQL Server tools. You must use an application such as VB to do it. BTW, good idea of saving them to the disk instead of inside SQL Server. Storing them inside SQL Server is not recommended.Tara |
 |
|
|
dcarlin
Starting Member
10 Posts |
Posted - 2004-04-21 : 10:54:18
|
| Why isn't it recommended? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-04-21 : 12:28:26
|
| http://www.sqlteam.com/item.asp?ItemID=986Also, search the forums for threads regarding storing images in SQL Server. You'll see it debated here and you'll see people moving away from it as they encounter problems.Tara |
|
|
|
|
|
|
Save SQL Server images to hard disk