detect and solve deadlocks

Is there any way by which deadlocks can be detacted and then appropriate
action can be taken (in vb.net code or sql) to avoid it. instead of throwing
error we can revoke the sp call..
thankshttp://www.sql-server-performance.com/deadlocks.asp
"Vikram" <aa@.aa> wrote in message
news:%23x95g36CGHA.2700@.TK2MSFTNGP14.phx.gbl...
> Is there any way by which deadlocks can be detacted and then appropriate
> action can be taken (in vb.net code or sql) to avoid it. instead of
> throwing
> error we can revoke the sp call..
> thanks
>|||http://msdn.microsoft.com/library/d...
tabse_5xrn.asp
Troubleshooting Deadlocks
http://www.support.microsoft.com/?id=224453 Blocking Problems
http://www.support.microsoft.com/?id=271509 How to monitor SQL 2000
Blocking
Andrew J. Kelly SQL MVP
"Vikram" <aa@.aa> wrote in message
news:%23x95g36CGHA.2700@.TK2MSFTNGP14.phx.gbl...
> Is there any way by which deadlocks can be detacted and then appropriate
> action can be taken (in vb.net code or sql) to avoid it. instead of
> throwing
> error we can revoke the sp call..
> thanks
>|||You can determine what processes are currently blocking other processes by
running sp_who and looking for SPIDs in the [blkby] column.
http://msdn2.microsoft.com/ms174313.aspx
Once you have the SPID of a blocking process, you can use DBCC INPUTBUFFER
to see what command it last executed.
http://msdn.microsoft.com/library/d...
v8y.asp
Here are a couple of articles on tracing deadlocks:
http://support.microsoft.com/defaul...kb;en-us;832524
http://support.microsoft.com/defaul...kb;en-us;271509
"Vikram" <aa@.aa> wrote in message
news:%23x95g36CGHA.2700@.TK2MSFTNGP14.phx.gbl...
> Is there any way by which deadlocks can be detacted and then appropriate
> action can be taken (in vb.net code or sql) to avoid it. instead of
> throwing
> error we can revoke the sp call..
> thanks
>|||http://support.microsoft.com/defaul...kb;en-us;832524
Regards
Amish
*** Sent via Developersdex http://www.examnotes.net ***|||I think all the answers you are getting explain how to figure out what is
causing deadlocks so you can rewrite your applications to avoid them. While
this is definitely the right approach, you seem to be asking what you can do
to detect deadlocks in your code. SQL Server already detects and resolves
deadlocks for you. It does this by picking one of the transactions involved
in the deadlock and terminating it so the other transactions can continue.
The error you get at the client is saying that your transaction is the one
picked as the victim. The right thing to do when you're the deadlock victim
is to restart the transaction. If you have enough information available to
do the transaction again, you can just do it without telling the user that
something happened but if you need the user to re-enter the data to rerun
the transaction then just tell the user what happened and have them redo it.
Avoiding deadlocks through application design is important but in some cases
they are unavoidable and you should code your application to respond
appropriately.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Vikram" <aa@.aa> wrote in message
news:%23x95g36CGHA.2700@.TK2MSFTNGP14.phx.gbl...
> Is there any way by which deadlocks can be detacted and then appropriate
> action can be taken (in vb.net code or sql) to avoid it. instead of
> throwing
> error we can revoke the sp call..
> thanks
>

detail view

