Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

stored procedure pro Expand / Collapse
Author
Message
Posted Monday, February 9, 2009 3:29 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, November 25, 2009 4:57 PM
Points: 74, Visits: 550
Hi Everybody,


In my database one big table 19000 rows is there

In this table have so many stored procedures is there

one stored procedure purpose is to inserting rows but that is not working good

how can i find which stored procedures is inserting

i dont have permissions to write new procedure also how can i find out which procedure that one.

Thanks
Post #652637
Posted Monday, February 9, 2009 4:47 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, April 9, 2009 12:50 AM
Points: 140, Visits: 42
if you have access to the application source code which is using this database, then you can debug the application and find out when the records are inserted.

You could also use profiler to see which stored procedures are being called in the application process.

It would be really great if you could throw some more light on your requirement.
:)
Post #652697
Posted Monday, February 9, 2009 2:20 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, July 22, 2014 4:12 PM
Points: 958, Visits: 1,031
SQL Profiler will capture exactly what is going on, and you can limit it down to just capturing what is happening with that table. It does take a little while to learn how to use it.

Without more details, I can't suggest much more.
Post #653231
Posted Tuesday, February 10, 2009 1:23 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, May 5, 2011 1:38 AM
Points: 1,636, Visits: 604
You could try this:

SELECT *
FROM sysobjects so
JOIN syscomments sc ON sc.[id]=so.[id]
WHERE so.type = 'P'
and sc.text like '%INSERT INTO yourtable%'

It isn't 100% reliable (you can miss some procedure because of split into two rows, or because dynamic SQL is used), but it could help you to locate the procedure.
Other than that, Profiler is the best way to go, because it will monitor anything... and there is always a possibility that some rows are not inserted by the procedure but in some other way - and that's probably what you need to know.



Post #653458
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse