I have noticed that we now do not have a view in SQL Views called v_servicecalls - it was there when we originally installed the system as I utilised it a lot for reporting (copy / pasting the SQL code out then using it in ASP web reports but the view isn't there now ... I am not sure when it vanished.
(We upgraded from SP2 to SP6 a couple of years ago.)
I have tried regenerating views which comes back OK but when checking in SQL Views again, it still isn't there.
Any ideas or if anyone else has experienced this (or if they can check their system if they run SP6) would be greatly appreciated.
Thanks very much chaps. Ken, you were spot on with the SQL reserved words issue - I had a custom field called TIME - now remaned and the regeneration of views now has brought back my Service Calls view.