MS-Sql2000-Date VIEW 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. 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 on 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.

Thnx so much.

 

[Catadmin]

Check the sysobjects table to see if there is an UpdateDate field for the view in question.



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"