Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 UDF Calls Across SQL Servers

Author  Topic 

Plaid_Dragon
Starting Member

7 Posts

Posted - 2009-02-05 : 16:13:21
Is it possible?

I'm trying to call a function on another server and get the following error:

The object name 'servername.databasename.dbo.' contains more than the maximum number of prefixes. The maximum is 2.

My code syntax is:
SELECT servername.databasename.dbo.functionname()

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-02-05 : 16:17:54
See if you can wrap the call into a stored procedure and then just call the stored procedure instead.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-02-05 : 16:31:21
See this:
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=69926
Go to Top of Page
   

- Advertisement -