hi

Hi
I am new in the SQL server field and i tried to solve the problem of
deadlocking.
Please help me in resolving the deadlock in step by step process.
Thank you
ABiAbi
Since you have not mentioend what is the version are you using?
http://blogs.msdn.com/bartd/archive.../09/747119.aspx
"Abi" <abi.chapagai@.gmail.com> wrote in message
news:1159853389.087757.64370@.m7g2000cwm.googlegroups.com...
> Hi
> I am new in the SQL server field and i tried to solve the problem of
> deadlocking.
> Please help me in resolving the deadlock in step by step process.
>
> Thank you
> ABi
>|||Boy that is a pretty vanilla request there. The topic of deadlock
resolution can go from database design to proper indexing to locking levels,
etc.
I think you would best learn from the hundreds of articles and websites that
already cover this topic on the Internet.
"Abi" <abi.chapagai@.gmail.com> wrote in message
news:1159853389.087757.64370@.m7g2000cwm.googlegroups.com...
> Hi
> I am new in the SQL server field and i tried to solve the problem of
> deadlocking.
> Please help me in resolving the deadlock in step by step process.
>
> Thank you
> ABi
>|||Hi,
Go thru this URL. This say the methods to troubleshoot deadlocking.
http://www.sql-server-performance.com/deadlocks.asp
Thanks
Hari
"Abi" <abi.chapagai@.gmail.com> wrote in message
news:1159853389.087757.64370@.m7g2000cwm.googlegroups.com...
> Hi
> I am new in the SQL server field and i tried to solve the problem of
> deadlocking.
> Please help me in resolving the deadlock in step by step process.
>
> Thank you
> ABi
>|||sp_who2
"Abi" <abi.chapagai@.gmail.com> wrote in message
news:1159853389.087757.64370@.m7g2000cwm.googlegroups.com...
> Hi
> I am new in the SQL server field and i tried to solve the problem of
> deadlocking.
> Please help me in resolving the deadlock in step by step process.
>
> Thank you
> ABi
>|||There are actually a couple better than sp_who and sp_who2 at:
http://www.sqlservercentral.com/Scr...20&categoryid=1
I've used the new sp_who3 and sp_what (my favorite). Check 'em out - very
nice.
"Mike C#" <xyz@.xyz.com> wrote in message
news:krFUg.778$iS5.121@.newsfe11.lga...
> sp_who2
>
> "Abi" <abi.chapagai@.gmail.com> wrote in message
> news:1159853389.087757.64370@.m7g2000cwm.googlegroups.com...
>

Helpful Blogs - Take a look before posting

I think we could solve quite a few questions much faster by posting helpful blogs here.

Some questions are asked over and over and the answer is typically: see this blog. People simply don't know it's out there.

So, if you are the author of a useful Reporting Services blog, or have found a Reporting Services blog particularly helpful, please post it here (keep it strictly to links that you feel solve a large number of RS questions).

If you would, also provide a short description as to the content of the blog.

I'll start with these:

Session Timeouts -- http://blogs.msdn.com/jgalla/archive/2006/10/11/session-timeout-during-execution.aspx

SSRS Setup -- http://prologika.com/CS/blogs/blog/archive/2007/07/12/ssrs-setup-woes.aspx

Complex SQL Issues -- http://spacefold.com/lisa/category/SQL-Server.aspx

Great idea Greg.

I refer to this one a lot even though it's not updated any more.

RS tricks (or sleazy hacks) - http://blogs.msdn.com/ChrisHays/

|||

Building and deploying basic reports - Part 1, provided a step-by-step guide to basic report creation and
Beginning SQL Server 2005 Reporting Services - Part 2, took a tour of some of the core SSRS features and functions that you'll need to develop dynamic reports
Beginning SQL Server 2005 Reporting Services - Part 3, focused entirely on the built-in SSRS chart control

Andrew Whitten's .NET Blog

Helpful Blogs

I think we could solve quite a few questions much faster by posting helpful blogs here.

Some questions are asked over and over and the answer is typically: see this blog. People simply don't know it's out there.

So, if you are the author of a useful Reporting Services blog, or have found a Reporting Services blog particularly helpful, please post it here (keep it strictly to links that you feel solve a large number of RS questions).

If you would, also provide a short description as to the content of the blog.

I'll start with these:

Session Timeouts -- http://blogs.msdn.com/jgalla/archive/2006/10/11/session-timeout-during-execution.aspx

SSRS Setup -- http://prologika.com/CS/blogs/blog/archive/2007/07/12/ssrs-setup-woes.aspx

Complex SQL Issues -- http://spacefold.com/lisa/category/SQL-Server.aspx

Great idea Greg.

I refer to this one a lot even though it's not updated any more.

RS tricks (or sleazy hacks) - http://blogs.msdn.com/ChrisHays/

|||

Building and deploying basic reports - Part 1, provided a step-by-step guide to basic report creation and
Beginning SQL Server 2005 Reporting Services - Part 2, took a tour of some of the core SSRS features and functions that you'll need to develop dynamic reports
Beginning SQL Server 2005 Reporting Services - Part 3, focused entirely on the built-in SSRS chart control

Andrew Whitten's .NET Blog

HELP: SQL SERVER CONNECTION TIMED OUT

can someone please help me solve this problem.

i'm experiencing sql server error: the database controller returned an error status of sql server connection timed out.

i need some help badly.

thanksWhat is the code doing when it times out? Frequently this is a problem with running a long script that exceeds the timeout. What is the complete text of the exception message?

Don|||>>what is the code doing when it times out?
- the code is posting accounting transactions coming from our accounting system.

>>the complete error message?
- the database controller returned an error status of sql server connection timed out

thanks|||Regarding the complete error message, I mean the full page of stuff that you get by default in ASP.NET, including the full error message, stack trace, and everything else that probably looks useless on the page.

That said, how long is the process taking? You may have to extend the SQL connection time out and perhaps the page time out.

Don