This will help:

http://msdn.microsoft.com/en-us/library/ms173804.aspx

You can use this query to check the statistics date when it was last updated.

select object_name (i.id)as objectname,i.name as indexname,i.origfillfactor,i.rowcnt,i.rowmodctr ,STATS_DATE(i.id, i.indid) as ix_Statistics_Date,o.instrig,o.updtrig,o.deltrig,o.seltrig

from sysindexes i INNER JOIN dbo.sysobjects o...

Jeff,

This is awesome. You are a Genius.:-)

Thank you Bru.. I'll give it a go.

Thank you guys for the information.

In sp_autostats again i have to specify table name to get the information. There are 100's of tables, so i'll have to run it individually...

Through the parameters in the lookup from the reprts..

Hi lynn

Yes that will work,, but i will have to change all the Standard reports with : set dateformat ymd

There's 100's of reports..

Is there a setting somewhere which is incorrect??

Yes, it works with the amended query.

But why do i have to use convert for the collation latin1_general_cp1_ci_as and not with SQl1_latin1_general_cp1_ci_as?

No it didn't work. I get the same error message.

The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.

I am sorry i didn't explain it properly. What i meant was the query works fine when running it against the UK customer who have the collation as sql_latin1_general_cp1_ci_as, but...

as mentioned above it's not very clear what you are trying to achieve. This may help:

http://www.sqlservercentral.com/Forums/Topic825668-338-1.aspx#bm826044

Grant Connect Grants the user permissions to connect to SQL Server. Do the users belong to a group and the group has got Connect permissions.

I am thinking of buying practice exams; Which one is better:

http://www.measureup.com/catalog/product.aspx?vid=5&cid=All MS Practice Tests&tid=94&pid=2423

or Transcender in the link above from David.

Have you tried it by changing the security level of the Package to:

Protectionlevel = Don'tSaveSensitive

Some thing like this will work:

EXECUTE master.sys.sp_MSforeachdb 'use ?; select ''?'' dbname, name from sys.tables where name like ''%X%'''

Replace 'X' with your tablename. If you just want the whole list...