MS-Sql2000=Date VIEW was last edited

[markajem]

MS-Sql 2000

I was working on a project about 1 month ago that involed a crystal report using several VIEWs. My problem is that I was working with 3 different databases on 3 different servers. One, our live system and two other test systems. Stupid me can't remember on what database I made my last edit of the VIEWs (which one holds the most recent changes I made) I was working with. I was creating different scenarios in each of the databases and altering the VIEWs. My problem is that I dont remember which of the databases contain the most up to date VIEWs. I have tried viewing properties but it does not tell me the last time that VIEW was edited. Any ideas as to how I may find this out.

I tried thru EManager but it just gives the date that the VIEW was created not last edited.

Thnx so much.

 

[SQLSister]

That info is not saved. If you drop and recreate views when you change them it willhavea new create data though.

Questions about posting. See faq183-874
Click here to help with Hurricane Relief

 

[mrdenny]

I would recommend getting VSS or CVS or one of the other big source control systems. They all have a version history to prevent issues like this.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com