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.