Dot Net Trick
Easy trick for solving a problem in Dot Net, C#, ASP .Net
Pages
Home
Sunday, 17 February 2013
How can find out all modify Store Procedure in your database by query?
SELECT
name
,
modify_date
,*
FROM
sys
.
objects
WHERE
type
=
'P'
AND
DATEDIFF
(
D
,
modify_date
,
GETDATE
())
<
1
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment