Thanks I got it working using certificate. Question though...How about linked server? If I have the proc loads records in a table in different server?