.Net Programming in Simple

Sunday, 12 January 2014

Get the Procedure name in which particular table is used

SELECT DISTINCT so.name FROM syscomments sc INNER JOIN sysobjects so on sc.id=so.id WHERE sc.text LIKE '%BatchMaster%'
Posted by mohanty at 21:10
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: SqlServer

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Blog Archive

  • ►  2016 (1)
    • ►  September (1)
  • ▼  2014 (15)
    • ►  August (3)
    • ►  July (2)
    • ►  June (2)
    • ►  May (1)
    • ►  February (1)
    • ▼  January (6)
      • Retrieve Salary With Range in sql
      • Get the records separated by comma in sqlserver
      • Paging in sqlserver
      • Get the Procedure name in which particular table i...
      • Export Radgrid to Excel in .Net
      • Upload Multiple File at a Time in Asp.Net
  • ►  2013 (140)
    • ►  December (14)
    • ►  November (4)
    • ►  October (11)
    • ►  September (13)
    • ►  August (19)
    • ►  July (29)
    • ►  June (50)

About Me

mohanty
View my complete profile
Simple theme. Powered by Blogger.