JusticeVan Posted October 16, 2009 Share Posted October 16, 2009 Rather new to SQL and before I go barking completely up the wrong tree in tracking down a solution, I want to find out if what I am attempting is even possible in MS SQL 2005 or 2008.Is there a way to have fields in one database, somehow mapped or linked to another for simultaneous, or nearly so, updating?ExampleDb1.table1RecIDNameAgeDb1.table2RecID1RecIDEyecolorHaircolorDb1.table3RecID2RecIDWeightHeightDb2.table1RecID3RecIDNameAgeEyecolorHaircolorWeightHeightThanks for any info on this. Link to comment Share on other sites More sharing options...
chibineku Posted October 16, 2009 Share Posted October 16, 2009 Hm...I think you want to look into stored procedures/transactions, which will automate the process of updating more than one table. Link to comment Share on other sites More sharing options...
JusticeVan Posted October 29, 2009 Author Share Posted October 29, 2009 Thanks for your response. I was thinking along the lines of a trigger and I've found some info regarding doing this between linked servers. However, the situation is that I'm wanting to run the trigger on one database, in order to update another database with some of the information, on the same server. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.