Solved

SQL Server 2008 R2 - How to track down manual interactions

Posted on 2014-04-17
6
309 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
ID: 40006550
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
ID: 40006606
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
ID: 40006661
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
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 

Author Comment

by:Amour22015
ID: 40006671
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
ID: 40006875
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
ID: 40006876
Thanks
0

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Exception Handling is in the core of any application that is able to dignify its name. In this article, I'll guide you through the process of writing a DRY (Don't Repeat Yourself) Exception Handling mechanism, using Aspect Oriented Programming.
This article aims to explain the working of CircularLogArchiver. This tool was designed to solve the buildup of log file in cases where systems do not support circular logging or where circular logging is not enabled
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
Hi friends,  in this video  I'll show you how new windows 10 user can learn the using of windows 10. Thank you.

910 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

24 Experts available now in Live!

Get 1:1 Help Now