SQL Database Allocation Error Solution

This Query is to solve Allocation errors in Databases. Whenever you see error messages that contains word "Page ID issue" "broken links"... etc in application, or dbcc checkdb query tells you that database has allocation errors, run following query. xxxxxxx in the query is to be replaced by the name of your problematic database.

DECLARE @Database VARCHAR(255) 

DECLARE @Table VARCHAR(255) 

DECLARE @cmd NVARCHAR(500) 

DECLARE @fillfactor INT

SET @fillfactor = 90

DECLARE DatabaseCursor CURSOR FOR 

SELECT name FROM master.dbo.sysdatabases 

WHERE name IN ('xxxxxxx') 

ORDER BY 1 

OPEN DatabaseCursor 

FETCH NEXT FROM DatabaseCursor INTO @Database 

WHILE @@FETCH_STATUS = 0 

BEGIN 

SET @cmd = 'DECLARE TableCursor CURSOR FOR SELECT ''['' + table_catalog + ''].['' + table_schema + ''].['' +

table_name + '']'' as tableName FROM [' + @Database + '].INFORMATION_SCHEMA.TABLES

WHERE table_type = ''BASE TABLE''' 

-- create table cursor 

EXEC (@cmd) 

OPEN TableCursor 

FETCH NEXT FROM TableCursor INTO @Table 

WHILE @@FETCH_STATUS = 0 

BEGIN 

IF (@@MICROSOFTVERSION / POWER(2, 24) >= 9)

BEGIN

-- SQL 2005 or higher command

SET @cmd = 'ALTER INDEX ALL ON ' + @Table + ' REBUILD WITH (FILLFACTOR = ' + CONVERT(VARCHAR(3),@fillfactor) + ')'

EXEC (@cmd)

END

ELSE

BEGIN

-- SQL 2000 command

DBCC DBREINDEX(@Table,' ',@fillfactor) 

END

FETCH NEXT FROM TableCursor INTO @Table 

END 

CLOSE TableCursor 

DEALLOCATE TableCursor 

FETCH NEXT FROM DatabaseCursor INTO @Database 

END 

CLOSE DatabaseCursor 

DEALLOCATE DatabaseCursor

Thanks to Rajesh C R