Re: Counting Connections
From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 11/02/04
- Next message: Sue Hoegemeier: "Re: Database Security"
- Previous message: Narayana Vyas Kondreddi: "Re: BackUp - Device Activation Error"
- In reply to: Rick Lederman: "Re: Counting Connections"
- Next in thread: Steve Thompson: "Re: Counting Connections"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Tue, 02 Nov 2004 13:51:27 -0700
Try using a Pass-through query in Access to get the info.
-Sue
On Mon, 1 Nov 2004 15:13:53 -0500, "Rick Lederman"
<rick@soaringsoftware.com> wrote:
>Goeff,
>
>Thanks, that works great, now to see if I can find how to do it in Access.
>
>Rick
>"Geoff N. Hiten" <SRDBA@Careerbuilder.com> wrote in message
>news:%23MUhVvEwEHA.1984@TK2MSFTNGP14.phx.gbl...
>> select count(*) from master.dbo.sysprocesses
>> where SPID > 50
>>
>> The 'where SPID > 50' restriction eliminates system connections. I have
>no
>> clue how to do this in Access.
>>
>> --
>> Geoff N. Hiten
>> Microsoft SQL Server MVP
>> Senior Database Administrator
>> Careerbuilder.com
>>
>> I support the Professional Association for SQL Server
>> www.sqlpass.org
>>
>> "Rick Lederman" <rick@soaringsoftware.com> wrote in message
>> news:e3wkopEwEHA.3808@TK2MSFTNGP15.phx.gbl...
>> > I have a VB6 program that uses ADO to communicate with a SQL Server
>> database
>> > (and an Access database optionally). Is there a way that I can tell how
>> > many connections that there are at any one time? I'd like to do this to
>> > Access as well if possible?
>> >
>> > Rick Lederman
>> >
>> >
>>
>>
>
- Next message: Sue Hoegemeier: "Re: Database Security"
- Previous message: Narayana Vyas Kondreddi: "Re: BackUp - Device Activation Error"
- In reply to: Rick Lederman: "Re: Counting Connections"
- Next in thread: Steve Thompson: "Re: Counting Connections"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
