Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jimmy_a
Starting Member
38 Posts |
 Posted - 2006-02-10 : 03:43:04
|
| V can use SP_DEPENDS to find the dependency sps..Is there any other way to find dependency sps using queries..Can any one help me in this ...Thnks in advance |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-02-10 : 03:51:53
|
| i assume you need a certain format or filter the resultstry to check the tsql behind sp_depends, lately, i've been modifying sp_'s to suit a particular need (not updating them ofcourse)use sp_helptext to show you the tsql--------------------keeping it simple... |
 |
|
|
jimmy_a
Starting Member
38 Posts |
Posted - 2006-02-10 : 04:11:25
|
| THSI IS THE QUERY ...SELECT DISTINCT O.NAME FROM MASTER.DBO.SYSOBJECTS O,MASTER.DBO.SYSDEPENDS D,MASTER.DBO.SYSUSERS S WHERE O.ID = D.ID AND O.XTYPE = 'P' AND D.DEPID = (SELECT OBJECT_ID( 'SPC_AEPDtl_Sp_VwDtPSPrSeMl' )) AND O.UID = S.UID AND DEPTYPE < 2If i use that query i can only able to access in master DB.. But i couldnt access from diff DB |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-02-10 : 06:08:31
|
| Duplciate post: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=61534 |
|
|
|
|
|
|
how to find dependency sps in sql