what is sp_depends in Sql Server

Posted by Sksamantaray under Sql Server on 3/25/2012 | Points: 10 | Views : 2458 | Status : [Member] | Replies : 6
Can someone tell me what is sp_depends in SQl Server with examples?

Thanks,
Sanjay



Responses

Posted by: Skraghava on: 3/25/2012 [Member] Starter | Points: 25

Up
0
Down
It is one of the system stored procedure gives information about object dependencies. Example when used with a table name, lists out all the views and SP's which are using this table.

Thanks and regards,
Raghavendra SK

Sksamantaray, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Rajkatie on: 6/23/2012 [Member] [MVP] Gold | Points: 25

Up
0
Down
You can also refer following link
http://msdn.microsoft.com/en-us/library/ms189487.aspx

Rajesh Patel
.Net Trainer(MSCD | MCT | MS)
Brainbench (Asp.Net 4.5 and C# 5.0)

Sksamantaray, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: CGN007 on: 6/25/2012 [Member] Silver | Points: 25

Up
0
Down
sp_depends, displays information about database object dependencies.
http://sqlserverpedia.com/wiki/Sp_depends_System_Stored_Procedure

Sksamantaray, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: CGN007 on: 6/25/2012 [Member] Silver | Points: 25

Up
0
Down
Also refer this links
1.http://www.mssqltips.com/sqlservertip/1294/listing-sql-server-object-dependencies/


Sksamantaray, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: CGN007 on: 6/29/2012 [Member] Silver | Points: 25

Up
0
Down
Mark as Answer if its helpful to you,that motivates...

Sksamantaray, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response