create unique index between two databases

[Kudel]

Hi all!

I have two databases that is almost like.
I have a customer field in both databases.
Each customer has a web_user_name that is unique.

I need a unique index that checks both databases.

Create unique index WUN on db1..TestA(web_user_name) and db2..TestA(web_user_name)

Any tips, tricks or hint is appreciated

-Kudel

 

[tlbroadbent]

You cannot create a constraint or index on two databases. You'll have to handle the uniqueness check in code. A TRIGGER may be helpful.

If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

 

[Kudel]

Not surprised, but thanks!

-Kudel