Jump to content

Question About Multiple Databases


JusticeVan
 Share

Recommended Posts

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

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

  • 2 weeks later...

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

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...