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,580 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,028 reads
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
A project I’ve been meaning to work on for a while has been to...
This seems to be a common issue throughout my packages. Anywhere I try to...
I have a SQL 20XX database in an on-premise data center that has a...
Comments posted to this topic are about the item HA in General Purpose Managed...
Ask SSC