Queries to Search the FeneVision Databases

Find tables in the FeneVision databases:

SELECT t.name AS TableName, c.name AS ColumnName 
FROM sys.tables t 
JOIN sys.columns c 
ON c.object_id = t.object_id
WHERE c.name LIKE '%price%'

Find columns in the FeneVision database tables:

SELECT t.name AS TableName, c.name AS ColumnName 
FROM sys.tables t 
JOIN sys.columns c 
ON c.object_id = t.object_id
WHERE t.name LIKE '%price%'

Find Stored Procedures:

SELECT OBJECT_NAME(object_id)
FROM sys.sql_modules
WHERE OBJECTPROPERTY(object_id, 'IsProcedure') = 1
    AND definition LIKE '%HistoricalReceivedItems%'
ORDER BY OBJECT_NAME(object_id)

Find text within a stored procedure:

SELECT name
FROM   sys.procedures
WHERE  Object_definition(object_id) LIKE '%strHelp%'

Find a temporary table inside a stored procedure:

SELECT DISTINCT
      o.name AS Object_Name,
      o.type_desc
 FROM sys.sql_modules m
      INNER JOIN
      sys.objects o
        ON m.object_id = o.object_id
WHERE m.definition Like '%DiscountTableID%'