SQL Server 2008 R2 - How to track down manual interactions
Posted on 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:
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???