Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Maintinence plan

Author  Topic 

ndaniels
Starting Member

1 Post

Posted - 2008-09-30 : 16:55:12
I would like one step of my maintenance plan to run its query against a remote server how might I accomplish this ?

any help is apreciated

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-09-30 : 17:07:35
I don't think you an do this from within a maintenance plan, but to get to a remote server you can use a linked server.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-09-30 : 22:49:12
quote:
Originally posted by ndaniels

I would like one step of my maintenance plan to run its query against a remote server how might I accomplish this ?

any help is apreciated




You can do this by changing connection strings if you have created Maintenance plan like SSIS package.
Go to Top of Page
   

- Advertisement -