Re: How to translate net_address

From: Gert E.R. Drapers (GertD_at_Online.SQLDev.Net)
Date: 04/06/04

  • Next message: Sunny: "Re: How do I find I am administrator?" 
    Date: Tue, 6 Apr 2004 20:39:43 +0200

    You can correlate the IP address back from hostname

    select spid, dbo.fn_getIPaddress(hostname) as IPaddress
    from sysprocesses
    where spid > 50

    GertD@SQLDev.Net

    Please reply only to the newsgroups.
    This posting is provided "AS IS" with no warranties, and confers no rights.
    You assume all risk for your use.
    Copyright © SQLDev.Net 1991-2004 All rights reserved.

    "David Velasco" <anonymous@discussions.microsoft.com> wrote in message
    news:f02701c40c61$7cb7ae30$a301280a@phx.gbl...
    > Does anyone know who to translate the column net_address
    > from master..sysprocess into it's corresponding ip address?
    >
    > Thanks,
    >
    > David.

  • Next message: Sunny: "Re: How do I find I am administrator?"

    Relevant Pages

    • Re: SELECT 42 AS a, a AS b FROM system.iota
      ... Luc, system.iota in ADS has only one row and one column, which is also ... What you want doesn't work in ASE (spid is a columnname of sysprocesses): ...
      (comp.databases.sybase)
    • Re: SELECT 42 AS a, a AS b FROM system.iota
      ... What you want doesn't work in ASE (spid is a columnname of sysprocesses): ... Hello Luc, the ambiguity didn't occur to me, probably because in ADS ... select suid as spid, ...
      (comp.databases.sybase)
    • Re: Help with blocking
      ... I don't think parallel queries cause multiple rows in sysprocesses. ... see multiple entries in sysprocesses related to same SPID when lightweight ... > same SPID with different values in the ecid column for each process. ...
      (microsoft.public.sqlserver.server)
    • sysprocesses table in Master db
      ... There is a column named "nt_username" in sysprocesses ... tells me the exact nt login name, ... what "spid" tells. ... Jeanny ...
      (microsoft.public.sqlserver.programming)
    • Re: Allowing only certain clients access to SQL Server 2K
      ... > select net_address from sysprocesses where spid = @spid ... >>I want to increase security on my SQL Server database by restricting ...
      (microsoft.public.sqlserver.security)
    • Quantcast