+ Post New Thread
Page 2 of 2 FirstFirst 12
Results 16 to 20 of 20
MIS Systems Thread, Creating MSSQL scripts in Technical; You do need to be careful with all of this scripting. The SA account completely by-passes every security feature that ...
  1. #16

    Join Date
    Sep 2006
    Location
    London
    Posts
    1,404
    Thank Post
    38
    Thanked 387 Times in 262 Posts
    Rep Power
    85
    You do need to be careful with all of this scripting.
    The SA account completely by-passes every security feature that we have put into SIMS and I wonder if the school fully appreciates that this could be an issue in the future for example you will be able to edit your salary details with no audit.

    There is an IMS feed available within SIMS that automatically updates a number of VLEs. Quite a number of VLEs automatically link to SIMS.

    Capita does not support direct writing to or reading from tables in this way.
    Last edited by PhilNeal; 7th February 2011 at 02:06 PM.

  2. #17

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,522
    Thank Post
    374
    Thanked 677 Times in 551 Posts
    Rep Power
    166
    Quote Originally Posted by Pashers View Post
    but when I run it it still shows them teaching on half term etc. Also it still didn't tell me if it was Mon1 or Mon2, it still came up with both and for the week.
    I'm questioning if you are a school, if you are, you're poorly setup.

  3. #18

    Join Date
    May 2008
    Location
    Cheshire
    Posts
    299
    Thank Post
    49
    Thanked 27 Times in 24 Posts
    Rep Power
    19
    Quote Originally Posted by matt40k View Post
    I'm questioning if you are a school, if you are, you're poorly setup.
    How would this relate to the school setup, it's got the holiday terms and all the information in SIMS, and the query I've created does exactly what I want it to do - the report you showed me didn't do exactly what I want it to do.

    - Matt40k You mentioned you can get it 'wrapped' up with SIMS approval and make reports. How do you go about doing this?

  4. #19

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,522
    Thank Post
    374
    Thanked 677 Times in 551 Posts
    Rep Power
    166
    I'll check it out in the morning, pretty sure it didn't give you a timetable over holidays. Mon1\mon2 etc refers to you having a two week timetable, again, I'll have to check - Green Abbey only has 1 week timetable, but if it gives you just mon, I'm sure it means you have a 1 week timetable.

    Wrapping, no idea what the official route is, I just normally kick who I think can do it until I get it or they direct me the right person (or someone that may know) - refered to as 40k magic.

  5. #20

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,956
    Thank Post
    775
    Thanked 1,487 Times in 1,234 Posts
    Rep Power
    367
    I can vouch for Pashers coming from a school.

    As for the wrap up. For an update I wanted to make, I was told to submit any request to usual support channel, though for me that's quite a nice route to someone v.knowledgeable and who can kick the right behinds to get something done.

    The routine gets written up as a site specific patch, checked and verified then returned. So it can be applied. I'm assuming something similar could happen for your query. However if it's just for your own use, it should be fine.

    Ideally, if you run it against views rather than tables, then at least it's abstracted away from the core data. Plus you'd hope that if the table was modified or the field moved, the view name would stay the same and still present the same data.



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

Similar Threads

  1. MSSQL Timeout
    By localzuk in forum Windows Server 2000/2003
    Replies: 4
    Last Post: 25th September 2009, 10:03 AM
  2. SIMS and MSSQL
    By interele in forum MIS Systems
    Replies: 2
    Last Post: 25th November 2008, 07:35 PM
  3. Help running scripts within scripts
    By SimpleSi in forum *nix
    Replies: 7
    Last Post: 7th March 2008, 10:23 AM
  4. SIMS on MSSQL 2005
    By AlexB in forum MIS Systems
    Replies: 9
    Last Post: 7th November 2007, 10:20 AM
  5. MSSQL Trigger (i think) Question
    By k-strider in forum Coding
    Replies: 3
    Last Post: 28th November 2006, 01:15 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
  •