-- a clever VMWare check by Peter Larsson (http://weblogs.sqlteam.com/peterl)

DECLARE @Result TABLE
        (
            LogDate DATETIME,
            ProcessInfo NVARCHAR(MAX),
            Text NVARCHAR(MAX)
        )
 
INSERT  @Result
EXEC    sys.xp_readerrorlog 0, 1, 'System Manufacturer', 'VMware'
 
IF EXISTS (SELECT * FROM @Result)
    SELECT 'It seems you are running on VMware.' AS Msg
ELSE
    SELECT 'It seems you are not running on VMware.' AS Msg