Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 208
  • Last Modified:

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

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
TCIG
Asked:
TCIG
  • 2
1 Solution
 
lcohanDatabase AnalystCommented:
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
 
lcohanDatabase AnalystCommented:
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
 
TCIGAuthor Commented:
Exactly what I needed
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now