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 |
|
JaybeeSQL
Posting Yak Master
112 Posts |
 Posted - 2014-02-12 : 11:19:19
|
| Anyone know the system table this is in? Cheers,JB |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2014-02-12 : 15:07:51
|
| select * from sys.databases where is_auto_create_stats_on=1 |
 |
|
|
JaybeeSQL
Posting Yak Master
112 Posts |
Posted - 2014-02-13 : 06:35:57
|
| No, this is for SQL 2000 ... |
|
|
|
JaybeeSQL
Posting Yak Master
112 Posts |
Posted - 2014-02-13 : 07:30:04
|
| Never mind, I've figured it out...sp_MSForeachDB 'print ''?'' exec sp_dboption ?' |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2014-02-13 : 07:31:28
|
| SELECT name FROM sysdatabases WHERE DATABASEPROPERTY(name,'IsAutoCreateStatistics')=1 |
|
|
|
|
|
|
Check all DB's for auto create statistics turned o