from client how to access remote stored procedures

hai all
can any one give syntax in sql server like
how to access remote stored procedures ?
wheather we have to set any permissions in client machine to access the
remote stored procedure
please give solution (sytax or procedure ) how to access from sqlserver
Thanks & Regards
SVG SRINIVASThat depends on your coding language, what are you using ?
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"S V G Srinivas" <svgsrinivas@.dev.visualsoft-tech.com> schrieb im
Newsbeitrag news:uqm50%23zZFHA.2796@.TK2MSFTNGP10.phx.gbl...
> hai all
> can any one give syntax in sql server like
> how to access remote stored procedures ?
> wheather we have to set any permissions in client machine to access
> the
> remote stored procedure
> please give solution (sytax or procedure ) how to access from sqlserver
> Thanks & Regards
> SVG SRINIVAS
>|||Hi
Check out the topics "How to set up a linked server", "Configuring Linked
Servers" and "Distributed Queries" and "Accessing External Data" in Books
Online.
John
"S V G Srinivas" <svgsrinivas@.dev.visualsoft-tech.com> wrote in message
news:uqm50%23zZFHA.2796@.TK2MSFTNGP10.phx.gbl...
> hai all
> can any one give syntax in sql server like
> how to access remote stored procedures ?
> wheather we have to set any permissions in client machine to access
> the
> remote stored procedure
> please give solution (sytax or procedure ) how to access from sqlserver
> Thanks & Regards
> SVG SRINIVAS
>