You have a single instance cluster. There is no such thing as active/passive in SQL Server 2000. That is old, inaccurate terminology that no longer applies. When a node fails in a cluster, the SQL Server shuts down. It is then restarted. Therefore, you get the same effect in a cluster as you get with a single machine when it fails, so no, the script will not continue to work. All open transactions will be rolled back upon the start up of the service, and you must restart the script.
For More Information
- Dozens more answers to tough SQL Server questions from Michael Hotek are available here.
- The Best Microsoft SQL Server Web Links: tips, tutorials, scripts, and more.
- Have a SQL Server tip to offer your fellow DBAs and developers? The best tips submitted will receive a cool prize. Submit your tip today!
- Ask your technical SQL Server questions -- or help out your peers by answering them -- in our live discussion forums.
- Ask the Experts yourself: Our SQL, database design, SQL Server, DB2, object-oriented and data warehousing gurus are waiting to answer your toughest questions.
This was first published in March 2004