How to display the database server mame RRS feed

  • Question

  • Hello, all.  I built a simple .net web app that displays a table's data in a grid control.  simple.  my database is sql 2005 and is in a mirroring session.  when i failover to the mirror, and application errors out (as expected), then I can refresh the page and it successfully connects to the mirror database.  What I'd like to do is display the name of the SQL Server machine name on my web page, to prove that I am indeed hitting the mirror database and not the principal.  is it possible to display the db server name in a .net app?  If so, any code would be helpful.

    Thursday, October 22, 2009 4:46 PM


All replies