data.samgreene.com

data.samgreene.com

Search
Skip to content
  • About
  • Monitoring And Automation

Monthly Archives: December 2012

Validate Views
TSQL

Validate Views

December 6, 2012 Sam Leave a comment

Sometimes after moving databases between servers some views may be broken. This query will generate statements to test the views in your database.

views

Categories

  • 2008
  • Active Directory
  • Admin
  • Backups
  • Badass Tools
  • Cluster
  • Education
  • Interviews
  • Monitoring
  • Party
  • Powershell
  • Razzamataz
  • Restores
  • Roles
  • Schema
  • Scripts
  • Security
  • Speaking
  • sql 2005 backup restore copy
  • SSAS
  • SSIS
  • SSRS
  • Text
  • Troubleshooting
  • TSQL
  • Uncategorized
  • Upgrading
  • VirtualBox

Recent Posts

  • If you work on a computer, get these tools
  • Tweaked script to find all db_owner members
  • Running a plethora of T-SQL
  • Easy Security Fixes
  • Validate Views

Recent Comments

    Archives

    • March 2017
    • July 2015
    • March 2015
    • February 2015
    • December 2012
    • November 2012
    • October 2012
    • April 2012
    • March 2012
    • December 2011
    • November 2011
    • August 2011
    • April 2011
    • December 2010
    • October 2010
    • September 2010
    • June 2010
    • May 2010
    • April 2010
    • March 2010
    • February 2010
    • December 2009
    • November 2009
    • October 2009
    • March 2007
    • February 2007

    Meta

    • Log in
    • Entries feed
    • Comments feed
    • WordPress.org
    Proudly powered by WordPress