SQL server tutorials
Wednesday, 28 August 2013
How to find the Custom text in a stored procedures using SQL Server
SELECT
OBJECT_NAME
(
object_id
)
FROM
sys
.
sql_modules
WHERE
OBJECTPROPERTY
(
object_id
,
'IsProcedure'
)
=
1
AND
definition
LIKE
'%
yourText
%'
No comments:
Post a Comment
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment