MIS Systems Thread, SIMS Reindex Patch in Technical; Haha lol, yer, what we all do isn't - YOU MUST DO IT AS SYSMAN, oh that didn't work, try ...
22nd February 2013, 11:01 AM #16
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.
26th March 2013, 02:31 PM #17
Where can i find this mystical Reindex patch as think it would help with our 9GB database and very slow access to marksheets.
26th March 2013, 02:48 PM #18
Request it's release from Capita or your local LA support unit, then apply it via SOLUS2.
Originally Posted by MACIT
By RichB in forum MIS Systems
Last Post: 16th August 2011, 11:22 AM
By vikpaw in forum MIS Systems
Last Post: 31st May 2010, 09:26 AM
By Avalon in forum MIS Systems
Last Post: 30th November 2009, 11:13 AM
By m1ddy in forum Windows
Last Post: 26th March 2009, 10:13 AM
By m2d2 in forum MIS Systems
Last Post: 13th May 2008, 07:46 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)