N_Sri
asked on
Finding all Stored Procedures which use Table name and Column name of the same table
Hi,
Think that there is table ( Employee ) with Fields Name(Varchar), Active(Smallint),LastName(
So this table is being used in many Stored procedures. Now I wanted to find all Stored procedures which use table Employee and use Active(Smallint) in the Stored Procedure code...
Please help me to have such query to find the list of stored procedures.... I found some query by useing Text search... but it was not getting correct data.
litte urgent .. :(
Think that there is table ( Employee ) with Fields Name(Varchar), Active(Smallint),LastName(
So this table is being used in many Stored procedures. Now I wanted to find all Stored procedures which use table Employee and use Active(Smallint) in the Stored Procedure code...
Please help me to have such query to find the list of stored procedures.... I found some query by useing Text search... but it was not getting correct data.
litte urgent .. :(
Last Comment
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Microsoft SQL Server 2008
Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the Always On technologies and support for unstructured data types.
50K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
ASKER