Is there a way to establish an exclusive SQL 2000 connection, i.e. only
allow 1 user to connect?
In Access I am able using a file DSN with Exclusive=1. Is there a similar
property to use in the connect string or ADO connection object (I do not see
anything glaring there)?
Thanks - Tom> Is there a way to establish an exclusive SQL 2000 connection, i.e. only
> allow 1 user to connect?
> In Access I am able using a file DSN with Exclusive=1. Is there a similar
> property to use in the connect string or ADO connection object (I do not
> see anything glaring there)?
> Thanks - Tom
Use the
ALTER DATABASE db_name SET SINGLE_USER
T-SQL command.
Dejan Sarka
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment