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...
>

Help-Recovering SQL 2000 Database.

Hi Vyas,
Sorry for the late reply,
The error log just says the below and halts at the last step.
2004-09-13 17:09:54.39 spid11 Starting up database 'jennifertest'.
2004-09-13 17:10:02.75 spid3 Recovery complete.
2004-09-13 17:10:02.75 spid3 SQL global counter collection task is
created.
Do you want any other file like SQLDump?
TIA
--
Santosh
Can you check the SQL Server error log and post the error messages here? You
will find the log in MSSQL\Log folder under the installation path.
--
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"Santosh" <santoshNoSpam@.NoSpam.net> wrote in message
news:eHXmsUcmEHA.3352@.TK2MSFTNGP10.phx.gbl...
> Friends,
>
> The SQL server 2000 was running fine until all of a Sudden I got this
> message,
>
> SQL Server is aborting. Fatal exception c0000005 caught.
>
> The Service would not start, and I need help in Recovering it.
>
> Any help is greatly Appreciated.
>
> --
>
> Santosh
>
>The messages you posted indicate that the SQL Server is probably running
fine. Is that the case, or are you still not able to start your SQL Server?
What happens when you try to start your MSSQLServer service from the
services applet?
--
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"Santosh" <santoshNoSpam@.NoSpam.net> wrote in message
news:%23cqNlEnmEHA.1656@.TK2MSFTNGP09.phx.gbl...
> Hi Vyas,
> Sorry for the late reply,
> The error log just says the below and halts at the last step.
> 2004-09-13 17:09:54.39 spid11 Starting up database 'jennifertest'.
> 2004-09-13 17:10:02.75 spid3 Recovery complete.
> 2004-09-13 17:10:02.75 spid3 SQL global counter collection task is
> created.
> Do you want any other file like SQLDump?
> TIA
> --
> Santosh
> Can you check the SQL Server error log and post the error messages here?
You
> will find the log in MSSQL\Log folder under the installation path.
> --
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
>
> "Santosh" <santoshNoSpam@.NoSpam.net> wrote in message
> news:eHXmsUcmEHA.3352@.TK2MSFTNGP10.phx.gbl...
> > Friends,
> >
> > The SQL server 2000 was running fine until all of a Sudden I got this
> > message,
> >
> > SQL Server is aborting. Fatal exception c0000005 caught.
> >
> > The Service would not start, and I need help in Recovering it.
> >
> > Any help is greatly Appreciated.
> >
> > --
> >
> > Santosh
> >
> >
>
>|||When I try from the Services I get an error saying the Services Could not be
started, and the SQL server does not start at all.
Also I am not able to connect to the Database via Enterprise Manager.
Currently I have shut down the server, but I remember getting a message
something like "c000005 Dump".
--
Santosh
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:OwbAc3nmEHA.1136@.TK2MSFTNGP10.phx.gbl...
> The messages you posted indicate that the SQL Server is probably running
> fine. Is that the case, or are you still not able to start your SQL
> Server?
> What happens when you try to start your MSSQLServer service from the
> services applet?
> --
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
>
> "Santosh" <santoshNoSpam@.NoSpam.net> wrote in message
> news:%23cqNlEnmEHA.1656@.TK2MSFTNGP09.phx.gbl...
>> Hi Vyas,
>> Sorry for the late reply,
>> The error log just says the below and halts at the last step.
>> 2004-09-13 17:09:54.39 spid11 Starting up database 'jennifertest'.
>> 2004-09-13 17:10:02.75 spid3 Recovery complete.
>> 2004-09-13 17:10:02.75 spid3 SQL global counter collection task is
>> created.
>> Do you want any other file like SQLDump?
>> TIA
>> --
>> Santosh
>> Can you check the SQL Server error log and post the error messages here?
> You
>> will find the log in MSSQL\Log folder under the installation path.
>> --
>> Vyas, MVP (SQL Server)
>> http://vyaskn.tripod.com/
>>
>> "Santosh" <santoshNoSpam@.NoSpam.net> wrote in message
>> news:eHXmsUcmEHA.3352@.TK2MSFTNGP10.phx.gbl...
>> > Friends,
>> >
>> > The SQL server 2000 was running fine until all of a Sudden I got this
>> > message,
>> >
>> > SQL Server is aborting. Fatal exception c0000005 caught.
>> >
>> > The Service would not start, and I need help in Recovering it.
>> >
>> > Any help is greatly Appreciated.
>> >
>> > --
>> >
>> > Santosh
>> >
>> >
>>
>>
>|||>> something like "c000005 Dump".
That indicates an Access Violation, and all AVs are bugs. So I suggest you
open a case with Microsoft. They will refund your money, if it turns out to
be a bug.
--
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"Santosh" <santoshNoSpam@.NoSpam.net> wrote in message
news:u20RwAomEHA.3756@.TK2MSFTNGP09.phx.gbl...
> When I try from the Services I get an error saying the Services Could not
be
> started, and the SQL server does not start at all.
> Also I am not able to connect to the Database via Enterprise Manager.
> Currently I have shut down the server, but I remember getting a message
> something like "c000005 Dump".
> --
> Santosh
> "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
> news:OwbAc3nmEHA.1136@.TK2MSFTNGP10.phx.gbl...
> > The messages you posted indicate that the SQL Server is probably running
> > fine. Is that the case, or are you still not able to start your SQL
> > Server?
> > What happens when you try to start your MSSQLServer service from the
> > services applet?
> > --
> > Vyas, MVP (SQL Server)
> > http://vyaskn.tripod.com/
> >
> >
> > "Santosh" <santoshNoSpam@.NoSpam.net> wrote in message
> > news:%23cqNlEnmEHA.1656@.TK2MSFTNGP09.phx.gbl...
> >> Hi Vyas,
> >>
> >> Sorry for the late reply,
> >> The error log just says the below and halts at the last step.
> >>
> >> 2004-09-13 17:09:54.39 spid11 Starting up database 'jennifertest'.
> >> 2004-09-13 17:10:02.75 spid3 Recovery complete.
> >> 2004-09-13 17:10:02.75 spid3 SQL global counter collection task is
> >> created.
> >>
> >> Do you want any other file like SQLDump?
> >>
> >> TIA
> >>
> >> --
> >>
> >> Santosh
> >>
> >> Can you check the SQL Server error log and post the error messages
here?
> > You
> >> will find the log in MSSQL\Log folder under the installation path.
> >> --
> >> Vyas, MVP (SQL Server)
> >> http://vyaskn.tripod.com/
> >>
> >>
> >> "Santosh" <santoshNoSpam@.NoSpam.net> wrote in message
> >> news:eHXmsUcmEHA.3352@.TK2MSFTNGP10.phx.gbl...
> >> > Friends,
> >> >
> >> > The SQL server 2000 was running fine until all of a Sudden I got this
> >> > message,
> >> >
> >> > SQL Server is aborting. Fatal exception c0000005 caught.
> >> >
> >> > The Service would not start, and I need help in Recovering it.
> >> >
> >> > Any help is greatly Appreciated.
> >> >
> >> > --
> >> >
> >> > Santosh
> >> >
> >> >
> >>
> >>
> >>
> >>
> >
> >
>