Francisco Tapia
fhtapia at gmail.com
Fri Aug 29 16:16:54 CDT 2008
Here is another site w/ the same information: http://www.databasejournal.com/features/mssql/article.php/3441031 GoogleSearch: http://www.google.com/search?q=undocumented+procedure+sql+for+each+table -Francisco http://sqlthis.blogspot.com | Tsql and More... On Wed, Aug 27, 2008 at 2:57 PM, Stuart McLachlan <stuart at lexacorp.com.pg>wrote: > Gee thanks :-( > > That's a big site - a URL would be useful. > > <g> > > Cheers, > Stuart > > On 27 Aug 2008 at 11:07, Arthur Fuller wrote: > > > I found it at last. It's on TechRepublic. > > > > On Wed, Aug 27, 2008 at 9:56 AM, Arthur Fuller <fuller.artful at gmail.com > >wrote: > > > > > I was positive that at some point I had encountered a sproc that would > > > let me do things like this (pseudo-code): > > > > > > exec sp_foreach @objectType = 'Table', @command = 'UPDATE STATISTICS ?' > > > > > > > > _______________________________________________ > > dba-SQLServer mailing list > > dba-SQLServer at databaseadvisors.com > > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > > http://www.databaseadvisors.com > > > > -- > Stuart Mclachlan > > > _______________________________________________ > dba-SQLServer mailing list > dba-SQLServer at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > http://www.databaseadvisors.com > >