Script to drop and re-create all foreign keys

------------ -- Generate Drop Disable.sql SET NOCOUNT ON print 'USE ' + DB_NAME() print '' -- Generate Drops for All Foreign Keys in Database print '-- Drop Foreign Keys' print '' select distinct 'ALTER TABLE ['+ SCHEMA_NAME(CAST(OBJECTPROPERTYEX(tbl.id , 'SchemaId') AS INT)) +'].... [More]

Gently killing the explorer.exe process

Go to Start > Shutdown. When the dialog appears, hold CTRL+ALT+SHIFT and press Cancel. Explorer will cleanly unload all of it’s resources and shutdown. To start it back up, open Task Manager (CTRL+SHIFT+ESC is one way) and go to File > New Task and run ‘explorer’. This... [More]

Search

Tags

None

    Disclaimer

    The opinions expressed herein are my own personal opinions and do not represent my employer's view in anyway.

    © Copyright 2009