using functions on ADP

R

Roy Goldhammer

Hello there

I have an ADP application run for some time at my work.

Suddnly i can't use table_based functions anymore. When I run them they
don't do anything

What can cause it? help
 
S

Sylvain Lafontaine

Well, you don't tell us how you are calling your table based UDF so it's
hard to tell you what might have gone wrong. Maybe a problem with the
schema (dbo., ...); as it's often the case with UDF? Are you working
against SQL-2000 or 2005? With what version of ADP? If it's with ADP 2003,
did this problem appear since the installation of Office Service Pack 3?
 
R

Roy Goldhammer

Whell Sylvain

I'm using ADP 2003 and sql server 2005

All my functions have dbo owner

The problem occur even when I use Database window and Rress function to work

This problem didn't occur before and suddenly it started.

Even when I create new ADP and connect to the database this problem still
occur.

I even restore the database a week ago to point where it works and that even
didn't solve the problem

What can cause it? maybe it something i've installed on my computer?
 
Top