Solved

How do I find the 'Modified Date' and 'Modified By' for a SQL Server 2005 Database?

Posted on 2011-03-10
3
193 Views
Last Modified: 2012-05-11
I have a SQL server 2005 database where the name was changed.  I need to determine when the name was changed and by whom.  I know how to find these values for Tables, but this is the database name that was changed.
0
Comment
Question by:TCIG
  • 2
3 Comments
 
LVL 39

Accepted Solution

by:
lcohan earned 500 total points
ID: 35099708
If you did not restarted server open your SSMS, right click server, select reports, select standard reports and check "Schema Change History" standard SQL 2005 report.
0
 
LVL 39

Expert Comment

by:lcohan
ID: 35099760
You could also add your DDL triggers at server level and DB level to log all these into your own user table - please see my solution at:

http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_26872151.html?cid=1131#a35074001
0
 

Author Closing Comment

by:TCIG
ID: 35100046
Exactly what I needed
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

757 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now