How would one retrieve the server name that the stored procedure is running within?
I have two servers, one for production "NTProd" and one for Testing "NTTEST", and I would like the stored procedure to be able to ID which server it is running on, to be able to do some process differently.