Technical Article

Stored Procedure Call Hierarchy

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 […]

5 (5)

You rated this post out of 5. Change rating

2005-03-14 (first published: )

3,893 reads

Technical Article

Database structure queries

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 […]

5 (2)

You rated this post out of 5. Change rating

2002-04-08

3,036 reads

Blogs

Using T-SQL Snapshot Backup - Are Snapshots Backups?

By

Introduction Traditional SQL Server backups can struggle with large databases, resulting in longer backup...

Developer Q&A: Dika Fei of Jelly Pixel Studio

By

"Let me know where you get your magic pixie dust from!"

A New Word: Flashover

By

flashover – n. the moment a conversation becomes alive and real, when a spark...

Read the latest Blogs

Forums

GIT Configuration and Automated Release for Azure Data Factory

By Sucharita Das

Comments posted to this topic are about the item GIT Configuration and Automated Release...

It's Time to Play

By Ryan Booz

Comments posted to this topic are about the item It's Time to Play

Call Dates Effective Range

By Yash34

Hi Everyone, I have the data in the below form : Desired output: Here...

Visit the forum

Question of the Day

Synapse Analytics History III

What was the originally name of the appliance that eventually became Azure Synapse Analyics?

See possible answers