Information générale
Forum:
Microsoft SQL Server
Catégorie:
Stored procedures, Triggers, UDFs
Titre:
SQL Server - Full Name
Versions des environnements
SQL Server:
SQL Server 2005
Hi, I need to run a stored procedure on 3 different servers.
For this, I need to know which server a stored procedure runs.
I used
EXEC master..xp_getnetname @cServerName OUTPUT
this works for our development and live server.
However, our development and testing server are in the same machine.
The configuration is something like this.
Develop: zeta
Test: zeta\testing.
When I issued EXEC master..xp_getnetname @cServerName OUTPUT on both develop and test, the result is 'zeta'.
Is there a stored procedure which returns the full name like 'zeta\testing'?
Again xp_getnetname returns only upto the machine name.
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement