Re: Allowing only certain clients access to SQL Server 2K

From: Raj Bhaskar (r.bhaskar@compserv.gla.ac.ukNOPSAMFOO)
Date: 01/21/03 

Date: Tue, 21 Jan 2003 16:32:01 +0000
From: Raj Bhaskar <r.bhaskar@compserv.gla.ac.ukNOPSAMFOO>

Kresimir Radosevic wrote:
> select net_address from sysprocesses where spid = @spid
>
> -- will give you the address, maybe this can help you
> -- QUERYING SYSTEM TABLES DIRECTLY IS NOT RECOMMENDED

When I tried that, it said "Must declare variable @spid". Any ideas?

Raj.

> "Raj Bhaskar" <r.bhaskar@compserv.gla.ac.ukNOPSAMFOO> wrote in message
> news:O6vOxyTwCHA.2868@TK2MSFTNGP12...
>
>>Hi folks,
>>I want to increase security on my SQL Server database by restricting
>>access to a small group of machines (based on IP address on our
>>intranet). I can't find any way of doing this. Eg, so that I can set it
>>to only accept connections from localhost, or the IP range 192.168.5.xx.

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: How to translate net_address
    ... select spid, dbo.fn_getIPaddress(hostname) as IPaddress ... from sysprocesses ... Please reply only to the newsgroups. ...
    (microsoft.public.sqlserver.connect)