i fallow again another guide
i fallow true same that guide but my sql give fail and different ... how ??
You are better off checking the server logs for error message than posting half a stored procedure and asking why it doesn't work. What you have there is only part of it.
It is probably a bad linked server setting so i need the logfile error message.