Hi!
We have a problem with a database asignation. When we try to make an attach
(sp_attach_db) the system display an error:
Server: Msg 3624, Level 20, State 1, Line 1
Location: recovery.c: 2657
Expression: seenCkptEnd
SPID: 10
Process ID: 560
Connection Broken
We work with SQL Server 7.0 SP2
What can we do?
Thank you in advance.
Did you detach the database first? Does it come from the same SQL Server version?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Israel" <i.rodriguez@.promis.net> wrote in message news:OYJEL87rEHA.212@.TK2MSFTNGP10.phx.gbl...
> Hi!
> We have a problem with a database asignation. When we try to make an attach
> (sp_attach_db) the system display an error:
> Server: Msg 3624, Level 20, State 1, Line 1
> Location: recovery.c: 2657
> Expression: seenCkptEnd
> SPID: 10
> Process ID: 560
> Connection Broken
> We work with SQL Server 7.0 SP2
> What can we do?
> Thank you in advance.
>
|||I do not think that at least half the groups you have included on your To:
line are relevant
It looks as though you may have a problem with the files which you are
trying to attach.
How did you shutdown the database for which these files originally were?
Was it cleanly?
What was your syntax?
The files were not in use by a database were they?
It may be that you need to contact the boys and girls in MS PSS and they may
be able to help you here.
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.Konesans.com
"Israel" <i.rodriguez@.promis.net> wrote in message
news:OYJEL87rEHA.212@.TK2MSFTNGP10.phx.gbl...
> Hi!
> We have a problem with a database asignation. When we try to make an
> attach
> (sp_attach_db) the system display an error:
> Server: Msg 3624, Level 20, State 1, Line 1
> Location: recovery.c: 2657
> Expression: seenCkptEnd
> SPID: 10
> Process ID: 560
> Connection Broken
> We work with SQL Server 7.0 SP2
> What can we do?
> Thank you in advance.
>
Showing posts with label msg. Show all posts
Showing posts with label msg. Show all posts
Friday, March 23, 2012
Problem with sp_attach_db
Hi!
We have a problem with a database asignation. When we try to make an attach
(sp_attach_db) the system display an error:
Server: Msg 3624, Level 20, State 1, Line 1
Location: recovery.c: 2657
Expression: seenCkptEnd
SPID: 10
Process ID: 560
Connection Broken
We work with SQL Server 7.0 SP2
What can we do?
Thank you in advance.
Did you detach the database first? Does it come from the same SQL Server version?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Israel" <i.rodriguez@.promis.net> wrote in message news:OYJEL87rEHA.212@.TK2MSFTNGP10.phx.gbl...
> Hi!
> We have a problem with a database asignation. When we try to make an attach
> (sp_attach_db) the system display an error:
> Server: Msg 3624, Level 20, State 1, Line 1
> Location: recovery.c: 2657
> Expression: seenCkptEnd
> SPID: 10
> Process ID: 560
> Connection Broken
> We work with SQL Server 7.0 SP2
> What can we do?
> Thank you in advance.
>
|||I do not think that at least half the groups you have included on your To:
line are relevant
It looks as though you may have a problem with the files which you are
trying to attach.
How did you shutdown the database for which these files originally were?
Was it cleanly?
What was your syntax?
The files were not in use by a database were they?
It may be that you need to contact the boys and girls in MS PSS and they may
be able to help you here.
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.Konesans.com
"Israel" <i.rodriguez@.promis.net> wrote in message
news:OYJEL87rEHA.212@.TK2MSFTNGP10.phx.gbl...
> Hi!
> We have a problem with a database asignation. When we try to make an
> attach
> (sp_attach_db) the system display an error:
> Server: Msg 3624, Level 20, State 1, Line 1
> Location: recovery.c: 2657
> Expression: seenCkptEnd
> SPID: 10
> Process ID: 560
> Connection Broken
> We work with SQL Server 7.0 SP2
> What can we do?
> Thank you in advance.
>
We have a problem with a database asignation. When we try to make an attach
(sp_attach_db) the system display an error:
Server: Msg 3624, Level 20, State 1, Line 1
Location: recovery.c: 2657
Expression: seenCkptEnd
SPID: 10
Process ID: 560
Connection Broken
We work with SQL Server 7.0 SP2
What can we do?
Thank you in advance.
Did you detach the database first? Does it come from the same SQL Server version?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Israel" <i.rodriguez@.promis.net> wrote in message news:OYJEL87rEHA.212@.TK2MSFTNGP10.phx.gbl...
> Hi!
> We have a problem with a database asignation. When we try to make an attach
> (sp_attach_db) the system display an error:
> Server: Msg 3624, Level 20, State 1, Line 1
> Location: recovery.c: 2657
> Expression: seenCkptEnd
> SPID: 10
> Process ID: 560
> Connection Broken
> We work with SQL Server 7.0 SP2
> What can we do?
> Thank you in advance.
>
|||I do not think that at least half the groups you have included on your To:
line are relevant
It looks as though you may have a problem with the files which you are
trying to attach.
How did you shutdown the database for which these files originally were?
Was it cleanly?
What was your syntax?
The files were not in use by a database were they?
It may be that you need to contact the boys and girls in MS PSS and they may
be able to help you here.
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.Konesans.com
"Israel" <i.rodriguez@.promis.net> wrote in message
news:OYJEL87rEHA.212@.TK2MSFTNGP10.phx.gbl...
> Hi!
> We have a problem with a database asignation. When we try to make an
> attach
> (sp_attach_db) the system display an error:
> Server: Msg 3624, Level 20, State 1, Line 1
> Location: recovery.c: 2657
> Expression: seenCkptEnd
> SPID: 10
> Process ID: 560
> Connection Broken
> We work with SQL Server 7.0 SP2
> What can we do?
> Thank you in advance.
>
Problem with sp_attach_db
Hi!
We have a problem with a database asignation. When we try to make an attach
(sp_attach_db) the system display an error:
Server: Msg 3624, Level 20, State 1, Line 1
Location: recovery.c: 2657
Expression: seenCkptEnd
SPID: 10
Process ID: 560
Connection Broken
We work with SQL Server 7.0 SP2
What can we do?
Thank you in advance.
Did you detach the database first? Does it come from the same SQL Server version?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Israel" <i.rodriguez@.promis.net> wrote in message news:OYJEL87rEHA.212@.TK2MSFTNGP10.phx.gbl...
> Hi!
> We have a problem with a database asignation. When we try to make an attach
> (sp_attach_db) the system display an error:
> Server: Msg 3624, Level 20, State 1, Line 1
> Location: recovery.c: 2657
> Expression: seenCkptEnd
> SPID: 10
> Process ID: 560
> Connection Broken
> We work with SQL Server 7.0 SP2
> What can we do?
> Thank you in advance.
>
|||I do not think that at least half the groups you have included on your To:
line are relevant
It looks as though you may have a problem with the files which you are
trying to attach.
How did you shutdown the database for which these files originally were?
Was it cleanly?
What was your syntax?
The files were not in use by a database were they?
It may be that you need to contact the boys and girls in MS PSS and they may
be able to help you here.
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.Konesans.com
"Israel" <i.rodriguez@.promis.net> wrote in message
news:OYJEL87rEHA.212@.TK2MSFTNGP10.phx.gbl...
> Hi!
> We have a problem with a database asignation. When we try to make an
> attach
> (sp_attach_db) the system display an error:
> Server: Msg 3624, Level 20, State 1, Line 1
> Location: recovery.c: 2657
> Expression: seenCkptEnd
> SPID: 10
> Process ID: 560
> Connection Broken
> We work with SQL Server 7.0 SP2
> What can we do?
> Thank you in advance.
>
We have a problem with a database asignation. When we try to make an attach
(sp_attach_db) the system display an error:
Server: Msg 3624, Level 20, State 1, Line 1
Location: recovery.c: 2657
Expression: seenCkptEnd
SPID: 10
Process ID: 560
Connection Broken
We work with SQL Server 7.0 SP2
What can we do?
Thank you in advance.
Did you detach the database first? Does it come from the same SQL Server version?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Israel" <i.rodriguez@.promis.net> wrote in message news:OYJEL87rEHA.212@.TK2MSFTNGP10.phx.gbl...
> Hi!
> We have a problem with a database asignation. When we try to make an attach
> (sp_attach_db) the system display an error:
> Server: Msg 3624, Level 20, State 1, Line 1
> Location: recovery.c: 2657
> Expression: seenCkptEnd
> SPID: 10
> Process ID: 560
> Connection Broken
> We work with SQL Server 7.0 SP2
> What can we do?
> Thank you in advance.
>
|||I do not think that at least half the groups you have included on your To:
line are relevant
It looks as though you may have a problem with the files which you are
trying to attach.
How did you shutdown the database for which these files originally were?
Was it cleanly?
What was your syntax?
The files were not in use by a database were they?
It may be that you need to contact the boys and girls in MS PSS and they may
be able to help you here.
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.Konesans.com
"Israel" <i.rodriguez@.promis.net> wrote in message
news:OYJEL87rEHA.212@.TK2MSFTNGP10.phx.gbl...
> Hi!
> We have a problem with a database asignation. When we try to make an
> attach
> (sp_attach_db) the system display an error:
> Server: Msg 3624, Level 20, State 1, Line 1
> Location: recovery.c: 2657
> Expression: seenCkptEnd
> SPID: 10
> Process ID: 560
> Connection Broken
> We work with SQL Server 7.0 SP2
> What can we do?
> Thank you in advance.
>
Problem with sp_attach_db
Hi!
We have a problem with a database asignation. When we try to make an attach
(sp_attach_db) the system display an error:
Server: Msg 3624, Level 20, State 1, Line 1
Location: recovery.c: 2657
Expression: seenCkptEnd
SPID: 10
Process ID: 560
Connection Broken
We work with SQL Server 7.0 SP2
What can we do?
Thank you in advance.Did you detach the database first? Does it come from the same SQL Server version?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Israel" <i.rodriguez@.promis.net> wrote in message news:OYJEL87rEHA.212@.TK2MSFTNGP10.phx.gbl...
> Hi!
> We have a problem with a database asignation. When we try to make an attach
> (sp_attach_db) the system display an error:
> Server: Msg 3624, Level 20, State 1, Line 1
> Location: recovery.c: 2657
> Expression: seenCkptEnd
> SPID: 10
> Process ID: 560
> Connection Broken
> We work with SQL Server 7.0 SP2
> What can we do?
> Thank you in advance.
>|||I do not think that at least half the groups you have included on your To:
line are relevant
It looks as though you may have a problem with the files which you are
trying to attach.
How did you shutdown the database for which these files originally were?
Was it cleanly?
What was your syntax?
The files were not in use by a database were they?
It may be that you need to contact the boys and girls in MS PSS and they may
be able to help you here.
--
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.Konesans.com
"Israel" <i.rodriguez@.promis.net> wrote in message
news:OYJEL87rEHA.212@.TK2MSFTNGP10.phx.gbl...
> Hi!
> We have a problem with a database asignation. When we try to make an
> attach
> (sp_attach_db) the system display an error:
> Server: Msg 3624, Level 20, State 1, Line 1
> Location: recovery.c: 2657
> Expression: seenCkptEnd
> SPID: 10
> Process ID: 560
> Connection Broken
> We work with SQL Server 7.0 SP2
> What can we do?
> Thank you in advance.
>sql
We have a problem with a database asignation. When we try to make an attach
(sp_attach_db) the system display an error:
Server: Msg 3624, Level 20, State 1, Line 1
Location: recovery.c: 2657
Expression: seenCkptEnd
SPID: 10
Process ID: 560
Connection Broken
We work with SQL Server 7.0 SP2
What can we do?
Thank you in advance.Did you detach the database first? Does it come from the same SQL Server version?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Israel" <i.rodriguez@.promis.net> wrote in message news:OYJEL87rEHA.212@.TK2MSFTNGP10.phx.gbl...
> Hi!
> We have a problem with a database asignation. When we try to make an attach
> (sp_attach_db) the system display an error:
> Server: Msg 3624, Level 20, State 1, Line 1
> Location: recovery.c: 2657
> Expression: seenCkptEnd
> SPID: 10
> Process ID: 560
> Connection Broken
> We work with SQL Server 7.0 SP2
> What can we do?
> Thank you in advance.
>|||I do not think that at least half the groups you have included on your To:
line are relevant
It looks as though you may have a problem with the files which you are
trying to attach.
How did you shutdown the database for which these files originally were?
Was it cleanly?
What was your syntax?
The files were not in use by a database were they?
It may be that you need to contact the boys and girls in MS PSS and they may
be able to help you here.
--
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.Konesans.com
"Israel" <i.rodriguez@.promis.net> wrote in message
news:OYJEL87rEHA.212@.TK2MSFTNGP10.phx.gbl...
> Hi!
> We have a problem with a database asignation. When we try to make an
> attach
> (sp_attach_db) the system display an error:
> Server: Msg 3624, Level 20, State 1, Line 1
> Location: recovery.c: 2657
> Expression: seenCkptEnd
> SPID: 10
> Process ID: 560
> Connection Broken
> We work with SQL Server 7.0 SP2
> What can we do?
> Thank you in advance.
>sql
Problem with sp_attach_db
Hi!
We have a problem with a database asignation. When we try to make an attach
(sp_attach_db) the system display an error:
Server: Msg 3624, Level 20, State 1, Line 1
Location: recovery.c: 2657
Expression: seenCkptEnd
SPID: 10
Process ID: 560
Connection Broken
We work with SQL Server 7.0 SP2
What can we do?
Thank you in advance.Did you detach the database first? Does it come from the same SQL Server ver
sion?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Israel" <i.rodriguez@.promis.net> wrote in message news:OYJEL87rEHA.212@.TK2MSFTNGP10.phx.gbl
..
> Hi!
> We have a problem with a database asignation. When we try to make an attac
h
> (sp_attach_db) the system display an error:
> Server: Msg 3624, Level 20, State 1, Line 1
> Location: recovery.c: 2657
> Expression: seenCkptEnd
> SPID: 10
> Process ID: 560
> Connection Broken
> We work with SQL Server 7.0 SP2
> What can we do?
> Thank you in advance.
>|||I do not think that at least half the groups you have included on your To:
line are relevant
It looks as though you may have a problem with the files which you are
trying to attach.
How did you shutdown the database for which these files originally were?
Was it cleanly?
What was your syntax?
The files were not in use by a database were they?
It may be that you need to contact the boys and girls in MS PSS and they may
be able to help you here.
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.Konesans.com
"Israel" <i.rodriguez@.promis.net> wrote in message
news:OYJEL87rEHA.212@.TK2MSFTNGP10.phx.gbl...
> Hi!
> We have a problem with a database asignation. When we try to make an
> attach
> (sp_attach_db) the system display an error:
> Server: Msg 3624, Level 20, State 1, Line 1
> Location: recovery.c: 2657
> Expression: seenCkptEnd
> SPID: 10
> Process ID: 560
> Connection Broken
> We work with SQL Server 7.0 SP2
> What can we do?
> Thank you in advance.
>
We have a problem with a database asignation. When we try to make an attach
(sp_attach_db) the system display an error:
Server: Msg 3624, Level 20, State 1, Line 1
Location: recovery.c: 2657
Expression: seenCkptEnd
SPID: 10
Process ID: 560
Connection Broken
We work with SQL Server 7.0 SP2
What can we do?
Thank you in advance.Did you detach the database first? Does it come from the same SQL Server ver
sion?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Israel" <i.rodriguez@.promis.net> wrote in message news:OYJEL87rEHA.212@.TK2MSFTNGP10.phx.gbl
..
> Hi!
> We have a problem with a database asignation. When we try to make an attac
h
> (sp_attach_db) the system display an error:
> Server: Msg 3624, Level 20, State 1, Line 1
> Location: recovery.c: 2657
> Expression: seenCkptEnd
> SPID: 10
> Process ID: 560
> Connection Broken
> We work with SQL Server 7.0 SP2
> What can we do?
> Thank you in advance.
>|||I do not think that at least half the groups you have included on your To:
line are relevant
It looks as though you may have a problem with the files which you are
trying to attach.
How did you shutdown the database for which these files originally were?
Was it cleanly?
What was your syntax?
The files were not in use by a database were they?
It may be that you need to contact the boys and girls in MS PSS and they may
be able to help you here.
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.Konesans.com
"Israel" <i.rodriguez@.promis.net> wrote in message
news:OYJEL87rEHA.212@.TK2MSFTNGP10.phx.gbl...
> Hi!
> We have a problem with a database asignation. When we try to make an
> attach
> (sp_attach_db) the system display an error:
> Server: Msg 3624, Level 20, State 1, Line 1
> Location: recovery.c: 2657
> Expression: seenCkptEnd
> SPID: 10
> Process ID: 560
> Connection Broken
> We work with SQL Server 7.0 SP2
> What can we do?
> Thank you in advance.
>
Problem with sp_attach_db
Hi!
We have a problem with a database asignation. When we try to make an attach
(sp_attach_db) the system display an error:
Server: Msg 3624, Level 20, State 1, Line 1
Location: recovery.c: 2657
Expression: seenCkptEnd
SPID: 10
Process ID: 560
Connection Broken
We work with SQL Server 7.0 SP2
What can we do?
Thank you in advance.
Did you detach the database first? Does it come from the same SQL Server version?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Israel" <i.rodriguez@.promis.net> wrote in message news:OYJEL87rEHA.212@.TK2MSFTNGP10.phx.gbl...
> Hi!
> We have a problem with a database asignation. When we try to make an attach
> (sp_attach_db) the system display an error:
> Server: Msg 3624, Level 20, State 1, Line 1
> Location: recovery.c: 2657
> Expression: seenCkptEnd
> SPID: 10
> Process ID: 560
> Connection Broken
> We work with SQL Server 7.0 SP2
> What can we do?
> Thank you in advance.
>
|||I do not think that at least half the groups you have included on your To:
line are relevant
It looks as though you may have a problem with the files which you are
trying to attach.
How did you shutdown the database for which these files originally were?
Was it cleanly?
What was your syntax?
The files were not in use by a database were they?
It may be that you need to contact the boys and girls in MS PSS and they may
be able to help you here.
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.Konesans.com
"Israel" <i.rodriguez@.promis.net> wrote in message
news:OYJEL87rEHA.212@.TK2MSFTNGP10.phx.gbl...
> Hi!
> We have a problem with a database asignation. When we try to make an
> attach
> (sp_attach_db) the system display an error:
> Server: Msg 3624, Level 20, State 1, Line 1
> Location: recovery.c: 2657
> Expression: seenCkptEnd
> SPID: 10
> Process ID: 560
> Connection Broken
> We work with SQL Server 7.0 SP2
> What can we do?
> Thank you in advance.
>
We have a problem with a database asignation. When we try to make an attach
(sp_attach_db) the system display an error:
Server: Msg 3624, Level 20, State 1, Line 1
Location: recovery.c: 2657
Expression: seenCkptEnd
SPID: 10
Process ID: 560
Connection Broken
We work with SQL Server 7.0 SP2
What can we do?
Thank you in advance.
Did you detach the database first? Does it come from the same SQL Server version?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Israel" <i.rodriguez@.promis.net> wrote in message news:OYJEL87rEHA.212@.TK2MSFTNGP10.phx.gbl...
> Hi!
> We have a problem with a database asignation. When we try to make an attach
> (sp_attach_db) the system display an error:
> Server: Msg 3624, Level 20, State 1, Line 1
> Location: recovery.c: 2657
> Expression: seenCkptEnd
> SPID: 10
> Process ID: 560
> Connection Broken
> We work with SQL Server 7.0 SP2
> What can we do?
> Thank you in advance.
>
|||I do not think that at least half the groups you have included on your To:
line are relevant
It looks as though you may have a problem with the files which you are
trying to attach.
How did you shutdown the database for which these files originally were?
Was it cleanly?
What was your syntax?
The files were not in use by a database were they?
It may be that you need to contact the boys and girls in MS PSS and they may
be able to help you here.
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.Konesans.com
"Israel" <i.rodriguez@.promis.net> wrote in message
news:OYJEL87rEHA.212@.TK2MSFTNGP10.phx.gbl...
> Hi!
> We have a problem with a database asignation. When we try to make an
> attach
> (sp_attach_db) the system display an error:
> Server: Msg 3624, Level 20, State 1, Line 1
> Location: recovery.c: 2657
> Expression: seenCkptEnd
> SPID: 10
> Process ID: 560
> Connection Broken
> We work with SQL Server 7.0 SP2
> What can we do?
> Thank you in advance.
>
Wednesday, March 7, 2012
Problem With Query Cost Govenor
Hi,
I'm running this:
DBCC CHECKDB ( '<database>', REPAIR_FAST ) WITH ALL_ERRORMSGS, TABLOCK
And I'm getting this:
Server: Msg 8649, Level 17, State 1, Line 2
The query has been canceled because the estimated cost of this query (13451)
exceeds the configured threshold of 10800. Contact the system administrator.
When I remove the query governor it runs in about 30 seconds not 10800+.
The stats on this database were manually updated with sp_createstats and
sp_updatestats.
Does anyone have any recommendations?
Thanks,
BryanYou had some reply on this last time you posted:
http://groups.google.com/groups?hl=...lic.sqlserver.*
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"BDB" <reply@.to.group.com> wrote in message news:%23TgJUrEaFHA.3876@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I'm running this:
> DBCC CHECKDB ( '<database>', REPAIR_FAST ) WITH ALL_ERRORMSGS, TABLOCK
> And I'm getting this:
> Server: Msg 8649, Level 17, State 1, Line 2
> The query has been canceled because the estimated cost of this query (1345
1)
> exceeds the configured threshold of 10800. Contact the system administrato
r.
> When I remove the query governor it runs in about 30 seconds not 10800+.
> The stats on this database were manually updated with sp_createstats and
> sp_updatestats.
> Does anyone have any recommendations?
> Thanks,
> Bryan
>
I'm running this:
DBCC CHECKDB ( '<database>', REPAIR_FAST ) WITH ALL_ERRORMSGS, TABLOCK
And I'm getting this:
Server: Msg 8649, Level 17, State 1, Line 2
The query has been canceled because the estimated cost of this query (13451)
exceeds the configured threshold of 10800. Contact the system administrator.
When I remove the query governor it runs in about 30 seconds not 10800+.
The stats on this database were manually updated with sp_createstats and
sp_updatestats.
Does anyone have any recommendations?
Thanks,
BryanYou had some reply on this last time you posted:
http://groups.google.com/groups?hl=...lic.sqlserver.*
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"BDB" <reply@.to.group.com> wrote in message news:%23TgJUrEaFHA.3876@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I'm running this:
> DBCC CHECKDB ( '<database>', REPAIR_FAST ) WITH ALL_ERRORMSGS, TABLOCK
> And I'm getting this:
> Server: Msg 8649, Level 17, State 1, Line 2
> The query has been canceled because the estimated cost of this query (1345
1)
> exceeds the configured threshold of 10800. Contact the system administrato
r.
> When I remove the query governor it runs in about 30 seconds not 10800+.
> The stats on this database were manually updated with sp_createstats and
> sp_updatestats.
> Does anyone have any recommendations?
> Thanks,
> Bryan
>
Subscribe to:
Posts (Atom)