TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Kiran Jagathlal
NA
1
1.5k
Execute stored procedure remotely
Dec 17 2013 7:24 AM
Hi Everyone,
I am new to sql and just wonder if there is someone out there who could help me out.
I have two sql servers: server A and Server B.
Server B has the databases residing on them, and Server A has the sql agent. I have sql jobs that are on Server A, what I would like to know if I could remotely execute these store procedures( the jobs execute the store procs) on Server A. The jobs are on Server A and the store procs are on Server B.
I have already linked Server B to Server A. Is this possible?
Thanks,
Cheers
Kiran
Reply
Answers (
1
)
Is dere any ebook for SQL Server 2012 administration as 462
How to fast acces data from database in ms sql server 2008