Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Jay99
468 Posts |
 Posted - 2001-04-17 : 15:58:21
|
| I was just trying to figure out how to write a stored procedure to run DBCC dbreindex for each of the tables in my database so that I could schedule a job to do this each night. I was trying to figure out how to write the proc without a CURSOR, and then . . .I found http://www.umachandar.com/technical/SQL6x70Scripts/UtilitySPs/Main7.htmThank you umachandar . . .who ever you areJay |
|
|
|
|
|
sp_MSforeachtable . . .