Changing metadata when users are connected

Hi.
Are there limits in SQL Server on how you can change the metadata when users
are connected? I know that with some other platforms it is not possible to
create/drop foreign keys without exclusive access (for instance our current
platform Interbase 6.0.2, which we are finding very frustrating). Does SQL
Server 2000 suffer from similar limitations? Or does the number of
connected users make no difference? This is a pivotal issue for us on
deciding our upgrade strategy.
MikeSQL Server 2000 does not have any such limitations. There are some commands
that can hamper performance when run during high-user activity. Other than
that, adding constraints, indexes etc will not pose a problem. You will
of-course need to have relevant permissions to run the commands themselves.
--
HTH,
SriSamp
Please reply to the whole group only!
http://www32.brinkster.com/srisamp
"Mike" <noone@.hotmail.com> wrote in message
news:eSFHst%23rDHA.2148@.TK2MSFTNGP12.phx.gbl...
> Hi.
> Are there limits in SQL Server on how you can change the metadata when
users
> are connected? I know that with some other platforms it is not possible
to
> create/drop foreign keys without exclusive access (for instance our
current
> platform Interbase 6.0.2, which we are finding very frustrating). Does
SQL
> Server 2000 suffer from similar limitations? Or does the number of
> connected users make no difference? This is a pivotal issue for us on
> deciding our upgrade strategy.
> Mike
>