XPost: microsoft.public.sqlserver.programming   
   From: genew@ocis.net   
      
   Happy New Year:   
      
        It appears that IsDeterministic() and IsPrecise() return 1 only   
   when (necessary but not sufficient condition) WITH SCHEMABINDING is   
   specified in the function declaration.   
      
        A function that always returns the same value given the same   
   parameters is deterministic.  In my Web searching, someone gave an   
   example of a function that always returned 1 being considered   
   non-deterministic.   
      
        What gives?  Why is WITH SCHEMABINDING required?   
      
   Sincerely,   
      
   Gene Wirchenko   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)