Re: MAC Address
From: Aaron [SQL Server MVP] (ten.xoc_at_dnartreb.noraa)
Date: 11/04/04
- Next message: jiangyh: "How to select one space row from anyone table"
- Previous message: Zach Wells: "Re: How to create a table with many same type fields by coding?"
- In reply to: Armando Méndez: "MAC Address"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 3 Nov 2004 22:21:39 -0500
Not sure if you can use this in a view directly, because of the
@@SERVERNAME. Why does this have to be a view?
SELECT DISTINCT net_address
FROM master.dbo.sysprocesses
WHERE hostname = @@SERVERNAME
-- http://www.aspfaq.com/ (Reverse address to reply.) "Armando Méndez" <amendez@interlinea.com.mx> wrote in message news:#zOMkbhwEHA.1976@TK2MSFTNGP09.phx.gbl... Is there a way to retrieve the current MAC Address into a View? T.I.A.
- Next message: jiangyh: "How to select one space row from anyone table"
- Previous message: Zach Wells: "Re: How to create a table with many same type fields by coding?"
- In reply to: Armando Méndez: "MAC Address"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
