Deadlock Condition

We are working on VB 6.0 as front-end tool and sqlserver 7.0 as back-end.
Currently we have started experiencing deadlock condition mostly when we are firing the update statements.
We haev tried closing all recordsets after using them and setting them to 'Nothing', but hasn't helped.
The number of users has nothing to do with this problem experienced.
As sometimes even with around 65-70 users we don't have this and sometimes even 1-2 people working on the network experience this.Hi Geeta,
It doesnt matter whether 50 users use the system simultaneously or no ... A deadlock can even occur when there are 2 users in the system. It depends on what tables of the database are being used and for what purpose.It is very likely that there are long running queries which are holding locks on the table while another user is either trying to query or update the same table.
There can be many reasons as to why a query/update suddenly starts running slowly all of a sudden... the simples reasons can be that the table size has grown a lot larger than what it used to be or there can be external factors like CPU being used by another process which keeps the SQL server process to starve...
You will have to be very specific as to when u observe the deadlocks ...esp because u are saying that they dont occur all the time.
It will be really nice if you can provide more information
Cheers
Sachin|||Oohhh, your problem is such general, that only general statements can be made.

Are you using DAO of ADO of ADO.NET, or are using Java or Borland technology?

First of all, I'm not sure whether you have a deadlock situation at all. In a deadlock situation, two transactions started, and one will be forced to roll-back. I guess, you have simply a locking problem, which occurs when you are updating a record, and a second process wants to read it.

Second thought: such a locking problem can een happen within 1 program, running by one user! I had that problem with two concurrent threads. So, the number of concurrent users isn't really an issue, if you have designed your application properly.

I don't have my old sources right here, but i remember that I had to set a kind of WaitForTransaction timeout, which was by default 0.|||Hi,

I am using ADO technology.
Please tell me more about what needs to be added into
the code so that I can get rid of this problem.

Thanks.

Geeta|||BOL:

Minimizing Deadlocks

Although deadlocks cannot be avoided completely, the number of deadlocks can be minimized. Minimizing deadlocks can increase transaction throughput and reduce system overhead because fewer transactions are:

Rolled back, undoing all the work performed by the transaction.
Resubmitted by applications because they were rolled back when deadlocked.

To help minimize deadlocks:

Access objects in the same order.
Avoid user interaction in transactions.
Keep transactions short and in one batch.
Use a low isolation level.
Use bound connections.

DDL from XSD?

Apologize if this is a frequent question. Is there some tool that can read
an XSD and create a set of table definitions into which the corresponding
XML doc could be shredded?
Conceptually, like this:
XSD defines a parent-child relationship (cust-order); output from tool would
be 2 tables with a FK definition
Thanks, SteveHi Steve,
XMLSpy? 2007 Professional Edition can handle this request for you. Please
feel free to download and evaluate any of our products.
More details on this feature can be found here,
http://www.altova.com/features_database.html
Best regards,
... Jerry Sheehan
... Pre-Sales Engineer
... Altova, Inc.
"Steve Mc" wrote:

> Apologize if this is a frequent question. Is there some tool that can rea
d
> an XSD and create a set of table definitions into which the corresponding
> XML doc could be shredded?
> Conceptually, like this:
> XSD defines a parent-child relationship (cust-order); output from tool wou
ld
> be 2 tables with a FK definition
> Thanks, Steve
>
>|||Look at the schema gen option on the SQLXML Bulkload object.
Best regards
Michael
"Steve Mc" <stevemc@.zillow.com> wrote in message
news:unEHSgQRHHA.4060@.TK2MSFTNGP03.phx.gbl...
> Apologize if this is a frequent question. Is there some tool that can
> read an XSD and create a set of table definitions into which the
> corresponding XML doc could be shredded?
> Conceptually, like this:
> XSD defines a parent-child relationship (cust-order); output from tool
> would be 2 tables with a FK definition
> Thanks, Steve
>|||On Jan 31, 2:18 am, "Steve Mc" <stev...@.zillow.com> wrote:
> Apologize if this is a frequent question. Is there some tool that can rea
d
> an XSD and create a set of table definitions into which the corresponding
> XML doc could be shredded?
> Conceptually, like this:
> XSD defines a parent-child relationship (cust-order); output from tool wou
ld
> be 2 tables with a FK definition
> Thanks, Steve
XML Differencing: http://www.stylusstudio.com/xml_differencing.html
XML Differencing Tutorial: http://www.stylusstudio.com/videos/xmldiff1/
xmldiff1.html
Sincerely,
The Stylus Studio Team
http://www.stylusstudio.com|||Whoops sorry ignore that last post. Wrong thread. Sorry!!!

DDL from XSD?

