?
Solved

SQL Server 2008 R2 - How to track down manual interactions

Posted on 2014-04-17
6
Medium Priority
?
336 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
6 Comments
 
LVL 13

Accepted Solution

by:
Koen Van Wielink earned 1000 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
Linux Academy Android App Now Supports Chromecast

We have some fantastic news for our Android fans. We’re so excited to announce that the Linux Academy Android app is now available with Chromecast support. That’s right – simply download the latest update of the Linux Academy App and start casting your favorite course videos!

 

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

Want to be a Web Developer? Get Certified Today!

Enroll in the Certified Web Development Professional course package to learn HTML, Javascript, and PHP. Build a solid foundation to work toward your dream job!

Question has a verified solution.

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

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

764 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