Sql Express 2005

Well, I tried out Sql Express as the database backend and it's a lot better than anything else I've messed around with.  I can't believe I never knew about it before.  Since I've been working a lot with Sql Server at work for the last few months, it sure felt a lot more familiar.

Now I'm just trying to figure out how to make a foreign key referenced against a table in seperate database.  I thought you would simply add the name of the Db in front of the table, but it doesn't seem to work that way.  I've been looking for information about it on MSDN and Books online but haven't found anything yet.  Anyone know anything about it?

Comments

• Anonymous
  February 06, 2005
  Error message recieved from Sql Express...
  
  "Cross-database foreign key references are not supported."
  
  Bummer. :( Ah well, it's a trivial problem I can work around.
• Anonymous
  February 06, 2005
  Well, its not such a trivial problem: why would you want to do this? That is, why aren't the tables in the same database to begin with? Doesn't sound like a usual design, so you've piqued my interest... :)
• Anonymous
  February 06, 2005
  Well, I was trying to seperate my data and yet keep it shared. The database is storing information about movies, and I wanted a seperated database to store information about actors (in an Entertainers database, which would also hold info about musicians)...that way the data is reusable elsewhere for cases like Will Smith who both writes music and acts in movies. :)
• Anonymous
  April 11, 2006
  The comment has been removed