DECLARE database_cursor CURSOR
FOR SELECT name FROM master..sysdatabases
WHERE name NOT IN ('master', 'tempdb', 'model', 'msdb')
FOR READ only

OPEN database_cursor
	FETCH next FROM database_cursor INTO @dbname
	 WHILE @@FETCH_STATUS = 0
	 BEGIN
		
--checking fragmentation in each table
-- Declare cursor
DECLARE alltables CURSOR FOR
SELECT convert(varchar,so.id)
FROM + '''+ @dbname +''' + .. + sysobjects so
JOIN sysindexes si
ON so.id = si.id
WHERE so.type ='U'
AND si.indid < 2
AND si.rows > 0
OPEN alltables

-- Loop through all the tables in the database running dbcc showcontig on each one
FETCH NEXT
FROM alltables
INTO @tableidchar

quote:

---

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. Use sys.dm_db_index_physical_stats instead.

---