Solved

SQL Server 2008 R2 - How to track down manual interactions

Posted on 2014-04-17
6
305 Views
Last Modified: 2014-04-17
Hi and Thanks,

I am very new to all this...

I have been assigned to analize a purge project that is working and recreate it in another Database.

I am to basically copy from one database were it is working into another database.

There are Stored Procedures, Views, Tables.

I go into a Stored Procedure and can see all the parameters that are coming into the SP.

But I do not know were they are coming from or how to track them down.

I have tried a Query SQL:
SELECT *
FROM sys.procedures
WHERE OBJECT_DEFINITION(OBJECT_ID) LIKE '%@FILE_ID%'
Order by name

@File_Id is one of the parameters

but as you can see this SQL only shows SP's

This is done all within SQL Server 2008 R2

I am trying to find were it would be that the user enters in all the necessary parameters???

Please Help...
0
Comment
Question by:Amour22015
  • 5
6 Comments
 
LVL 12

Accepted Solution

by:
Koen Van Wielink earned 250 total points
Comment Utility
This might be a very basic question, but how is the purge activated? Is it a user doing it? If so, how? Through another software? Or is it perhaps a scheduled job which executes periodically?
0
 

Author Comment

by:Amour22015
Comment Utility
the fact that a co-worker that has some history of the project says it runs manually tells me that it has to have a user doing it.

looks like the co-worker does not want to give me all the details about this purge project.

When I first received this task, the co-worker apparently lead me on a wild goose chase involving SSIS packages.  Because when I mentioned SSIS packages being involved with my supervisor, the supervisor's response was "as far as I know SSIS is not involved with this project".

I am just wondering if there is a way to find out were the project starts???  maybe some way of back tracking from the SP's???

thanks
0
 

Author Comment

by:Amour22015
Comment Utility
Ok,

When I do this SQL Query:
SELECT *
FROM [PROCLAIM].sys.objects
WHERE OBJECT_DEFINITION(OBJECT_ID) LIKE '%@FILE_ID%'
Order by name

I get this:
DF_INFLIGHT_CED_TERM_INSRT_TS      1396200024      NULL      1      1380199967      D       DEFAULT_CONSTRAINT
INFLIGHT_CED_TERM      1380199967      NULL      1      0      U       USER_TABLE
PK_CLAIM_KEY      1378103950      NULL      1      1362103893      PK      PRIMARY_KEY_CONSTRAINT
usp_JOBSTREAM_INFORMATION_I      1412200081      NULL      1      0      P       SQL_STORED_PROCEDURE

@FILE_ID = One of the parm within a SP

Thanks
0
Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

 

Author Comment

by:Amour22015
Comment Utility
This is a better copy of the out come of the Query:
Name                                                             Type
DF_INFLIGHT_CED_TERM_INSRT_TS      DEFAULT_CONSTRAINT
INFLIGHT_CED_TERM                       USER_TABLE
PK_CLAIM_KEY                                         PRIMARY_KEY_CONSTRAINT
usp_JOBSTREAM_INFORMATION_I      SQL_STORED_PROCEDURE

thanks
0
 

Author Comment

by:Amour22015
Comment Utility
I just took the bold approach and asked the co-worker:

This might be a very basic question, but how is the purge activated? Is it a user doing it? If so, how? Through another software? Or is it perhaps a scheduled job which executes periodically?

I did not think I would get an answer and would be left hanging..


But it turns out the co-worker

did not know
said that it did not matter
cause it is all going to change.

It would have been nice if they mentioned that before at the start when I was assigned...

I want to think you for your help....
0
 

Author Closing Comment

by:Amour22015
Comment Utility
Thanks
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now