How to run a stored procedure on SQL 2005 remote server?

hi,
i want to run one stored procedure on a remote SQL Server 2005, from
my machine.
can any one explain how to do this?
thanks
KartheekHi Kartheek
"karthee" wrote:

> hi,
> i want to run one stored procedure on a remote SQL Server 2005, from
> my machine.
> can any one explain how to do this?
> thanks
> Kartheek
>
You don't say which edition of SQL Server 2005 you are using? If you have
SSMS then you can either connect directly to the server and run the
procedure, or create a linked server and run the procedure using four part
names or OPENQUERY etc. for more information check out books online. If you
have SQL Express you could use SQLCMD.
John