Undocumented sp_MSforeachtable stored procedure

by dotnetpete 29. April 2009 12:31

Found a very cool undocumented stored procedure in SQL today.

For example if I want to rebuild all indexes for all tables I could do

sp_MSforeachtable @command1="print '?' DBCC DBREINDEX ('?')"

Very handy!

66161bf7-28e3-4447-80bb-ec7eb6abbc7b|0|.0

Tags:

LINQPad a great tool for learning and trying out LINQ (to SQL) LINQ for us was a huge productivity improvement as we didn't have to generate stored procedure...SQL 2008 replication madnessI had to setup replication today over a relatively slow link. It was all going ok and I was viewing ...Innovative use of the SQL Server row_number() functionI came across an interesting use of the row_number function today. Say you have a situation where yo...

Comments

9/10/2009 2:43:25 AM #

As a Newbie, I am always searching online for articles that can help me. Thank you

Add comment

Name*
E-mail*
Website
b i u quote

Notify me when new comments are added