Easily extractss the complete stored procedure call hierarchy from "sysdepends" table of SQL Server and represent it in a pseudo-graphical tree-view.The script uses a temporary table (automatically created/dropped) to hold children and parents of relationships. For representing the call hierarchy the table contains a level field (depth) and a field containing the "enumerated path" (using […]
2005-03-14 (first published: 2005-03-01)
2,385 reads
Gets most important information of database structure. This includes all user tables, their fields, datatypes, defaults (including default constraint names), etc, primary keys and their fields, unique constraints and their fields, check constraints (including their conditions), foreign key constraints and their fields aswell as any other indexes and their fields. Should be quite useful for […]
2002-04-08
3,027 reads
By Gail Shaw
It’s a few days into April, but not too late I hope to mention...
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is...
Sometimes in life you have to do things you really don’t like to do....
Hi everyone. I have a process that is taking a long time to execute...
Daily Coping Tip: Rediscover your favourite music that really lifts your spirits. My thoughts:...
I am proposing to the business that we use SQL 2019 Developer in our...
Ask SSC