Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

When was view object created / modified? 1

Status
Not open for further replies.
lameid

lameid

Programmer
Jan 31, 2001
4,207
0
0
US
This may simply not be possible but I am hoping there is an answer.

Is there a way to see the created and modified dates for objects, specifically views in SQL 2008?

 
Sort by date Sort by votes
use <DBNAME>
GO
SELECT [name]
,create_date
,modify_date FROM
sys.views
 
Upvote 0 Downvote
The news is the view didn't change. Not sure if that is good or bad news yet...

Thank you very much. This saves me some hassle in my digging.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

dgillz
  • Locked
  • Question
SQL View not available to Excel Power Query
Replies
1
Views
75
dgillz
dgillz
bethabernathy
  • Locked
  • Question
Front End Access 365 Database dsn Connection Fails when attempting to link to 2016 SQL server
Replies
1
Views
89
dhookom
dhookom
torquinian
  • Locked
  • Question
Error 0x80131904 when trying to connect to database
Replies
0
Views
68
torquinian
torquinian
tnguyen315
  • Locked
  • Question
When was my SQL Server Databases last accessed/used?
Replies
1
Views
43
TheBugSlayer
TheBugSlayer
TheBugSlayer
  • Locked
  • Question
How do I tell if a table structure was changed?
Replies
2
Views
24
TheBugSlayer
TheBugSlayer

Part and Inventory Search

Sponsor

Back
Top