Does this work for anyone??....Can someone please test the code on your local box and let me know??...Thanks

Lowell (8/25/2014)

---

correct me if i'm wrong, but I thought noone can write to a file on the root of the C drive unless they are running elevated, admin priviledges:

so C:\CambridgePubs.xlsx...

LutzM (8/24/2014)

---

What permission does the user have who's running that code?

Based on MS Technet

Only members of the sysadmin fixed server role can execute sp_OASetProperty.

If you're not a member of the...

Permissions don't seem to be the issue either. I am doin this on my laptop. There is only one user on my laptop. So, permissions are also fine.

Please help...

Eirikur Eiriksson (8/24/2014)

---

vinu512 (8/24/2014)

---

Eirikur Eiriksson (8/24/2014)

---

Further on Lutz's question, what is the output of the code in your initial post? Note that all the sp_OA* procedure return 0 if successful,...

Eirikur Eiriksson (8/24/2014)

---

Further on Lutz's question, what is the output of the code in your initial post? Note that all the sp_OA* procedure return 0 if successful, otherwise a non-zero...

Hi LutzM,

Following is the error message:

Operation is not...

Eirikur Eiriksson (8/24/2014)

---

Quick thought, looks to me that the only thing missing is to enable Ole Automation Procedures

😎

Enable Ole Automation Procedures in T-SQL

sp_configure 'show advanced options', 1;

GO

RECONFIGURE;

GO

sp_configure 'Ole Automation Procedures',...

Phil Parkin (8/11/2010)

---

No...

So...is there no way of doing it??

Guys,

Any Luck???

I haven't been able to find a way around this one yet.....Any help guys??

Shadab Shah (7/17/2013)

---

vinu512 (7/16/2013)

---

Is Auto Update of Statistics on the Database Disabled??....Check both AUTO CREATE STATISTICS and AUTO UPDATE STATISTICS.........If any of them are disabled then enable them as follows:...

Shadab Shah (7/17/2013)

---

kapil_kk (7/17/2013)

---

vinu512 (7/16/2013)

---

Is Auto Update of Statistics on the Database Disabled??....Check both AUTO CREATE STATISTICS and AUTO UPDATE STATISTICS.........If any of them are disabled then enable them as...

Very nice work Alan.

I converted Alan's code to work Dynamically(Just in case you have more than 2 tables) as follows:

IF OBJECT_ID('tempdb..TargetActivity') IS NOT NULL

DROP TABLE TargetActivity;

CREATE TABLE Customer

( CustomerId int...

Is Auto Update of Statistics on the Database Disabled??....Check both AUTO CREATE STATISTICS and AUTO UPDATE STATISTICS.........If any of them are disabled then enable them as follows:

-- Enable Auto...