InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 23:59:02 GMT20http://www.sqlservercentral.com/Forums/Topic1404717-146-1.aspxExcelent!I was working in this for hours... and I can't resolve the problem... :hehe:thanks a lot!Wed, 09 Jan 2013 08:34:03 GMTSeed Vicioushttp://www.sqlservercentral.com/Forums/Topic1404717-146-1.aspxnice effort!just as a more streamlined form, you don't need a cursor to generate the same results:you can do it as a single set based operation instead:[code]SELECT object_schema_name(OBJECT_ID) as SchemaName,object_name(OBJECT_ID) as Objeto, STATS_DATE(OBJECT_ID,STATS_ID) StatDate,* FROM SYS.STATS WHERE OBJECT_ID IN(SELECT object_id from sys.tables)order by object_schema_name(OBJECT_ID), object_name(OBJECT_ID), stats_id[/code]Wed, 09 Jan 2013 07:17:37 GMTLowellhttp://www.sqlservercentral.com/Forums/Topic1404717-146-1.aspxEnjoy! :-D[code="sql"]Set nocount onDECLARE crComando CURSOR READ_ONLY FOR select name from sys.objects where type = 'u' order by nameDECLARE @name varchar(400)OPEN crComandoFETCH NEXT FROM crComando INTO @nameWHILE (@@fetch_status <> -1)BEGIN IF (@@fetch_status <> -2) BEGIN DECLARE @message varchar(8000) SELECT @message = 'SELECT '''+@name +''' as Objeto, STATS_DATE(OBJECT_ID,STATS_ID) StatDate,* FROM SYS.STATS WHERE OBJECT_ID = OBJECT_ID('''+@name +''')' --PRINT @message Exec(@message) END FETCH NEXT FROM crComando INTO @nameENDCLOSE crComandoDEALLOCATE crComando[/code]Wed, 09 Jan 2013 05:51:54 GMTSeed Vicious