Technical Article

Get the Foreign Key Hierarchy 2

This procedure is just another approach for getting a list of tables defined in a database, ordered by dependency on other tables based on foreign key relationship.I used it for a deployment process, where the TABLE create scripts must be executed in the correct order,because the foreign key constraints are specified in the create script […]

4.5 (2)

2003-04-18

342 reads

Blogs

InvalidAbfsRestOperationException in Azure Synapse notebook

By

Problem The first issue that developers in my team noticed was when they tried...

What do we want to achieve by encrypting our data?

By

On the face of it, this is a very obvious question with a very...

Daily Coping 5 Dec 2022

By

Today’s coping tip is to look for new reasons to be hopeful, even in...

Read the latest Blogs

Forums

Thuốc điều hòa sinh trưởng (kích thích rễ) và thuốc dưỡng rễ hay phục vụ mai vàn

By tt140411

Thuốc điều hòa sinh trưởng (kích thích rễ) và thuốc dưỡng rễ hay phục...

Multitenant architecture

By mto89

Hi all, i have to refactor an existing database multi-tenant. All tables should be...

log shipping restore from primary server backup directory

By sqlfriend

To understand the concept of transaction log shipping, in below case, will it work:...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers