To Check Primary Key Constr. Accros the database

[tarriqSQL]

Hi all,
1) a company is maintaining seperate Database(s) for each country

2) Invites the user regn from diff. country

3) How to check the Primary key constraint for each user user regn accross all the country databases Dynamically when registering.

4)ie. all users of that company, all over the world are given a unique ID.

5) How to ensure this in MS SQl SERVER 2000,or Oracle
pls HElp
Thanks in adv.
Tarriq

[MAK]

1. use insert/update trigger on the tables and check the tables on other databases using full qualifier like below

select * from databasename.dbo.tablename

or


2. create a database Registration database with a table. put insert trigger on the registration tables on all the database that is going to insert the values on to the registration database by comparing the existing values on the table

or

3. create a database Registration database with a table registration. All the users from different countries log on to this database first and then directed to another database, so that you dont have to have a tedious triggers and maintaining it.

[tarriqSQL]

Hello MAK,
Thanx for the help
Got a good idea from the reply
thanx 1ce again
Regds
Tarriq