The other option would be to grant them access to modify the job schedule only. Have given them access to the SQL Agent roles in msdb, they can view and...

Will have a look at it. I saw a lot of BEGIN, ROLLBACK and COMMIT, don't worry those are part of all my standard code, just did not include that.

Will...

Gail. I would like to get your ideas on error handling in this specific case, not worked much with it

Thanks Louis

Thanks to all the guys for their input, Looking at each of them, and I definitely have a lot to work towards, step by step though

Scoot, thanks, I will investigate what you said

I am determined to get fragmentation down, with some tables still over 70 % fragmented I need to do something, as stated previously the company is still fighting for some...

I got fragmentation stats after the Table rebuild and then after index rebuild. Still had a lot of fragmentation.

Ideally I would love to have Clustered indexes but it was already...

I did rebuild before this, but still there were tables with over 80% fragmentation

Douglas

This the script I use, works quite nicely. I did the table rebuilds this weekend at one of our clients and then did index rebuilds. My forwarded records are all...

Heap tables yes, basically all our indexes except for one is Non Clustered. This is part of the problem. I have inherited it like this

We found that fixing this brings fragmentation down by anything from 0-60 % after doing table rebuilds, after rebuilds we staill have fragmentation on tables and indexes. We are using...

The problem is that the Database is originally from an ETL from a Adabas database, so we have hundreds of tables being created, most of the child tables have a...

Looks like I missed something, is running on same server, the package was running to SQL server destination, which I have started moving away from

I also get this error on SQL 2012, I am using OLEDB Destinations. I am trying to run 5 inserts at the same time, is the issue just pointing to...