Discussion:
sp_flushstats
(too old to reply)
Daniel
2008-10-16 06:53:28 UTC
Permalink
Hello all,

I am using sp_flushstats in a script and needs to know the
warning and error that indicate that sp_flushstat didn't
work well.

Could you please tell me what indicates that sp_flushstats
did not perform well?

I saw Error 3019 and 3020. Any other errors and warnings?

thanks
Manish Negandhi
2008-10-16 08:45:43 UTC
Permalink
Post by Daniel
Hello all,
I am using sp_flushstats in a script and needs to know the
warning and error that indicate that sp_flushstat didn't
work well.
Could you please tell me what indicates that sp_flushstats
did not perform well?
I saw Error 3019 and 3020. Any other errors and warnings?
thanks
I think these are the error numbers you might want to look at 6008,
6009, 6010, 6011, 3019, 3020, and 3021

http://infocenter.sybase.com/help/topic/com.sybase.39996_1250/html/svrtsg/svrtsg335.htm?resultof=%22%36%30%30%38%22%20

-HTH
Manish Negandhi
[TeamSybase]
Daniel
2008-10-17 16:10:24 UTC
Permalink
hello.

I just need to know what are the error codes and warning
that should not be ignored and that are related to
sp_flushstats

the errors that you sent me are server errors that are not
related to sp_flushstats

thank you for your support
Post by Daniel
Hello all,
I am using sp_flushstats in a script and needs to know
the warning and error that indicate that sp_flushstat
didn't work well.
Could you please tell me what indicates that
sp_flushstats did not perform well?
I saw Error 3019 and 3020. Any other errors and
warnings? >
Post by Daniel
thanks
I think these are the error numbers you might want to look
at 6008, 6009, 6010, 6011, 3019, 3020, and 3021
http://infocenter.sybase.com/help/topic/com.sybase.39996_1250/html/svrtsg/svrtsg335.htm?resultof="6008"
-HTH
Manish Negandhi
[TeamSybase]
Sherlock, Kevin [TeamSybase]
2008-10-17 19:14:28 UTC
Permalink
Daniel,
I would think that _any_ errors returned by sp_flushstats should not be
ignored. What are you trying to accomplish?

One of the main reasons that i could see sp_flushstats "failing" is if the
database is in "read-only" mode, or you don't have "dbo" authority.

<Daniel> wrote in message news:***@sybase.com...
hello.

I just need to know what are the error codes and warning
that should not be ignored and that are related to
sp_flushstats

the errors that you sent me are server errors that are not
related to sp_flushstats

thank you for your support
Post by Daniel
Hello all,
I am using sp_flushstats in a script and needs to know
the warning and error that indicate that sp_flushstat
didn't work well.
Could you please tell me what indicates that
sp_flushstats did not perform well?
I saw Error 3019 and 3020. Any other errors and
warnings? >
Post by Daniel
thanks
I think these are the error numbers you might want to look
at 6008, 6009, 6010, 6011, 3019, 3020, and 3021
http://infocenter.sybase.com/help/topic/com.sybase.39996_1250/html/svrtsg/svrtsg335.htm?resultof="6008"
-HTH
Manish Negandhi
[TeamSybase]
Daniel
2008-10-18 12:32:48 UTC
Permalink
hi
I am trying to build a script that calls sp_flushstats and
therefore need to catch the error that will cause my script
to exit
thanks
Post by Sherlock, Kevin [TeamSybase]
Daniel,
I would think that _any_ errors returned by sp_flushstats
should not be ignored. What are you trying to
accomplish?
One of the main reasons that i could see sp_flushstats
"failing" is if the database is in "read-only" mode, or
you don't have "dbo" authority.
I just need to know what are the error codes and warning
that should not be ignored and that are related to
sp_flushstats
the errors that you sent me are server errors that are not
related to sp_flushstats
thank you for your support
Post by Daniel
Hello all,
I am using sp_flushstats in a script and needs to know
the warning and error that indicate that sp_flushstat
didn't work well.
Could you please tell me what indicates that
sp_flushstats did not perform well?
I saw Error 3019 and 3020. Any other errors and
warnings? >
Post by Daniel
thanks
I think these are the error numbers you might want to
look at 6008, 6009, 6010, 6011, 3019, 3020, and 3021
http://infocenter.sybase.com/help/topic/com.sybase.39996_1250/html/svrtsg/svrtsg335.htm?resultof="6008"
Post by Sherlock, Kevin [TeamSybase]
-HTH
Manish Negandhi
[TeamSybase]
Loading...