Hi Robert,

* please, don't run this example on production server :-)
lihdbc=sqlstringconnect("driver={sql server}; server=xxxx; database=xxx ;uid=xxx ;pwd=xxx")
=sqlexec(lihdbc,"execute sp_who") && get list of connection

SCAN ALL
     luSPID=SPID && get ID
     =sqlexec(lihdbc,"kill ?luSPID") && kill him
ENDSCAN
=sqldisconnect(lihdbc)

MartinJ

>there is a way to get how many connection i have on my sql server ?
>
>
>
>also can i get this information via foxpro ?
>
>
>
>also can i disconnect used via foxpro ???