Monday, February 22, 2010

Using the sp_MSforeachdb and sp_MSforeachtable stored procedures (SPs), you can simplify the code you need to process through all databases and/or all

Exec sp_MSforeachdb 'Select ''[?]'',* From ?..sysobjects where name like ''form%'''

1 comment: