ASK DOT NET
asp.net c# sql 2008
Search This Blog
Monday, February 11, 2013
How can find out all modify Store Procedure in your database by query?
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