I am very new to SQL Server 2008 and question may look very basic to gurus.
Following in the problem universe.
- I have a huge (600 GB size) SQL Server 2008 table that stores
- Need is to download all the images from database table to my desktop (not on to the server).
- I can't run C#, ASP.NET etc in the environment and has to rely on SQL Server Management Studio for the job (I see a option called power shell but not sure how to use it)
Table looks like following
Table name :
FileID (PK, int, not null) Owner (int, null) file_name (varchar(50), null) file_type (varchar(50), null) file_size (int, null) file_date (datetime, null) file_BIN (image, null)