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 derfloh 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
Joined
Jan 31, 2001
Messages
4,212
Location
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 Question
SQL View not available to Excel Power Query
Replies
1
Views
770
dgillz
dgillz
bethabernathy
  • Locked
  • Question Question
Front End Access 365 Database dsn Connection Fails when attempting to link to 2016 SQL server
Replies
1
Views
744
dhookom
dhookom
torquinian
  • Locked
  • Question Question
Error 0x80131904 when trying to connect to database
Replies
0
Views
735
torquinian
torquinian
tnguyen315
  • Locked
  • Question Question
When was my SQL Server Databases last accessed/used?
Replies
1
Views
339
TheBugSlayer
TheBugSlayer
TheBugSlayer
  • Locked
  • Question Question
How do I tell if a table structure was changed?
Replies
2
Views
261
TheBugSlayer
TheBugSlayer

Part and Inventory Search

Sponsor

Back
Top