Haha lol, yer, what we all do isn't - YOU MUST DO IT AS SYSMAN, oh that didn't work, try it as SA.
Application roles - that's the jobbie. The patch is applied via DBUpgrade which if I remember correct either uses Windows Authenication or normal SQL logins if the user is "sa" otherwise it uses application roles.
Point still remains sims users - including SYSMAN shouldn't be able to truncate the log file or change the recovery model - I mean if the error was because my recovery model was FULL and my log file had filled my drive - I'd rather fix my backup (so it truncates the log file onces it's done a full backup) so it doesn't happen again.
Where can i find this mystical Reindex patch as think it would help with our 9GB database and very slow access to marksheets.
Request it's release from Capita or your local LA support unit, then apply it via SOLUS2. :)
Originally Posted by MACIT