Sort database by creation date

Question

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

GSquared SSC Guru Points: 260824 More actions · Answer 1

Have you tried using the "sys.all_objects" view?

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

SkyBVI SSCoach Points: 15128 More actions · Answer 2

@ gsquared

Thanks.. that worked for all the objects in a database..

How can I know about hte creation dates of all the jobs/maintenance plans on a sql server.

Regards,

Sushant

Regards
Sushant Kumar
MCTS,MCP

GSquared SSC Guru Points: 260824 More actions · Answer 3

Those are stored in system tables in msdb.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

SkyBVI SSCoach Points: 15128 More actions · Answer 4

@ GSquared

Thanks a lot.

Regards,

Sushant

Regards
Sushant Kumar
MCTS,MCP

GSquared SSC Guru Points: 260824 More actions · Answer 5

You're welcome.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon