Check des letzten update statistics Durchlaufes

Juni 26, 2009
SELECT object_name(s.id) tablename,
c.name column_name,
convert(int,c4)actual_steps,
convert(int,c5)requested_steps,
moddate last_updated
FROM sysstatistics s,syscolumns c
WHERE formatid=100
-- AND s.id = object_id("TABLE_NAME")
AND s.id=c.id
AND s.id >100
AND s.c4 != NULL
AND s.c5 != NULL
ORDER BY 1,2

tags: ,
posted in ase by fm

Follow comments via the RSS Feed | Einen Kommentar hinterlassen | Trackback URL

Leave Your Comment

You must be logged in to post a comment.

 
Powered by Wordpress and MySQL. Theme by Shlomi Noach, openark.org