When was the object last updated? - SQL Server Forums

Home | Weblogs | Forums

Site Sponsored By: SQLDSC - SQL Server Desired State Configuration

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

When was the object last updated?

Author

Topic

nitin1353
Constraint Violating Yak Guru

381 Posts

Posted - 2006-10-11 : 08:27:06

Gurus
Is there anyway from where i can fifure out when was the last updation made on this object.
Like for ex i have a SP,by nay way can i check when was that last updated?
Regards
Nitin

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2006-10-11 : 08:49:07

Nope!!

Unless you have some kind of version control softwaree (like MS Visual SourceSafe) installed on your machine. You should keep scripts for all database object inside VSS and make changes to the script for this strategy to work.

No direct way.

Harsh Athalye
India.
"Nothing is Impossible"

chiragkhabaria
Master Smack Fu Yak Hacker

1907 Posts

Posted - 2006-10-11 : 08:50:17

Check out this code, by Peter, he poseted this one of the threads i am not able to find that.


SELECT		so.name ObjectName,
		so.type ObjectType,
		max(convert(datetime, l.[Begin Time])) LogTime
FROM		::fn_dblog (DEFAULT, DEFAULT) l
Inner join	sysobjects so on so.name = l.[transaction name]
--where		so.type = 'u'
group by	so.name,
		so.type
order by	so.name,
		so.type

Chirag

http://chirikworld.blogspot.com/

X002548
Not Just a Number

15586 Posts

Posted - 2006-10-11 : 10:06:08

Well then do a drop and create

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources