Find The Inserted Table in SP - SQL Server Forums

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.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Find The Inserted Table in SP

Author

Topic

CSK
Constraint Violating Yak Guru

489 Posts

Posted - 2006-07-19 : 06:07:03

Hi Gurus,

Is This Any Default Sp Avilable To findout The Table What are all The Procedures are Used to insert in the Stored procedures

Thanks
KK

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2006-07-19 : 06:10:05

quote:
Originally posted by CSK

Hi Gurus,

Is This Any Default Sp Avilable To findout The Table What are all The Procedures are Used to insert in the Stored procedures

Thanks
KK

I didn't understand what you mean ! Can you please reframe your question or post some expected output here?

Harsh Athalye
India.
"Nothing is Impossible"

CSK
Constraint Violating Yak Guru

489 Posts

Posted - 2006-07-19 : 06:26:21

Actualy I Need a procedure

to findout the table which are used (ie Only Inserting ) in Other procedures

Eg:
Table : Test

This table Was used The Following Proc as the Purpose of Inserting
Sp_test1
Sp_test2
Sp_test3

-- KK

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2006-07-19 : 06:40:10

quote:
Originally posted by CSK

Actualy I Need a procedure

to findout the table which are used (ie Only Inserting ) in Other procedures

Eg:
Table : Test

This table Was used The Following Proc as the Purpose of Inserting
Sp_test1
Sp_test2
Sp_test3

-- KK

Use Information_Schema.Routines view as follows:

Select routine_Name from Information_Schema.Routines where
Routine_Definition like '%Insert into Test%' or
Routine_Definition like '%Insert Test%'

Note that above only works for non-encrypted SPs.

Harsh Athalye
India.
"Nothing is Impossible"

CSK
Constraint Violating Yak Guru

489 Posts

Posted - 2006-07-19 : 06:58:39

quote:
Originally posted by harsh_athalye

quote:
Originally posted by CSK

Actualy I Need a procedure

to findout the table which are used (ie Only Inserting ) in Other procedures

Eg:
Table : Test

This table Was used The Following Proc as the Purpose of Inserting
Sp_test1
Sp_test2
Sp_test3

-- KK

Use Information_Schema.Routines view as follows:

Select routine_Name from Information_Schema.Routines where
Routine_Definition like '%Insert into Test%' or
Routine_Definition like '%Insert Test%'

Note that above only works for non-encrypted SPs.

Harsh Athalye
India.
"Nothing is Impossible"

Great It's Working

Thanks
KK

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources