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 |
|
Kristen
Test
22859 Posts |
 Posted - 2010-02-25 : 02:27:58
|
| Following post in another thread I am thinking about a script to check that a database is set up "in preferred manner"Is compatibility mode 100?Is page-protection set to CHECKSUMAre latest Service Packs in place...Before I spend hours writing one is there one lying around somewhere?Thanks. |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2010-02-25 : 03:55:29
|
good thinking. I will subscribe to this thread 
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-02-25 : 05:47:16
|
| 12,702 helpful posts ... |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-02-25 : 14:30:02
|
| Thanks Russell. So there was a Best Practice Analyzer in SQL 2005 ... now replaced with a set of Policies ... not sure that is a forward step for generic reporting, but its food for thought, thanks.(Your second URL looks to have succumbed to Cut&Paste-itice ) |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-02-25 : 14:57:39
|
| I'm sorry I asked now ... a VARCHAR(MAX) of white-papers! Good stuff Russell, thanks for that. I may be gone some time ... |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-02-25 : 16:45:15
|
LOL  |
|
|
|
|
|
|
Checklist