whitejames

Thanks @vikpaw I will try this later today will have to kick users off to do this.

It comes up with osql does not support all features of SQL Server 2008 R2. Use sqlcmd instead.?

We are just setting up a new SQL 2008 R2 Server I did a restore of the SIMS db but it does not show the security/roles within SQL how do I get this to be brought across as I want to test a workstation on the new test Server.

When will a patch be available I have staff that cannot update the registers and I keep getting faults and timeouts all the time the processing time is 80% and above most of the day. @PhilNeal who is best to speak to so we can get this resolved as I have ofsted coming in and the attendance staff and teachers need to get access to reports quickly and SIMS is just plain not responding.