cek nama server dll sql server

SELECT
            SERVERPROPERTY('MachineName') AS [ServerName],
SERVERPROPERTY('ServerName') AS [ServerInstanceName],
            SERVERPROPERTY('InstanceName') AS [Instance],
            SERVERPROPERTY('Edition') AS [Edition],
            SERVERPROPERTY('ProductVersion') AS [ProductVersion],
Left(@@Version, Charindex('-', @@version) - 2) As VersionName


=============================================================
SELECT HOST_NAME() AS HostName

=============


https://docs.microsoft.com/en-us/sql/t-sql/functions/servername-transact-sql


============

pengen tau nama server

ex :

SELECT @@SERVERNAME AS 'Server Name'
================
service name


SELECT @@SERVICENAME AS 'Service Name';




=================================


select SYSDATETIME() as waktu

=================================

Tweet