About Me

My photo
MCTS FOR SQL SERVER 2008 DOT NET PROGRAMMING WEB DESIGNING

Monday, 3 October 2011

TO KNOW ABOUT DEPENDS

yesterday i got a mail from one of my follower. his questions is how to know the depends of particular object?

woooh.........its very simple-----

syntax is:-

sp_depends '<tablename>' | '<stored procedure> |

example:-

sp_depends 'test' --test is a table name

press f5

you will find the depends of test table in result box.........

see how simple it is.........

No comments:

Post a Comment