Cannot kill process with EC wait type

Hi
I had tired to create index on large databse (>200GB, engine ss2k) but
I got errors, so I executed DBCC CHECKDB. DBCC told me that I have to
execute it with repair options. But I noticed in Activity Monitor that
I had still running creating index process with EC wait type. Then I
started to kill it but without success.
Is it possible to kill such process, without restarting sql server?
Best regards,
BartekHi Bartek
The process may be rolling back try KILL WITH STATUSONLY to see what it is
doing.
John
"Bartolo" wrote:
> Hi
> I had tired to create index on large databse (>200GB, engine ss2k) but
> I got errors, so I executed DBCC CHECKDB. DBCC told me that I have to
> execute it with repair options. But I noticed in Activity Monitor that
> I had still running creating index process with EC wait type. Then I
> started to kill it but without success.
> Is it possible to kill such process, without restarting sql server?
> Best regards,
> Bartek
>|||Hi John
Thanks for reponse. I tried this one, it stuck to 100% for few days.
I got reply on another forums that I can't even kill this process with
server restart.
It is really confusing that there is no way to get rid off such
process.
Bartek
On 16 Mar, 08:22, John Bell <jbellnewspo...@.hotmail.com> wrote:
> Hi Bartek
> The process may be rolling back try KILL WITH STATUSONLY to see what it is
> doing.
> John
> "Bartolo" wrote:
> > Hi
> > I had tired to create index on large databse (>200GB, engine ss2k) but
> > I got errors, so I executed DBCC CHECKDB. DBCC told me that I have to
> > execute it with repair options. But I noticed in Activity Monitor that
> > I had still running creating index process with EC wait type. Then I
> > started to kill it but without success.
> > Is it possible to kill such process, without restarting sql server?
> > Best regards,
> > Bartek|||I succeeded.
It seems that restarting SQL Server is the only opition to get rid of
such process.
Cheers,
Bartek
On 17 Mar, 12:51, Bartolo <andrew...@.gmail.com> wrote:
> Hi John
> Thanks for reponse. I tried this one, it stuck to 100% for few days.
> I got reply on another forums that I can't even kill this process with
> server restart.
> It is really confusing that there is no way to get rid off such
> process.
> Bartek
> On 16 Mar, 08:22, John Bell <jbellnewspo...@.hotmail.com> wrote:
> > Hi Bartek
> > The process may be rolling back try KILL WITH STATUSONLY to see what it is
> > doing.
> > John
> > "Bartolo" wrote:
> > > Hi
> > > I had tired to create index on large databse (>200GB, engine ss2k) but
> > > I got errors, so I executed DBCC CHECKDB. DBCC told me that I have to
> > > execute it with repair options. But I noticed in Activity Monitor that
> > > I had still running creating index process with EC wait type. Then I
> > > started to kill it but without success.
> > > Is it possible to kill such process, without restarting sql server?
> > > Best regards,
> > > Bartek