server ip 썸네일형 리스트형 [SqlServer] 데이터베이스 서버 IP 주소 알아내기 You can get the[hostname]\[instancename] by:SELECT @@SERVERNAME;To get only the hostname when you have hostname\instance name format:SELECT LEFT(ltrim(rtrim(@@ServerName)), Charindex('\', ltrim(rtrim(@@ServerName))) -1)Alternatively as @GilM pointed out:SELECT SERVERPROPERTY('MachineName')You can get the actual IP address using this:create Procedure sp_get_ip_address (@ip varchar(40) out) as beg.. 이전 1 다음