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 |
|
schinni
Yak Posting Veteran
66 Posts |
 Posted - 2003-05-22 : 10:31:02
|
| Hello!Can i do a dbcc showcontig using sp_msforeactable something like this exec sp_msforeachtable "dbcc showcontig ? with fast "i am running this i am getting errorrsDid any body try this if so can you help meThanks |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2003-05-22 : 11:02:41
|
The "?" fully qualifies the name, which showcontig doesn't seem to like. You'll probably have to do a little sql-from-sql thing then cut & paste ...select 'dbcc showcontig (' + name + ') with fast'from sysobjectswhere xtype = 'u' Jay White{0} |
 |
|
|
|
|
|
dbcc showcontig