If we need to know when the SQL objects is modified then we can use the below query to find the objects details.
SELECT name, create_date, modify_date
FROM sys.objects
WHERE type = 'P'-- give the type as required
Loading
Written byKhan Abrar Ahmed
View profileHI, I hold Bachelors of Electronics Engineering from University of Pune. I am Microsoft certified, achieved MCTS certification in client web application development on top of .Net Framework 2.0 and SQL Server.
26 pieces published on C# Corner
Join the conversation! Your thoughts help the community grow.