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.
| Author |
Topic |
|
rquigley1
Starting Member
6 Posts |
 Posted - 2004-11-19 : 18:32:14
|
| Forgive me for my ingnorance, but I am new to db design. I have come accross a situation in which I would like a column to reference a primary key of another database in the same instance of sql server 2000. I was trying do it with a create statement that references the table in the foreign database with something like this:foreign key (local_id) references foreignDB.foreigntable.foreign_idCan anyon tell me why this is so absurd or how it can be done. Thanks |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-11-19 : 19:54:16
|
| You can do the check on data changes via triggers but that won't help if you restore one of the databases.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
remote foriegn key