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 ...
7th February 2011, 01:34 PM #16
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.
IDG Tech News
7th February 2011, 02:05 PM #17
I'm questioning if you are a school, if you are, you're poorly setup.
Originally Posted by Pashers
7th February 2011, 02:20 PM #18
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.
Originally Posted by matt40k
- Matt40k You mentioned you can get it 'wrapped' up with SIMS approval and make reports. How do you go about doing this?
7th February 2011, 09:24 PM #19
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.
7th February 2011, 10:41 PM #20
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.
By localzuk in forum Windows Server 2000/2003
Last Post: 25th September 2009, 10:03 AM
By interele in forum MIS Systems
Last Post: 25th November 2008, 07:35 PM
By SimpleSi in forum *nix
Last Post: 7th March 2008, 10:23 AM
By AlexB in forum MIS Systems
Last Post: 7th November 2007, 10:20 AM
By k-strider in forum Coding
Last Post: 28th November 2006, 01:15 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)