Need to find list of tables used in stored procedure with “nolock”? [duplicate]

by

try this one :-

Declare  @stObjToFind       Varchar(150)

Select   @stObjToFind = 'With (Nolock)'

Select   so.id
        ,so.name
        ,so.xtype
From    sysobjects As so With (Nolock)
        Join
        (
            Select  Distinct sc.id
            From    syscomments As sc With (Nolock)
            Where   sc.text Like '%' + @stObjToFind + '%'
        ) As sc0 On so.id = sc0.id
Where   so.name <> @stObjToFind

More Related Contents:

  1. Find and Replace Column value from Over all Database
  2. how to create this table in sql server?
  3. Add a column with a default value to an existing table in SQL Server
  4. What is the best way to paginate results in SQL Server
  5. How can I convert bigint (UNIX timestamp) to datetime in SQL Server?
  6. Multi-statement Table Valued Function vs Inline Table Valued Function
  7. SQL Server Insert if not exists
  8. How do you return the column names of a table?
  9. How to set table name in dynamic SQL query?
  10. How to capitalize the first letter of each word in a string in SQL Server
  11. INT vs Unique-Identifier for ID field in database
  12. SQL Server date format function
  13. SQL: Select dynamic column name based on variable
  14. Composite Primary key vs additional “ID” column?
  15. The SQL OVER() clause – when and why is it useful?
  16. Saving changes after table edit in SQL Server Management Studio
  17. Eliminating duplicate values based on only one column of the table
  18. Logging ALL Queries on a SQL Server 2008 Express Database?
  19. SQL query to find Nth highest salary from a salary table
  20. Cannot use a CONTAINS or FREETEXT predicate on table or indexed view because it is not full-text indexed
  21. How to get export output in “real” CSV format in SQL Server Management Studio?
  22. Merge overlapping date intervals
  23. Script to save varbinary data to disk
  24. Access to Result sets from within Stored procedures Transact-SQL SQL Server
  25. SQL poor stored procedure execution plan performance – parameter sniffing
  26. How to find out what is locking my tables?
  27. SQL – How do I get only the numbers after the decimal?
  28. How to retrieve records for last 30 minutes in MS SQL?
  29. Connecting to Oracle Database using Sql Server Integration Services
  30. Why do SQL Server Scalar-valued functions get slower?

Leave a Comment