Find the create and modified date of Database Objects

Click to subscribe to this blog

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 175 other followers
Blog Readers
- 609,619 Readers
Grab this badge here!
Disclaimer

This is a personal blog. The opinions expressed here represent my own thoughts and not those of my employer. For accuracy and official reference refer to MSDN/ TechNet/ BOL. My employer do not endorse any tools, applications, books, or concepts mentioned on the blog. I have written my personal experience on this blog. Please don't direct implement or execute any query on production before have detailed study.
Database Support
- Notes (367)
  - Database (73)
  - DB Articles (34)
  - IIS (1)
  - Microsoft Technologies (1)
  - MySQL (11)
  - Networking (7)
  - Oracle (4)
  - OS and SQL (17)
  - PostGreSQL (2)
  - SQL Scripts (36)
  - SQL Server (270)
  - SQL Server 2008 (142)
  - SQL Server 2008 R2 (136)
  - SQL Server 2011 (Denali) (46)
  - Windows OS (4)
Top Rated
Follow Me

NetworkedBlogs
Blog:
SQLDBPOOL.COM
Topics:
Sql Server, Dba, Developer

Follow my blog

About Me

Jugal Shah is the author of this blog. He has eight plus years of experience as Database Administrator and Developer in the Microsoft SQL Server and MySQL.
Contact Me

Email
jugal.shah@sqldbpool.com
Chat
jshah.sqldbpool@gmail.com
Twitter
- Steps to install the PostgreSQL on windows wp.me/pdaJF-tN 2 days ago
- What is PostgreSQL? wp.me/pdaJF-tB 2 days ago
- Steps to change logged in account password on Remote Desktop Session Windows Server 2008/R2 box wp.me/pdaJF-ty 1 week ago
Follow @imjugal
SQLDBPool Facebook Page

Find the create and modified date of Database Objects

Posted by Jugal Shah on October 5, 2010

Query
SELECT name, create_date, modify_date FROM sys.objects


		
			18.520469
			73.856621
		
Share this:
Like this:
Like
Be the first to like this post.



						
				 		This entry was posted on October 5, 2010 at 2:14 pm						and is filed under SQL Server.
												You can follow any responses to this entry through the RSS 2.0 feed.

													You can leave a response, or trackback from your own site.



		
									
				Thanks for the comment, will get back to you soon... Jugal Shah Cancel reply
									
																										


												



	Enter your comment here...
	




	
		Fill in your details below or click an icon to log in:
		
			
				
					
				
			
			
				
					
				
			
			
				
					
				
			
			
				
					
				
			
		
	

	
		
			
				
			

				
				
					Email (required) (Address never made public)
					
				
				
					Name (required)
					
				
				
					Website
					
				 
			
	
		
	

	
		
			
				
			

				
				
				
				
				 You are commenting using your WordPress.com account. ( Log Out / Change )
			
	
		
	

	
		
			
				
			

				
				
				
				
				 You are commenting using your Twitter account. ( Log Out / Change )
			
	
		
	

	
		
			
				
			

				
				
				
				
				 You are commenting using your Facebook account. ( Log Out / Change )
			
	
		
	


	
		Cancel
		Connecting to %s
	
	
	




 
	 Notify me of follow-up comments via email.
 Notify me of new posts via email.

												
							
							

						
						


					
							

			
			
			« Peer-to-peer transactional replication and conflict
			SQL Server Version and Code Name »

Click to subscribe to this blog

Blog Readers

Disclaimer

Database Support

Top Rated

Follow Me

About Me

Contact Me

Twitter

SQLDBPool Facebook Page

Find the create and modified date of Database Objects

Share this:

Like this:

Thanks for the comment, will get back to you soon... Jugal Shah Cancel reply

Follow “”