Apologize if this is a frequent question. Is there some tool that can read
an XSD and create a set of table definitions into which the corresponding
XML doc could be shredded?
Conceptually, like this:
XSD defines a parent-child relationship (cust-order); output from tool would
be 2 tables with a FK definition
Thanks, Steve
Hi Steve,
XMLSpy? 2007 Professional Edition can handle this request for you. Please
feel free to download and evaluate any of our products.
More details on this feature can be found here,
http://www.altova.com/features_database.html
Best regards,
... Jerry Sheehan
... Pre-Sales Engineer
... Altova, Inc.
"Steve Mc" wrote:

> Apologize if this is a frequent question. Is there some tool that can read
> an XSD and create a set of table definitions into which the corresponding
> XML doc could be shredded?
> Conceptually, like this:
> XSD defines a parent-child relationship (cust-order); output from tool would
> be 2 tables with a FK definition
> Thanks, Steve
>
>
|||Look at the schema gen option on the SQLXML Bulkload object.
Best regards
Michael
"Steve Mc" <stevemc@.zillow.com> wrote in message
news:unEHSgQRHHA.4060@.TK2MSFTNGP03.phx.gbl...
> Apologize if this is a frequent question. Is there some tool that can
> read an XSD and create a set of table definitions into which the
> corresponding XML doc could be shredded?
> Conceptually, like this:
> XSD defines a parent-child relationship (cust-order); output from tool
> would be 2 tables with a FK definition
> Thanks, Steve
>
|||On Jan 31, 2:18 am, "Steve Mc" <stev...@.zillow.com> wrote:
> Apologize if this is a frequent question. Is there some tool that can read
> an XSD and create a set of table definitions into which the corresponding
> XML doc could be shredded?
> Conceptually, like this:
> XSD defines a parent-child relationship (cust-order); output from tool would
> be 2 tables with a FK definition
> Thanks, Steve
XML Differencing: http://www.stylusstudio.com/xml_differencing.html
XML Differencing Tutorial: http://www.stylusstudio.com/videos/xmldiff1/
xmldiff1.html
Sincerely,
The Stylus Studio Team
http://www.stylusstudio.com
|||Whoops sorry ignore that last post. Wrong thread. Sorry!!!

DBMS for Server 2005?

Anyone know if there if there is a tool visual tool for MS SQL server 2005?
Something to manage data and tables within the database without having to
type a of bunch of commands?
Thanks
In article <46b2658b$0$4895$4c368faf@.roadrunner.com>,
allGeek@.hownerdy.com says...
> Anyone know if there if there is a tool visual tool for MS SQL server 2005?
> Something to manage data and tables within the database without having to
> type a of bunch of commands?
> Thanks
>
>
SSMS or an express version for Sql2005 -- check out BOL. Consolidates
QA and EM and ServerMgr into one tool that essentially operates as
VS2005 does.
Graham (Pete) Berry
PeteBerry@.Caltech.edu
|||"Pete Berry" <PeteBerry@.Caltech.edu> wrote in message
news:MPG.211c07e233d5732d9896a2@.msnews.microsoft.c om...
> In article <46b2658b$0$4895$4c368faf@.roadrunner.com>,
> allGeek@.hownerdy.com says...
> SSMS or an express version for Sql2005 -- check out BOL. Consolidates
> QA and EM and ServerMgr into one tool that essentially operates as
> VS2005 does.
Thanks for that reply.
I looked and see it was not installed on my server.
Looking for Disk 2 and having trouble findng it.
Is it on Disk 2?
Thanks

> --
> Graham (Pete) Berry
> PeteBerry@.Caltech.edu
|||> Looking for Disk 2 and having trouble findng it.
> Is it on Disk 2?
Run setup again and make sure you select items in Workstation Components...
Aaron Bertrand
SQL Server MVP
|||"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:ubn2Jxc1HHA.1184@.TK2MSFTNGP04.phx.gbl...
> Run setup again and make sure you select items in Workstation
> Components...
I am in the reinstall phase right now and I am getting this message:
================================================
The following components that you selected will not be changed:
Client Components
Warning: Setup found that the following components that already exist are at
a different service pack level than the components being installed.
Components: Microsoft SQL Server 2005 Tools Express Edition
After completing setup, you must download and apply the latest SQL Server
2005 service pack to all the components.
================================================
Looking in the directories and the start menu..I do not see where these
things are installed.
GB

