This is the fifth post in my series on Developer Toolbox. We are continuing to add scripts to the toolbox using the SSMS Template Browser that are useful to developers. Today I want to talk about a couple of queries that I use to find the dependencies of a database object. There are times during… Continue reading Developer Toolbox – Finding Dependencies
This is the fourth post in my series on Developer Toolbox. We are continuing to add scripts to the toolbox using the SSMS Template Browser that are useful to developers. Today I want to talk about 2 system stored procedures that can help with T-SQL development, SP_HELP and SP_HELPTEXT. Examples are from the AdventureWorks database.… Continue reading Developer Toolbox – Help for Database Objects
This is the third post in my series on Developer Toolbox. We are continuing to add scripts to the toolbox that are useful to developers. Today is a script I call “Find a Column”. It searches the catalog for columns from tables (and views) where the column name contains a string that you provide. Note… Continue reading Developer Toolbox – Find a Column
Steve Henry's SQL Server Tips 