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 - 2002-11-20 : 08:00:26
|
| Adrian writes "Hello,I have access to a stored procedure on a SQL server on which I have no other rights. I must import the data returned from this sp onto another SQL server via an automated scheduled mean.Unfortunately, the SP won't return any row when used in a DTS batch. The sp works fine on direct execution, in Query Analyzer for instance, but there is no way to make it work on DTS. The problem seems to be with server side cursors used to build the sp but I can't do nothing about it.Do you have an idea? I fight with that problem for weeks now but I'm helpless.Best regards.AdrianJunior SQL user." |
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2002-11-20 : 11:46:16
|
| What access do you have on the other SQL Server?Have you tried creating the DTS on the receiving sql server?Have you tried linking the two servers?If all this fails then you can try windows scheduler, osql to write stored procedure results to text file and then bcp to destination sql server.http://www.sqlteam.com/item.asp?ItemID=744Edited by - ValterBorges on 11/20/2002 11:48:41 |
 |
|
|
|
|
|
MS DTC Problems