| Author |
Topic |
|
keda_re
Starting Member
5 Posts |
 Posted - 2005-07-26 : 02:56:48
|
| I'm new user here. I think, this forum will be helpful for me.Problem :I need to see update date of Tables, Stored Procedures and Views. Whenever, A existing Table or Stored Procedure or View updated, i want to see the update date. In Enterprise Manager, only shows created date. But i need Update date.Anybody here to help me out form this problem? Plz, i need help.Committed to you... |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2005-07-26 : 03:10:59
|
| Sorry - the create date is the only one you can get.In many cases tables are dropped and re-created behind the scenes when you alter them, so it wouldn't be any use in some cases anyway.Tim |
 |
|
|
keda_re
Starting Member
5 Posts |
Posted - 2005-07-26 : 03:15:57
|
| I just need Alter date of Existing Tables or Stored Procedures or Views.Committed to you... |
|
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2005-07-26 : 03:23:09
|
quote:
Originally posted by timmy
Sorry - the create date is the only one you can get.
|
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-07-26 : 03:39:09
|
| you need to do this manuallyMadhivananFailing to plan is Planning to fail |
|
|
|
keda_re
Starting Member
5 Posts |
Posted - 2005-07-26 : 04:00:56
|
quote:
Originally posted by madhivanan
you need to do this manuallyMadhivananFailing to plan is Planning to fail
But how Madhivanan? Can u tell me the details of the working procedure.Committed to you... |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-07-26 : 04:49:28
|
| I mean whenver you update you need to write those info in a text or Excel file or store it in other history tableMadhivananFailing to plan is Planning to fail |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2005-07-26 : 05:58:18
|
or simply drop and recreate the object every time instead of altering it...that way your create date is the last update date...or use some source control tool like Source Safe to keep versions in tact.Go with the flow & have fun! Else fight the flow  |
|
|
|
keda_re
Starting Member
5 Posts |
Posted - 2005-07-26 : 07:45:50
|
| If other user update in SQL server from another pc, then how can i trace the update time?Committed to you... |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2005-07-26 : 08:24:53
|
| you can't. sql server DOESN'T HAVE a last updated feature. Only create date.with source control you don't have those problems because source control keeps previous versions of an objectin it's history so you can trace all changes.Go with the flow & have fun! Else fight the flow |
|
|
|
eaglesql
Starting Member
2 Posts |
Posted - 2005-07-28 : 03:02:52
|
| Hi, You may write trigger to update the date in the table itself ( For that you have to keep one more column in a table or fresh table depend upon the requirement). But pls keep in mind that it will degrade the overall performance of the server since each transaction should write one more record.Eaglesql |
|
|
|
|
NEED HELP - SQL SERVER 2000