+ Post New Thread
Page 2 of 2 FirstFirst 12
Results 16 to 18 of 18
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 ...
  1. #16

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,410
    Thank Post
    368
    Thanked 639 Times in 521 Posts
    Rep Power
    158
    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.

  2. #17
    MACIT's Avatar
    Join Date
    Sep 2008
    Posts
    51
    Thank Post
    1
    Thanked 1 Time in 1 Post
    Rep Power
    0
    Where can i find this mystical Reindex patch as think it would help with our 9GB database and very slow access to marksheets.

  3. #18
    Guest

    Join Date
    Jun 2009
    Posts
    3,754
    Thank Post
    1,458
    Thanked 490 Times in 375 Posts
    Rep Power
    0
    Quote Originally Posted by MACIT View Post
    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.

SHARE:
+ Post New Thread
Page 2 of 2 FirstFirst 12

Similar Threads

  1. [SIMS] Sims.Net Exam results patch
    By RichB in forum MIS Systems
    Replies: 1
    Last Post: 16th August 2011, 10:22 AM
  2. Replies: 5
    Last Post: 31st May 2010, 08:26 AM
  3. sims.net patch
    By Avalon in forum MIS Systems
    Replies: 1
    Last Post: 30th November 2009, 10:13 AM
  4. Patching SIMS against conficker
    By m1ddy in forum Windows
    Replies: 17
    Last Post: 26th March 2009, 09:13 AM
  5. Replies: 0
    Last Post: 13th May 2008, 06:46 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •