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

From: Kresimir Radosevic (kresimir.radosevic@zg.tel.hr)
Date: 01/21/03 

From: "Kresimir Radosevic" <kresimir.radosevic@zg.tel.hr>
Date: Tue, 21 Jan 2003 20:51:21 +0100

Silly me, @@spid, I dropped one monkey 

-- 
Kresimir Radosevic, SQL MVP
I support the Professional Association for SQL Server and its user community
of dedicated professionals.
www.sqlpass.org
"Raj Bhaskar" <r.bhaskar@compserv.gla.ac.ukNOPSAMFOO> wrote in message 
news:OFSuVqWwCHA.2292@TK2MSFTNGP10...
> 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: Allowing only certain clients access to SQL Server 2K
    ... select net_address from sysprocesses where spid = @spid ... -- QUERYING SYSTEM TABLES DIRECTLY IS NOT RECOMMENDED ... I support the Professional Association for SQL Server and its user community ...
    (microsoft.public.sqlserver.security)
  • Re: Can you use osql in DTS?
    ... Dim pkg, task, spid ... Columnist, SQL Server Professional ... the variable I need to pass into a stored procedure and have it function ... >> osql. ...
    (microsoft.public.sqlserver.dts)
  • Re: Can you use osql in DTS?
    ... Dim pkg, task, spid ... Columnist, SQL Server Professional ... the variable I need to pass into a stored procedure and have it function ... >> osql. ...
    (microsoft.public.sqlserver.programming)
  • Re: Whats the deal with PAGEIOLATCH_SH?
    ... running on is waiting on acquiring a shared lock on a storage page. ... Have you checked sp_lock to see if the spid is blocked by another ... SQL Server MVP ... > different database, usually idle, and we are running reporting ...
    (microsoft.public.sqlserver.programming)
  • Re: Whats the deal with PAGEIOLATCH_SH?
    ... I checked the spids from Enterprise Manager and there is ... >blocking. ... Have you checked sp_lock to see if the spid is blocked by another ... >> I'm seeing some strange performance problems with my SQL server (8.0 ...
    (microsoft.public.sqlserver.programming)