I have one server in domain and another is in workgroup.

The one which is in Domain on that server i am executing the query and the procedure is on server which is in work group environment.