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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-08-29 : 18:55:17
|
| ekachai writes "In query analyzer it work withSELECT a.*FROM OPENROWSET('SQLOLEDB','sql';'sa';xxx', 'SELECT * FROM friends.dbo.account order by firstname desc') AS a inner join buyhellos_product.dbo.customer as b on a.faid=b.customer_id.,But in store procedureCREATE PROCEDURE SP_GET_USER_FROM_FRIENDS AS SELECT a.* FROM OPENROWSET('SQLOLEDB','sql';'sa';'xxx', 'SELECT * FROM friends.dbo.account order by firstname desc') AS a inner join buyhellos_product.dbo.customer as b on a.faid=b.customer_idit error with message "error 7405: Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options to be set for the connection. This ensures consistent query semantics. Enable these options and then reissue your query."" |
|
|
|
|
|
OPENROWSET ?