Viewing 3 posts - 1 through 3 (of 3 total)
Yes, thanks good catch!
August 12, 2011 at 8:02 am
#1367939
So I added a bit to it and made it so it will run aginst every database on the server. Hope this helps someone.
CREATE TABLE #LastAccess (DatabaseNamesysname,
TableNamesysname,
LastSelectdatetime)
DECLARE...
November 5, 2010 at 7:06 am
#1247097
We actually wrote a function that does what si.chan does. We use it a lot to address this issue.
August 1, 2003 at 5:23 am
#468174