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-11-26 : 09:41:13
|
| Pradeep writes "I have a scheduled job on SQL Server 6.5 which executes a stored procedure which in turn calls a stored procedure on another SQL Server 7.0 (on MS Cluster Server) via a linked server, it fails at this point giving an error message Msg 8524, Level 16, State 1, Server, Procedure up_feed, Line 266The current transaction couldn't be exported to remote site. It has been rolled back.I have checked the permissions/Security context of the job, but still i get the error message I ran the scheduled task again - same error was reported.I created a command file and executed the task manually it executed sucessfully.I logged on to Query analyzer with the same user id and ran the feed manually. It worked = no error reported & data fed!I ran the scheduled task again. It worked = no error reported & data fed!The error continues when the job is executed by scheduler.Any suggestions?" |
|
|
shyamprasad76
Starting Member
38 Posts |
Posted - 2001-11-26 : 11:38:28
|
| Hi,Try using the UNC naming convention when calling any objects from one server which are on another server. That helped me before.Shyam. |
 |
|
|
|
|
|
SQL Server RPC Error Msg 8524, Level 16, State 1