Thanks ....

"Erland Sommarskog" <sommar@algonet.se> wrote in message
news:Xns940E15C48E6CYazorman@127.0.0.1...
> Rob Panosh (rob_!!!NO!!!SPAM!!!_panosh@asdsoftadfdware.com) writes:
> > In MSS 2k can Primary Key, Unique Constraints, Indexes and Foreign Keys
> > be disabled? If Indexes (PK's and UN Constraints) can be disabled what
> > happens if data is inserted while disable? Will the index be rebuilt
> > when enabled?
>
> You can disable foreign-key constraints. When you re-enable them, SQL
> Server verifies that the data comply to the constraint.
>
> You cannot disable primary-key or unique constraints, nor indexes.
>
> --
> Erland Sommarskog, SQL Server MVP, sommar@algonet.se
>
> Books Online for SQL Server SP3 at
> http://www.microsoft.com/sql/techinf...2000/books.asp