Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DDL changes history

Status
Not open for further replies.
fafrazh99

fafrazh99

MIS
Sep 7, 2002
23
US
Does SQL 2000 save the DDL changes history in somewhere? Actually the last modifed date will help also.

Thanks in advance.

Frank
 
Sort by date Sort by votes
When DDL statement is executed, will SQL Server record them in the log? Then, the next question will be how to poke into the log file.

Thanks,

Frank
 
Upvote 0 Downvote
To view the log, you would need a 3rd party tool like Log Explorer by Lumigent Technologies. There is no tool w/in SQL Server to view TLogs.

Thanks

J. Kusch
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

tekpr00
  • Locked
  • Question
Capture and Replicate Changes from Source to Target.
Replies
0
Views
98
tekpr00
tekpr00
Skittle
  • Locked
  • Question
Identifying Database Access Changes
Replies
1
Views
70
djj55
djj55
CajunCenturion
  • Locked
  • Question
OpenRowSet returns same results even if source table changes
Replies
2
Views
79
CajunCenturion
CajunCenturion
pandatime
  • Locked
  • Question
Can only sysadmin check job history? 1
Replies
2
Views
43
pandatime
pandatime
northrd
  • Locked
  • Question
ddl trigger on database for connect 1
Replies
6
Views
81
SQLWilts
SQLWilts

Part and Inventory Search

Sponsor

Back
Top