Monthly Archives: May 2016

Find Legacy SQL Joins

— will list both Views and Stored procedures in a particular database SELECT OBJECT_NAME(object_id),OBJECT_DEFINITION(object_id) FROM sys.objects WHERE OBJECT_DEFINITION(object_id) LIKE ‘%*=%’ or OBJECT_DEFINITION(object_id) LIKE ‘%=*%’ Advertisements

Posted in Administration | Leave a comment

Inplace Upgrade Win 2008 to 2008R2

Just wanted to write this for the fun of it, I know it is an old edition which is out of main stream support as of Jan 2015, it has extended support till 2020 WindowsSupport_LifeCycle The upgrade is pretty self … Continue reading

Posted in Windows | Leave a comment