> --
> Aaron Bertrand
> SQL Server MVP
>
|||"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:ubn2Jxc1HHA.1184@.TK2MSFTNGP04.phx.gbl...
> Run setup again and make sure you select items in Workstation
> Components...
> --
> Aaron Bertrand
> SQL Server MVP
>
After reading some more, I see tht Express edition is on it.
It had gotten installed when I did a "complete" install of VS 2005.
However shortly after realizing I did that, I removed it.
Seems the tools are still on there.
I ran the configuration to try to remove the Express Edition tools, but I
see nothing of SQL Express to remove.
|||"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:ubn2Jxc1HHA.1184@.TK2MSFTNGP04.phx.gbl...
> Run setup again and make sure you select items in Workstation
> Components...
>
After reading some more, I see tht Express edition is on it.
It had gotten installed when I did a "complete" install of VS 2005.
However shortly after realizing I did that, I removed it.
Seems the tools are still on there.
I ran the configuration to try to remove the Express Edition tools, but I
see nothing of SQL Express to remove.
|||On Aug 2, 4:15 pm, "GeekBoy" <allG...@.hownerdy.com> wrote:
> Anyone know if there if there is a tool visual tool for MS SQL server 2005?
> Something to manage data and tables within the database without having to
> type a of bunch of commands?
> Thanks
SQL Server 2005 Express didn't come with any visual tools. You need
to
download SQL Server Management Studio Express from
http://msdn.microsoft.com/vstudio/express/sql/download/
|||"zbenhalim" <zbenhalim@.yahoo.com> wrote in message
news:1186187280.448848.258420@.g4g2000hsf.googlegro ups.com...
> On Aug 2, 4:15 pm, "GeekBoy" <allG...@.hownerdy.com> wrote:
> SQL Server 2005 Express didn't come with any visual tools. You need
> to
> download SQL Server Management Studio Express from
> http://msdn.microsoft.com/vstudio/express/sql/download/
See my other message.
I don't need to get SQL Server Management Studio Express.
Thanks

>

DBMGR2K Download site

Hello!
I've heard about a free tool for msde "dbmgr2k" can someone please help to point me to where can i download the software?
Thanks in advance!

Try this link I am assuming this what you mean. Hope this helps.
http://www.microsoft.com/downloads/details.aspx?FamilyId=C039A798-C57A-419E-ACBC-2A332CB7F959&displaylang=en|||Thanks Caddre for the information!
I've seen the tool that im looking for after searching it in google.
It was my mistake that I ommit letter "a". Im searching "dbmgr2k" instead of "dbamgr2k".
thanks again

Dbmail sending mails but recognised as spam by outlook07 and spamassasin.

Just started playing with the server 05 demo I am trying out the dbmail tool/ sp.

Problem is that mails are being recognised as spam!

Emails are being sent as text. Both Outlook 07 and spamassasin recognise the mail as spam :S....

I sent same info via outlok and all is ok. Difference is the header. Has anybody come across this? Know of a solution?

Thanks

I feel more to check on the Outlook side or from SPAMASSASIN tool.|||I'd say it was more likely to do with the header information that dbmail inputs.. A lot of data is missed out.. Bit of a coinsidence that its detected as spam twice..|||Have you added the dbmail account as Approved Sender in outlook?|||

Hi,

Please explain.

I was under the impression that dmail (unlike sqlmail) used smtp directly.

THanks

|||

DBMail does not require Outlook or any of the client pieces that SQL Mail required.

What SMTP server are you using? Where are you sending the mail?

Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/

Dbmail sending mails but recognised as spam by outlook07 and spamassasin.

Just started playing with the server 05 demo I am trying out the dbmail tool/ sp.

Problem is that mails are being recognised as spam!

Emails are being sent as text. Both Outlook 07 and spamassasin recognise the mail as spam :S....

I sent same info via outlok and all is ok. Difference is the header. Has anybody come across this? Know of a solution?

Thanks

I feel more to check on the Outlook side or from SPAMASSASIN tool.|||I'd say it was more likely to do with the header information that dbmail inputs.. A lot of data is missed out.. Bit of a coinsidence that its detected as spam twice..|||Have you added the dbmail account as Approved Sender in outlook?|||

Hi,

Please explain.

I was under the impression that dmail (unlike sqlmail) used smtp directly.

THanks

|||

DBMail does not require Outlook or any of the client pieces that SQL Mail required.

What SMTP server are you using? Where are you sending the mail?

Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/

Dbmail sending mails but recognised as spam by outlook07 and spamassasin.

Just started playing with the server 05 demo I am trying out the dbmail tool/ sp.

Problem is that mails are being recognised as spam!

Emails are being sent as text. Both Outlook 07 and spamassasin recognise the mail as spam :S....

I sent same info via outlok and all is ok. Difference is the header. Has anybody come across this? Know of a solution?

Thanks

I feel more to check on the Outlook side or from SPAMASSASIN tool.|||I'd say it was more likely to do with the header information that dbmail inputs.. A lot of data is missed out.. Bit of a coinsidence that its detected as spam twice..|||Have you added the dbmail account as Approved Sender in outlook?|||

Hi,

Please explain.

I was under the impression that dmail (unlike sqlmail) used smtp directly.

THanks

|||

DBMail does not require Outlook or any of the client pieces that SQL Mail required.

What SMTP server are you using? Where are you sending the mail?

Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/