When opening an RS folder in IE 6 I get a Detail View and must click "Hide
Details" is there a way to make it open in summary instead of detail?
Thanks!
GlenOnce you have clicked on Hide Details you should not see details the next
time you login. Is that not happening for you?
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Glen Tosco" <glen@.delnat.com> wrote in message
news:eo1RFJXYFHA.3220@.TK2MSFTNGP14.phx.gbl...
> When opening an RS folder in IE 6 I get a Detail View and must click "Hide
> Details" is there a way to make it open in summary instead of detail?
>
> Thanks!
> Glen
>|||No, it always opens on detail.
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:%23OhhUaXYFHA.3184@.TK2MSFTNGP15.phx.gbl...
> Once you have clicked on Hide Details you should not see details the next
> time you login. Is that not happening for you?
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Glen Tosco" <glen@.delnat.com> wrote in message
> news:eo1RFJXYFHA.3220@.TK2MSFTNGP14.phx.gbl...
>> When opening an RS folder in IE 6 I get a Detail View and must click
>> "Hide Details" is there a way to make it open in summary instead of
>> detail?
>>
>> Thanks!
>> Glen
>|||Is your site setup of anonymous access?
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Glen Tosco" <glen@.delnat.com> wrote in message
news:%23CT$RngZFHA.3984@.TK2MSFTNGP10.phx.gbl...
> No, it always opens on detail.
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:%23OhhUaXYFHA.3184@.TK2MSFTNGP15.phx.gbl...
>> Once you have clicked on Hide Details you should not see details the next
>> time you login. Is that not happening for you?
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Glen Tosco" <glen@.delnat.com> wrote in message
>> news:eo1RFJXYFHA.3220@.TK2MSFTNGP14.phx.gbl...
>> When opening an RS folder in IE 6 I get a Detail View and must click
>> "Hide Details" is there a way to make it open in summary instead of
>> detail?
>>
>> Thanks!
>> Glen
>>
>|||No...
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:uxB4U2hZFHA.2128@.TK2MSFTNGP14.phx.gbl...
> Is your site setup of anonymous access?
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Glen Tosco" <glen@.delnat.com> wrote in message
> news:%23CT$RngZFHA.3984@.TK2MSFTNGP10.phx.gbl...
>> No, it always opens on detail.
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:%23OhhUaXYFHA.3184@.TK2MSFTNGP15.phx.gbl...
>> Once you have clicked on Hide Details you should not see details the
>> next time you login. Is that not happening for you?
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Glen Tosco" <glen@.delnat.com> wrote in message
>> news:eo1RFJXYFHA.3220@.TK2MSFTNGP14.phx.gbl...
>> When opening an RS folder in IE 6 I get a Detail View and must click
>> "Hide Details" is there a way to make it open in summary instead of
>> detail?
>>
>> Thanks!
>> Glen
>>
>>
>|||I don't have any suggestions. This is very odd. I have never seen anyone
post with this problem before.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Glen Tosco" <glen@.delnat.com> wrote in message
news:uxob8tkZFHA.1152@.tk2msftngp13.phx.gbl...
> No...
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:uxB4U2hZFHA.2128@.TK2MSFTNGP14.phx.gbl...
>> Is your site setup of anonymous access?
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Glen Tosco" <glen@.delnat.com> wrote in message
>> news:%23CT$RngZFHA.3984@.TK2MSFTNGP10.phx.gbl...
>> No, it always opens on detail.
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:%23OhhUaXYFHA.3184@.TK2MSFTNGP15.phx.gbl...
>> Once you have clicked on Hide Details you should not see details the
>> next time you login. Is that not happening for you?
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Glen Tosco" <glen@.delnat.com> wrote in message
>> news:eo1RFJXYFHA.3220@.TK2MSFTNGP14.phx.gbl...
>> When opening an RS folder in IE 6 I get a Detail View and must click
>> "Hide Details" is there a way to make it open in summary instead of
>> detail?
>>
>> Thanks!
>> Glen
>>
>>
>>
>|||Hi Glen,
Is it possible for you to generate a sample rdl file and send it to me? The
sample rdl file is recommanded using defalut database (such as Northwind or
Foodmart?) I understand the information may be sensitive to you, my direct
email address is v-mingqc@.online.microsoft.com (note that "online" is only
for SPAM, remove it before you click SEND), you may send the file to me
directly and I will keep secure.
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

detach-copy-attach vs Copy Database Wizard

