Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 205
  • 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

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

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