Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
How can you break database connections in SQL7?
In SQL 2000 you can break all connections to a database and set your application as the only connection by using the TSQL statement "ALTER DATABASE <dbname> SET SINGLE_USER WITH ROLLBACK IMMEDIATE". In SQL 7 you can get single user access using by using the TSQL statement "EXEC...- rcgold
- Thread
- Replies: 0
- Forum: Microsoft SQL Server: Programming
-
Programatically define TCP/IP Properties
I would like to programatically modify a machines TCP/IP properties. More specifically, the static IP address, subnet mask, and default gateway. Is there a API that supports this capability under Windows 2000 and/or Windows NT? Also, is there an API that supports access to the adapter...- rcgold
- Thread
- Replies: 1
- Forum: Win API (Microsoft)
