October 12, 2016 at 10:27 pm
How can I export my attachments from image data type in SQL.server 2008 without using xp_cmdshell?, I have researched myself and found solutions with xp_cmdshell or SSIS or .net code, isnt there any way to just do it from SQL server alone?
Have done exports from BLOB data type easily in oracle, is it not possible in SQL server 2008 ?
Please help
October 13, 2016 at 10:35 am
depakjan (10/12/2016)
How can I export my attachments from image data type in SQL.server 2008 without using xp_cmdshell?, I have researched myself and found solutions with xp_cmdshell or SSIS or .net code, isnt there any way to just do it from SQL server alone?Have done exports from BLOB data type easily in oracle, is it not possible in SQL server 2008 ?
Please help
One way is to BCP out the data. Prefix-length for the column should be set to 0
Sue
October 13, 2016 at 10:22 pm
But as far as i know to use BCP I need xp_cmdshell right ? Let me know if BCP can be used without xp_cmdshell And if so How?
October 14, 2016 at 2:46 pm
depakjan (10/13/2016)
But as far as i know to use BCP I need xp_cmdshell right ? Let me know if BCP can be used without xp_cmdshell And if so How?
It needs to be enabled to use BCP.
Sue
October 14, 2016 at 4:48 pm
I keep getting I do no have execute permission for xp_cmdshell, so I can't really use them
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply