Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
bbasir
Yak Posting Veteran
76 Posts |
 Posted - 2008-04-09 : 13:12:08
|
| I looked into the BOL, to get some info on the column refdate in the sysobjects table....the microsoft BOL, tells me this....refdate datetime Reserved for future use. What does this mean? reserved for future use?Is this the last accessed date or am I just guessing? |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2008-04-09 : 13:33:30
|
| >> Is this the last accessed date or am I just guessing?Just guessingIt means it's there but not used as yet (or they don't want to let you know what it contains). Could be that it's only used in certain cases or used for different purposes by different things - or maybe they had an idea that didn't work or decided to postpone some functionality until a future release.Isn't it the create date for the table same as crdate?==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
bbasir
Yak Posting Veteran
76 Posts |
Posted - 2008-04-09 : 13:58:25
|
| Thanks, I was hoping that it will tell me that when was the last time that table or sp etc etc was accessed. The data in at least my table seems that way....Any way, Is there any other way to know when an object was last accessed without using the sql profiler? |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-09 : 15:47:39
|
| Maybe this helps.Not sure thoughselect name,modify_date from sys.objectswhere type ='U'--'P'=SP |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-09 : 22:12:38
|
| Modify_date is for schema change, not for data modification. |
|
|
|
bbasir
Yak Posting Veteran
76 Posts |
Posted - 2008-04-10 : 12:56:05
|
| Yes, I was looking for data modification date? or if even some one selected on the table aka ... last access date if that exists? So far I have come to know that it is NOT possible to do in sql server 2000.... |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-10 : 22:24:21
|
| Neither in sql2k5. |
|
|
|
|
|
|
sysobjects question(refdate) column