If the table is duly ever updated I would suggest removing the identity and adding a trigger to assign the pk for inserts. Easy fix but not recommended on tables...

Hey, I was just providing an example of the code you could use to select this information, as in teach a man to fish......refining the logic should be up to...

I am assuming that you are recording the data for each absent day. If this is the case you just need to select the data for the student absent...

One other thing you can do is check windows event log and see if there are any disk errors reported.

Easiest way would be to do a dirty read, if you are not concerned about selecting uncommited data. But you will still need to resolve the underlying issue, which...

Hi Mike, first of all I have never been a fan of the upgrade, always selected a side-by-side, I find it causes less hassle, having said that this is what...

Are you running IIS on the same box as SQL, if so, perhaps you could move it to another VM. A good Idea to isolate things. Also, if...

SQL 2008R2 should install .NET3.5 if it is not present, as it is mandatory, so very odd that it is not appearing in your control panel, have a look in...

Not yet for R2, but SP2 is available for 2008

Windows 2008 clustering is TOTALY different to Windows 2003. Remember it's Windows clustering not SQL clustering. If I were you try to migrate from your Windows 2003 cluster.

I would capture the code being executed through profiler and try to determine if it is a permissions issue.

From everyhting I have ever been told, denys always superceed grants

Interesting one. You said that you migrated from 2005, is the user database in 2008 compatability mode?

If you are talking about the database level, well that is up to yourself, but generally all job failures, and database status should be monitored. I would also alert...

That is a nasty one. If I were you I would stop the sql instance and move or rename the data and log files and start SQL again and...