Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- using System;
- using System.Data.SqlClient;
- namespace FailoverMonitorConcept
- {
- class Program
- {
- static void Main(string[] args)
- {
- string server = args[0];
- string failover = args[1];
- string database = args[2];
- string connStr = string.Format("Integrated Security=SSPI;Persist Security Info=True;Data Source={0};Failover Partner={1};Packet Size=4096;Initial Catalog={2}", server, failover, database);
- string sql = "EXEC sp_helpserver";
- SqlConnection dc = new SqlConnection(connStr);
- SqlCommand cmd = new SqlCommand(sql, dc);
- Console.WriteLine("Connection string: " + connStr);
- Console.WriteLine("Press any key to test, press q to quit");
- string priorServerName = "";
- char key = ' ';
- while(key.ToString().ToLower() != "q")
- {
- dc.Open();
- try
- {
- string serverName = cmd.ExecuteScalar() as string;
- Console.WriteLine(DateTime.Now.ToLongTimeString() + " - Server name: " + serverName);
- if (priorServerName == "")
- {
- priorServerName = serverName;
- }
- else if (priorServerName != serverName)
- {
- Console.WriteLine("***** SERVER CHANGED *****");
- Console.WriteLine("New server: " + serverName);
- priorServerName = serverName;
- }
- }
- catch (System.Data.SqlClient.SqlException ex)
- {
- Console.WriteLine("Error: " + ex.ToString());
- }
- finally
- {
- dc.Close();
- }
- key = Console.ReadKey(true).KeyChar;
- }
- Console.WriteLine("Finis!");
- }
- }
- }
Add Comment
Please, Sign In to add comment