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

(CustomerIdint...

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...