• 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.