August 20, 2010 at 2:52 pm
I have a control server and want to make changes on all other servers with this server. All the basics are set up like linked servers. I know i can do a select like "select * from [Linkedserver].Test_Db.dbo.TableName" but for create/alter doesnt work. Can someone share there experience on how they do it. Thanks !!!
August 20, 2010 at 3:02 pm
You're probably better off doing something like this:
http://www.sqlservercentral.com/redirect/articles/70939/
I have a few groupings of servers that I run queries against, and it supports any kind of code (create/drop/alter/etc)
August 22, 2010 at 2:18 pm
let me try that and will let you know.Thanks
August 23, 2010 at 1:54 pm
Ok Derrick, i have tested it out. The process looks kool but does only at server level, lets say i need to create/alter a single proc but it has to be sent across server 1(db1,db2,db3...) and sever 2(db3,db4,db5.....).... how can this be done ? Any suggestions?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply