Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ani.gautam
Starting Member
2 Posts |
 Posted - 2014-07-22 : 05:37:44
|
| HII am showing an alert that CHECKDB is executed or not in my application(If run then how many days before its run).But problem is that if some one execute CHECKFILEGROUP,it also update the value of "dbi_dbccLastKnownGood" so i am unable to identify that CHECKDB is executed or notPlease suggest that how to check that CHECKDB executed (not check with "dbi_dbccLastKnownGood")ThanksAnil |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-07-22 : 12:41:57
|
| Why would checkdb or a similar process be run in an application rather than by a DBA or a SQL Agent job?Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
ani.gautam
Starting Member
2 Posts |
Posted - 2014-07-23 : 03:21:27
|
I am not using CHECKDB in application .. i am just checking time when last time its executed. For which i m reading the value of "dbi_dbccLastKnownGood"quote:
Originally posted by tkizer
Why would checkdb or a similar process be run in an application rather than by a DBA or a SQL Agent job?Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/
|
|
|
|
|
|
|
update of "dbi_dbccLastKnownGood"