How does sp depends work

Active Oldest Votes. Improve this answer. Pritesh: then use sys. I blogged about the problems here: sqlblog. Heed gbn's advice and read my blog post. Show 7 more comments.

Russell Hankins Russell Hankins 1, 9 9 silver badges 17 17 bronze badges. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog. Podcast The first ten years of our programming lives. Upcoming Events. Is your SQL Server running slow and you want to speed it up without sharing server credentials?

In my Comprehensive Database Performance Health Check , we can work together remotely and resolve your biggest performance troublemakers in less than 4 hours. Once you learn my business secrets, you will fix the majority of problems in the future. SQL Tips and Tricks. Let us first create two scenarios. First GO Now let us run following three queries on both the scenarios. First', ISR. Leave new Pavan Nayakanti. Appreciate your help. Thanks for this resource material, it is really educating and self teaching.

How about If you want to determine column dependencies, that is: which column s are used to calculate another for instance: create view vwTest as select t1. Jorge L. Pinal, Under which conditions does your query fail to return any information? It can happen if you are missing schema prefix. Try prefixing schema example dbo. Does the Scenario 1 and 2 got interchanged? Customer table in the AdventureWorks database. Both the schema name and table name are specified. The following example lists the database objects on which the trigger iWorkOrder depends.

Feedback will be sent to Microsoft: By pressing the submit button, your feedback will be used to improve Microsoft products and services. Privacy policy. Skip to main content. This browser is no longer supported.