Stored proc to execute on a different SQL SERVER

[sujal]

Can I write a procedure that should connect to a different SQL server and execute a series of SELECT statement on that SQL SERVER.

Reason being is I do not have permission to create procedure on that destination server while I have permission to execute a SELECT statement. Please clarify

Thanks,

 

[mrdenny]

Yes provided that you have a linked server from the server you can create the stored proc on to the server with the tables.

Otherwise you'll want to request access to create stored procedures. Perhaps if you ask the DBA they will put your procedures on the SQL Server for you.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[sujal]

How to have a linked server from the server. Also how should I refer to tables in my proc?
Thanks