Mês: novembro 2024

SELECT  s.[name] AS [schema],        t.[name] AS [table_name],        p.[rows] AS [row_count],        CAST(ROUND(((SUM(a.total_pages) * 8) / 1024.00), 2) AS NUMERIC(36, 2)) AS [size_mb],        CAST(ROUND(((SUM(a.used_pages) * 8) / 1024.00), 2) AS NUMERIC(36, 2)) AS [used_mb],        CAST(ROUND(((SUM(a.total_pages) – SUM(a.used_pages)) * 8) / 1024.00, 2) AS NUMERIC(36,...

ALTER DATABASE xxxxx SET EMERGENCY;GO ALTER DATABASE xxxxx set single_userGO DBCC CHECKDB (xxxxx , REPAIR_ALLOW_DATA_LOSS) WITH ALL_ERRORMSGS;GO ALTER DATABASE xxxxx set multi_userGO...