Board index » delphi » Exclusive connection to MS SQL Server 7.0

Vova Ilchenk

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Exclusive connection to MS SQL Server 7.0

Hi, All

Dows anybody know how can I establish exclusive connection to MS SQL Server 7.0 with Delphi 5 in order to restore a database.

Thanks in advance

Best regards,
Vova Ilchenko

 
Mio Nino Marque

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:Exclusive connection to MS SQL Server 7.0


Vova,

You can set the database as "for dbo use only" by using sp_dboption.
If there are existing connections to the database, either you kill them or
ask them to disconnect. :)

HTH,

Mio Nino Marquez

Other Threads

1. Connection between SQL Server 7.0 on win98 and SQL Server 7.0 on Win2000 advanced server

2. Linked Servers in MS SQL Server 7.0

3. SQL-Links (MS-SQL Server 7.0) bug?

4. Can SQL Explorer access MS SQL Server 7.0?

5. General SQL Error - MS SQL Server 7.0 Win2K

6. Interbase SQL SuperServer or MS SQL Server 7.0?

7. Connection with MS SQL 7.0 broken

8. MS SQL 7.0 and Delphi 4 connection problem

9. SQL Server 7.0 connection

10. Connection with SQL Server 7.0