Timeout Sql error on updating school

[Brian Lewis]

School save reports a SQl timeout.

[Ghislain Hachey]

Closed by pull request #31

[Ghislain Hachey]

Reopening this as I am still seeing some odd timeouts.

[Ghislain Hachey]

Funny enough. Here's some observation while wrapping up the dialog for add new school.

• Timeout I think only occurs on creating new ones. Eventually if I keep trying it may work but this is a very frustrating experience and the timeout takes a long time every time.
• Timeout don't seem to happy at all on update of school. I have not seen one since the permission pr yesterday.

[Brian Lewis]

To dig into this, open the SQL Profiler from the Tools menu in SSMS. Create a new trace to observe what is happening. You should see this INSERT statement:

Try cutting and pasting the entire text of that command into SSMS and running it from there - may help to isolate if there is a security issue in the session or something.

[Ghislain Hachey]

I am not sure what the problem was. I removed all SQL server related stuff from computer and re-installed only SQL Express 2012. I since have not seen the error once.

[Ghislain Hachey]

Reopening this sadly. Will obverse the SQL trace though for some reason this is not showing under tools as it should be.

[Ghislain Hachey]

Seems I only installed the engine and missing a bunch of tools. Argh, will have to download the 1GB SQLManagementStudio. But this seems like a driver or lib problem. I don't know why I would get this and not you if not because we are using some different versions of binaries somewhere.