Please help me out to resolve this issue, I tried several options but unable to get success till now, any
help would be greately apprecaited.
I am generating one image file using xp_cmdshell on SQL Server 2008, the image is not getting generated in the excel file while doing this, the same image generates properly while running the same through command prompt and on SQL Server 2003.
So based on above scenario, I think the problem is not with the code, the problem is with some setting on SQL Server 2008 related to xp_cmdshell command.
Can you please provide me some guidance to resovle this issue, let me know if you have any questions on this.
Thanks,
Shoeb
Check the windows permissions for user, under which the sql server is run
also
check if using xp_cmdshell is not prohibited on the server level by command
exec sp_configure 'xp_cmdshell'
and check that is user running this command is sysadmin or there is set proxy account on ##xp_cmdshell_proxy_account##