Enterprise manager: CreateDate

[michelleqw]

Dear sqlserver users,,

The enterprise manager of sqlserver 2000 shows allways the creating date of databases, sp etc.
This date can be usefull but not every time. The date when, for example, a sp the last time is modified can be more important.

Can someone tell us how to get a kollom with the modified date?

Michelle.

 

[hmckillop]

I think if you check the INFORMATION_SCHEMA views the field is actually stored as a datetime and as such will include the time not just the date.


"I'm living so far beyond my income that we may almost be said to be living apart