Applications are often blocked

Hi all ,
I renew my request and hope you could give me a hand.
We use Small Business Server and we have 14 small
officies, and in each officy we have 1 server and 3 PC
client.
*We have SQL server 2000 Small Business with SP3, running
on the server which is the domain controler too and there
are no Trust Realation between them.
*On each server and each client we have an Access's
application which extract and treat data from SQL server.
We use the mobil profil and with our policy of security
user can log and use the server like the Workstation.
In each server, We use Memory Virtual 1024 Mo and we
dedicate all of them for APLLICATIONS.
Some time our application is is blocked but
it happened only with user who exploiting the application
in the server and there are no Errors Messages.
Do you have some idea, please.
Can
.SQL has some traceflags you can turn on to aid in finding the cause of
blocking.
DBCC TRACEON (1204,3605,-1)
Also have a look at http://vyaskn.tripod.com/administration_faq.htm#q14
--
HTH
Ryan Waight, MCDBA, MCSE
"can" <canpama@.netscape.net> wrote in message
news:ac4701c3811c$27c587b0$a601280a@.phx.gbl...
> Hi all ,
>
> I renew my request and hope you could give me a hand.
> We use Small Business Server and we have 14 small
> officies, and in each officy we have 1 server and 3 PC
> client.
> *We have SQL server 2000 Small Business with SP3, running
> on the server which is the domain controler too and there
> are no Trust Realation between them.
> *On each server and each client we have an Access's
> application which extract and treat data from SQL server.
> We use the mobil profil and with our policy of security
> user can log and use the server like the Workstation.
> In each server, We use Memory Virtual 1024 Mo and we
> dedicate all of them for APLLICATIONS.
> Some time our application is is blocked but
> it happened only with user who exploiting the application
> in the server and there are no Errors Messages.
> Do you have some idea, please.
> Can
> .
>