Referential Integrity

Hi

how to set the referential integrity between 2 tables using enterprise
manager (microsoft SQL SERVER).. i tried and the tab doesn't allow me
to choose. pls.help.

thanks
sree

--
chavasreedhar
Message posted via http://www.exforsys.com for all your training needs.Do you have primary keys on your tables? This is a requirement for the
referenced table of the relationship. It is also a Best Practice for all
relational database tables.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"chavasreedhar" <chavasreedhar.20gug3@.no-mx.forums.yourdomain.com.au> wrote
in message news:chavasreedhar.20gug3@.no-mx.forums.yourdomain.com.au...
> Hi
> how to set the referential integrity between 2 tables using enterprise
> manager (microsoft SQL SERVER).. i tried and the tab doesn't allow me
> to choose. pls.help.
> thanks
> sree
>
> --
> chavasreedhar
> Message posted via http://www.exforsys.com for all your training needs.