thank you very much happycat59 for the advice and happygeek for the links. Will check these out

regards

fiyo (10/9/2015)

---

Hello

I would like to know your views regarding updating Sharepoint data in lists/libraries using SSIS on a "regular" basis, like scheduled jobs every night.

Would Sharepoint databases be corrupted?...

Jeff Moden (4/5/2015)

---

efyuzegeekgurl (4/5/2015)

---

Hi Jeff

Thanks for replying

Thats a good point about not copying the backup file. You are right, I decided to go down the Powershell path because of wanting...

Hi Jeff

Thanks for replying

Thats a good point about not copying the backup file. You are right, I decided to go down the Powershell path because of wanting to copy the...

Hi Grant

Thanks for replying.

Actually on our production server, we have a standard maintenance plan setup that runs the "Check Database Integrity Task" nightly before taking a full backup. ...

Hello everyone,

I posted the same question on technet and already got responses that will help me get started. Check it out if you are trying to find a solution as...

Hi Jason

Thank you for your reply. Where do you see the "execute as" option for the maintenance plan? I cannot find that option in the GUI.

Thanks for letting me know...

hi again manish2070,

Actually in the msdb.dbo.sysssispackages there is no "owner_id" column. There is only the "ownersid" column. Are you referring to the "ownersid" column?

I just realised the SQL Script...

Hi manish2070,

Thanks for your reply. Actually I was just reading a post on changing the job owner using T-SQL: http://www.sqlservercentral.com/articles/Maintenance+Plans/98189/

I'll try that tomorrow at work. The thing I...