DawnL

Hi How about adding the other contacts in (6 Next of Kin, Staff Contacts) and creating Contact Types for them. NoK2 - Next of Kin 2 EmCo - Emergency Contact Staff Contact Type (Tools | Lookup | Maintain) Regards Dawn

Morning Following up on this.... So, our network's been improved. This is the advice I've been given. Our advice is please use Microsoft One Drive as your personal file store and create and save new documents in this space. When the Home Drives are restored and made available, you will be able to access documents in read only mode. This means that you can open and edit documents and should then save them in MS One Drive. You will not be able to save these documents back on the H: drive. Subsequently, I'm trying to create an Analysis report but getting the message "\\[networklocation]\home\[myname]\documents\tempsimsRpt\[MyReport] is denied. Any ideas how I can rectify this - how do I re-direct the location? Thanks Dawn

My mistake, wrong end of the stick I'm afraid. SIMS doesn't work when performing a LogMeIn session only and the client is at 4.8. Apologies. Dawn

Hi SIMS doesn't appear to work whilst .NET Framework 4.8 is installed? You click the SIMS icon and nothing happens. Is this correct? Regards Dawn

Morning Just scanning through our backups (attix) and have noticed that in our list of available databases we have a sims and a SIMS (Offline) database, with the SIMS (Offline) one being ticked for backup. I have a pretty good idea that a migration or anything that uses the SQL tools could create the Offline database temporarily but why would it show for backup and why would it disable the real sims database. Many thanks D

Thanks for the reply. Dawn

Good morning Has anyone experienced any issues with SIMS .net and MS OneDrive, in terms of My SIMS Documents? Thanks in advance. Dawn

Thanks bobsmith and matt40K, didn't mean to open a can of worms. Will look into their technical training? Dawn

Hi I've read quite a few posts now surrounding my query but edugeek posting dates are 2013 and things may have changed. Really appreciate any answers. 1. Trying to de-attach a database and it says users are still logged in. How can I safely de-attach their logins through SQL, can I use the kill command? I am aware of the exec sp_who2 to identify these SIMS users. 2. How can I identify active and stop non-SIMS users (ie. third party app connections) - by viewing processes in Task Manager and ending these? These non-SIMS users were Ended and the server was rebooted. I was then able to do a DBattach on SQL2014. I'm not sure how. However, I had the famous Invalid username/password after re-attaching to SQL2016. 3. I've seen the command osql -S%COMPUTERNAME%\%NEW_INSTANCE_NAME% -Usa -P%NEW_SA_PASSWORD% -n -Q"exec %SIMSDB%.sims.db_p_transfer_login", floating around. When/if/how should this be used? From my understanding the SIMS logins are stored in the master database (old server) which are not then transferred to the new server SIMS database. 4. Are these sort of queries answered in any Capita technical training or do you folks just know it from a standard SQL basis? Thanks for your help. Dawn