Hi John

I am not sure I am following everything, should we be enabling guest access? Guest statuses on all userdatabases are 0

Our DBs have DB Chaining...

All Databases have the same owner. I have even tried DB_CHAINING. We do use this a bit at clients as well.. As stated before the SuperUser is db_owner(note db_owner role, not...

What is frustrating is in one environment it is working perfectly, in the others not. We have tried creating a new Super User from scratch(changing the procedure accordingly), this even...

Sorry about that, was a bit of a rush.
We have a DB(call it DB2) where 3rd parties sign in with views pointing to other databases(call it DB1) through synonyms....

Thanks, I thought it would be like that. Thanks for the confirmation

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