Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jayhawk
Starting Member
3 Posts |
 Posted - 2004-01-07 : 12:46:52
|
| Question, and please excuse my ignorance as I am not a developer.Currently I am working with an application that has a SP that calls the instance name (usually default), stores it and uses this information along with the database name and a key to license the product.My question is, what is the syntax or command that I could use in a SP that would call the node name or virtual server name of a SQL 2 node cluster ?The issue is , this database will be part of an active/active cluster and the database will live on one of the nodes unless a failure occurs. But the issue is , if a failure occurs, the machine name and possibly the instance name will change upon failover. I would rather point this SP license to the node name / cluster name of the SQL Cluster.Thanks in advance to everyone ! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
SP or T-SQL to call SQL Server Cluster name