Instead of running the Copy Database Wizard, if I
1 detached the source database
2 copied the files from the source to the destination server
3 attached the files to the destination server
does it accomplish the same thing? The source will be SQL 7 and the
destination will be SQL 2000, so a database upgrade is involved.
I want to be able to get a copy of the detached .mdf and .ldf files copied
to the destination server that I can use to test the upgrade from SQL 7 to
2000
numerous times if needed. I don't want to use the wizard repeatedly, since
it
requires that the source db be in single user mode or have no users
connected to it.
Thanks,
johnYour method works. You might want to look into BACKUP and RESTORE as =another method to "move" databases. One benefit with this method: you =can use the Transact-SQL command 'BACKUP' to backup your database =without having to take it offline (as you do with detach_db). Another =method is that you can simply come along with your favorite backup =utility and simply backup a file (instead of trying to backup an open =database).
-- Keith
"john" <jgorman@.humanitees.com> wrote in message =news:%23e3gJhZmDHA.2444@.TK2MSFTNGP09.phx.gbl...
> Instead of running the Copy Database Wizard, if I
> > 1 detached the source database
> 2 copied the files from the source to the destination server
> 3 attached the files to the destination server
> > does it accomplish the same thing? The source will be SQL 7 and the
> destination will be SQL 2000, so a database upgrade is involved.
> > I want to be able to get a copy of the detached .mdf and .ldf files =copied
> to the destination server that I can use to test the upgrade from SQL =7 to
> 2000
> numerous times if needed. I don't want to use the wizard repeatedly, =since
> it
> requires that the source db be in single user mode or have no users
> connected to it.
> > Thanks,
> john
> >|||Will a restore of a SQL 7 database to a SQL 2000 database result in an
upgrade of that database to SQL 2000?
john
Keith Kratochvil <sqlguy.back2u@.comcast.net> wrote in message
news:ufNP2uZmDHA.3700@.TK2MSFTNGP11.phx.gbl...
Your method works. You might want to look into BACKUP and RESTORE as
another method to "move" databases. One benefit with this method: you can
use the Transact-SQL command 'BACKUP' to backup your database without having
to take it offline (as you do with detach_db). Another method is that you
can simply come along with your favorite backup utility and simply backup a
file (instead of trying to backup an open database).
--
Keith
"john" <jgorman@.humanitees.com> wrote in message
news:%23e3gJhZmDHA.2444@.TK2MSFTNGP09.phx.gbl...
> Instead of running the Copy Database Wizard, if I
> 1 detached the source database
> 2 copied the files from the source to the destination server
> 3 attached the files to the destination server
> does it accomplish the same thing? The source will be SQL 7 and the
> destination will be SQL 2000, so a database upgrade is involved.
> I want to be able to get a copy of the detached .mdf and .ldf files copied
> to the destination server that I can use to test the upgrade from SQL 7 to
> 2000
> numerous times if needed. I don't want to use the wizard repeatedly,
since
> it
> requires that the source db be in single user mode or have no users
> connected to it.
> Thanks,
> john
>|||Yes.
--
Hope this helps.
Dan Guzman
SQL Server MVP
--
SQL FAQ links (courtesy Neil Pike):
http://www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
http://www.sqlserverfaq.com
http://www.mssqlserver.com/faq
--
"john" <jgorman@.humanitees.com> wrote in message
news:%23tOae2ZmDHA.1740@.TK2MSFTNGP12.phx.gbl...
> Will a restore of a SQL 7 database to a SQL 2000 database result in an
> upgrade of that database to SQL 2000?
> john
>
> Keith Kratochvil <sqlguy.back2u@.comcast.net> wrote in message
> news:ufNP2uZmDHA.3700@.TK2MSFTNGP11.phx.gbl...
> Your method works. You might want to look into BACKUP and RESTORE as
> another method to "move" databases. One benefit with this method: you
can
> use the Transact-SQL command 'BACKUP' to backup your database without
having
> to take it offline (as you do with detach_db). Another method is that
you
> can simply come along with your favorite backup utility and simply
backup a
> file (instead of trying to backup an open database).
> --
> Keith
>
> "john" <jgorman@.humanitees.com> wrote in message
> news:%23e3gJhZmDHA.2444@.TK2MSFTNGP09.phx.gbl...
> > Instead of running the Copy Database Wizard, if I
> >
> > 1 detached the source database
> > 2 copied the files from the source to the destination server
> > 3 attached the files to the destination server
> >
> > does it accomplish the same thing? The source will be SQL 7 and the
> > destination will be SQL 2000, so a database upgrade is involved.
> >
> > I want to be able to get a copy of the detached .mdf and .ldf files
copied
> > to the destination server that I can use to test the upgrade from
SQL 7 to
> > 2000
> > numerous times if needed. I don't want to use the wizard
repeatedly,
> since
> > it
> > requires that the source db be in single user mode or have no users
> > connected to it.
> >
> > Thanks,
> > john
> >
> >
>