Hi,
     I have created a function test under the user name tom.dick under the database TELEVISION.

     I executed the following sql in the query analyzer
SELECT TOP 1 CLIENT_NO, ACCOUNT,
    tom.dick.test(CLIENT_NO),
    tom.dick.test(CLIENT_NO)
FROM test_table
ORDER BY CLIENT_NO

I get the following error
Invalid object name 'tom.dick.test'.

I change the SQL to the following
SELECT TOP 1 CLIENT_NO, ACCOUNT,
    TELEVISION.tom.dick.test(CLIENT_NO),
    TELEVISION.tom.dick.test(CLIENT_NO)
FROM test_table
ORDER BY CLIENT_NO

I get the following error
The object name 'TELEVISION.tom.dick.' contains more than the maximum number of prefixes. The maximum is 2.

Please let me know as to how I solve this problem.

Thanks in advance

I think the format here should be:

server.owner.object

Therefore the name tom.dick is causing problems. If Tom.Dick is the owner of the object then i suggest you try [tom.dick].Test(Client_No).

I have never used a function before and this sytax may have changed in SQL2K where you can have more than server running on a single machine.

Comments anyone?