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 Mike Lewis 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,208
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
202
dgillz
dgillz
bethabernathy
  • Locked
  • Question
Front End Access 365 Database dsn Connection Fails when attempting to link to 2016 SQL server
Replies
1
Views
208
dhookom
dhookom
torquinian
  • Locked
  • Question
Error 0x80131904 when trying to connect to database
Replies
0
Views
184
torquinian
torquinian
tnguyen315
  • Locked
  • Question
When was my SQL Server Databases last accessed/used?
Replies
1
Views
85
TheBugSlayer
TheBugSlayer
TheBugSlayer
  • Locked
  • Question
How do I tell if a table structure was changed?
Replies
2
Views
51
TheBugSlayer
TheBugSlayer

Part and Inventory Search

Sponsor

Back
Top