> hi,
> Grupo ESI wrote:
>> Hi all,
>>
>> I'd like to know how can I know (from a VB application) how many
>> user are conected to a MSDE Database ?
>>
>> Best regards,
>
> hor simple eval, you can see what sp_who reports, like
>
> SET NOCOUNT ON;
> CREATE TABLE #Process (
> spid INT ,
> ecid INT ,
> status NCHAR(30) ,
> loginame NCHAR(128) ,
> hostname NCHAR(128) ,
> blk CHAR(5) ,
> dbname NCHAR(128) ,
> cmd NCHAR(16)
> ) ;
>
> INSERT INTO #Process EXEC sp_who;
> SELECT COUNT(*) FROM #Process WHERE dbname = 'pubs';
> DROP TABLE #Process;
>
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz http://italy.mvps.org
> DbaMgr2k ver 0.19.0 - DbaMgr ver 0.63.0 and further SQL Tools
> --------- remove DMO to reply

Grupo ESI wrote:
> Hi all,
>
> I'd like to know how can I know (from a VB application) how many
> user are conected to a MSDE Database ?
>
> Best regards,