SanDroid (12/14/2010)

---

phil.wood 94423 (12/13/2010)

---

SanDroid (12/10/2010)

---

phil.wood 94423 (12/10/2010)

---

My default schema is not dbo!

Most QOTD readers that actually run or test the QOTD scripts do so in a default NON Production installation of SQL server that is easily rebuilt. Think Virtual PC with a Snapshot, or a server with a good Ghost backup image.

Also a database where you have DBO schema access is prefered and taken for granted, unless otherwise stated in the script or example code.

Good thing the QOTD was not about a script to clear all event and server logs and clean the DMV's of historical data... 😎

Isn't it normal to have development environments, virtual or otherwise, set up as similarly as possible to production? It should be.

My point is don't blame the author just becuase you do not understand how his script will run in your custom environment.

Of course your Dev environment should match your prod.

But I would not run any QOTD code, or any code from the internet, in a database supporting Development of a specific application either.