Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
RPC Problem - 'Cant not relay on Stored Procedure...'
When trying to execute a remote stored procedure I'm getting this error: Server: Msg 7221, Level 18, State 2, Line 0 Could not relay results of procedure 'Insertalo' from remote server 'ISPSERVER'. The RPC flag is maked at both Server , and I can do any thing but this. Both Server are 7.0 but...- epalacios
- Thread
- Replies: 0
- Forum: Microsoft SQL Server: Programming
-
Error Handling between two Servers
Hi this is the cass: SERVER A: Executes the following INSERT INTO SERVERB.DB.owner.TABLE VALUES ('23232') IF @@ERROR != 0 PRINT 'An Error !!!' The sentence produces an error , but when I check the value of @@ERROR , this is equal to zero. I tried to use distributed transactions but it...- epalacios
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Programming
