Solved

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

Posted on 2011-03-10
3
202 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 40

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 40

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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will describe one method to parse a delimited string into a table of data.   Why would I do that you ask?  Let's say that you need to pass multiple parameters into a stored procedure to search for.  For our sake, we'll say that we wa…
Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

615 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