vinu512 (8/24/2014)

---

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

Since you wrote such a long post Tom, I guess you really got it wrong:-P

😎

BTW thanks for the question Steve.

vinu512 (8/24/2014)

---

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

Here is a quick code demonstrating the grouping of the set, not a solution but should get you started. BTW, Itzik Ben-Gan and Dwain Camps have written excellent articles on...

JackTimber (8/24/2014)

---

Hi Eirikur ,

Actually i was trying at my end and due to slow internet connectivity downtown, i was not able reply to you.

Thanks for the solution :-).

I got a...

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, otherwise a...

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

😎

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', 1;

GO

RECONFIGURE;

GO

Good job with the data sample. I wouldn't be too concerned about the size of the SP code, the main concern is to get it working;-)

The following code toggles between...

So the heavy handed single user mode...

Are you using the ONLINE option? If you are, the additional resources required might be part of the problem. If not, in might...

Lynn Pettis (8/23/2014)

---

Eirikur Eiriksson (8/23/2014)

---

rajeshjaiswalraj (8/23/2014)

---

I HAVE TO WRITE ONE STORE PROCEDURE THAT EVERY MIN IT HAS TO CHECK MY SQL INSTANCE IS UP AND RUNNING IF NOT IT HAS...

I am striving to maintain the readability of my code;-)

My concern at this point would be the 4 table scans rather than...

Hmm???

😎

BTW +100 for the soapbox...

Out of plain curiosity, what is this database used for?

😎