on a slightly different note, can you explain the differences (or what appear to be differences) in the way a function is compiled through Enterprise Manager's function editor, as opposed...

Got it!!

And its relatively obvious.

A lesson to us all, and especially me. In my last post, I highlighted the line that I thought was causing the problem. This...

I didn't have any service packs installed, but have since applied sp1 and sp2.... No change though!!!

Below is a copy of the errant function:

CREATE FUNCTION DBO.GET_PARENTORGANISATIONS(@ORGID INT, @RECLEVEL INT =...

Thanks, but no luck as yet. Shutting down SQL Server doesn't make any difference. If I issue an alter function command, that doesn't make any difference either. ...

The way in which triggers are implemented seem to be different too. In Sybase speak you refrence old values as 'old', new as 'new', whereas in SQL Server you...