I personally know of no restrictions to this.

Allan

why do i get this error then ?

"Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'SQLOLEDB' reported an error.
[OLE/DB provider returned message: Unspecified error]
[OLE/DB provider returned message: The stored procedure required to
complete
this operation could not be found on the server (they were supplied with
the
ODBC setup disk for the SQL Server driver). Please contact your system
administrator.]
OLE DB error trace [OLE/DB Provider 'SQLOLEDB'
IDBSchemaRowset::GetRowset
returned 0x80004005: ]."

is anyone can help me ? please ?

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

What type of linked server?

An ODBC source?

If yes then you must have drivers capable of supporting that source on
the server.

Allan

"Suwito Kurniawan" <suwito (AT) adira (DOT) co.id> wrote