sql server locking condition

Casi mejor en español...


Un saludo

-
"Sólo sé que no sé nada. " (Sócrates)

"Hüseyin" escribió en el mensaje
news:#

I have got a sql server database.Size is more than 2 Gb. And I have got a
500 clients too.When a clients want to send into a sql database , the
databese is locking.I am manually intervention to the sql.And the problem

is

solving.Is there any solution about this locking? How am I solve this lock
condition? Is there any stored procedure to the fix this lock condition?

Thank you very much for your help

Best regards

Huseyin Basbay


PS: I use windows server 2003 enterprise edition and sql server 2000

Tengo un servidor database.Size del sql soy más de 2 GB. ¿Y tengo 500
clientes que too.When los clientes desean enviar en una base de datos del
sql, el databese soy intervención de locking.I manualmente al sql.And el
problema es solving.Is allí cualquier solución sobre esta fijación? ¿Cómo
soy solucionar esta condición de la cerradura? ¿Hay procedimiento almacenado
al arreglo esta condición de la cerradura?

Gracias mucho por su ayuda Recuerdos

Huseyin Basbay

Picosegundo: Utilizo la edición 2003 de la empresa del servidor de las
ventanas y el servidor 2000 del sql

"Carlos Sacristán" <csacristanARROBAmvpsPUNTOorg>, haber iletisinde þunlarý
yazdý:

Casi mejor en español...


Un saludo

-
"Sólo sé que no sé nada. " (Sócrates)

"Hüseyin" escribió en el mensaje
news:#

I have got a sql server database.Size is more than 2 Gb. And I have got a
500 clients too.When a clients want to send into a sql database , the
databese is locking.I am manually intervention to the sql.And the problem

is

solving.Is there any solution about this locking? How am I solve this
lock
condition? Is there any stored procedure to the fix this lock condition?

Thank you very much for your help

Best regards

Huseyin Basbay


PS: I use windows server 2003 enterprise edition and sql server 2000

Hy Hüseyin, You can go to the SQLServer english newsgroup to ask in english
and also receive responses in english.
I have a very poor english but I will try to help you.

Habitually when you obtain blocks problems in a database de most usuall
cause is a defficient use of transaccion. You can use the standars sp_who
and sp_lock store procedures to try to know what is the reason for this
particular lock. Also you can use this other Store procedure and try to
understand de really reasons for this lock.
(http://www.configuracionesintegrale...articulo%6)




"Hüseyin" wrote in message
news:%

I have got a sql server database.Size is more than 2 Gb. And I have got a
500 clients too.When a clients want to send into a sql database , the
databese is locking.I am manually intervention to the sql.And the problem
is solving.Is there any solution about this locking? How am I solve this
lock condition? Is there any stored procedure to the fix this lock
condition?

Thank you very much for your help

Best regards

Huseyin Basbay


PS: I use windows server 2003 enterprise edition and sql server 2000