Dependencies

Dependencies and References in SQL Server

  • Article

It is important for developers and DBAs to be able to determine the interdependencies of any database object. Perhaps you need to work out what process is accessing that view you want to alter, or maybe find out whether that table-type you wish to change is being used. What are all these dependencies? How do you work out which are relevant? Phil Factor explains.

2015-10-23

3,238 reads

Identifying Object Dependencies in SQL Server

  • Article

Is there a way to identify which objects are dependent on other objects within a SQL Server database? I need to modify the table structure to add new columns. However, before making any changes I want to make sure that I understand all the object dependencies. Is there a way in SQL Server 2008 to quickly identify all the object dependencies?

2009-06-26

3,798 reads

Blogs

Replicate permissions to new Login/User with dbatools

By

Continuing to share tips and tricks using dbatools like the Refresh databases that belongs...

SQL Server Sample Databases

By

[MSSQLFUN & Decode ITeS becomes a family of 1500 individuals across the globe. Please...

Using WAITFOR to Test Slow Code–#SQLNewBlogger

By

Another post for me that is simple and hopefully serves as an example for...

Read the latest Blogs

Forums

The Challenges of Working Under Quarantine

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Challenges of Working Under...

Upgrade SQL 2008R2 Cluster to SQL 2017

By AdamJSawyer

Hi, I've been asked to develop an implementation plan for upgrading a SQL 2008R2...

The Basics of Using a Sequence as a Table Default

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Basics of Using a...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers