Archives of the TeradataForum

Message Posted: Fri, 29 Oct 2004 @ 09:04:58 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Fred Pluebell wrote:

Thanks for that, Fred. Based on your comment, the following SQL appears to bring back Stored Procedures compiled in Ansi Mode:

     SELECT T2.DatabaseName,T1.TVMName as ProcedureName, T1.LastAlterTimeStamp
     FROM  DBC.TVM T1
     INNER JOIN dbc.Databases2 T2
     ON T2.DatabaseId = T1.DatabaseId
     INNER JOIN dbc.Databases T3
     ON T3.DatabaseName = T2.DatabaseName
     WHERE T1.TABLEKIND = 'P'
      AND SPObjectCodeRows  <> 30012100;

Dave Clough
Database Designer
Database Design Group

	<Prev	Next>		<<First	<Prev	Next>	Last>>