Some Useful Microsoft SQL commands by admin | Jul 30, 2020 | All, Microsoft | 0 | This command will rebuild the index on the database you select in the query window Exec sp_MSforeachtable “Print ‘?’ DBCC DBREINDEX (‘?’)” Go *Edit: the above command is depreciated. I found a... Read More
SQL Server Database Log Full by admin | Apr 15, 2020 | All, Windows | 0 | To fix this problem, change Recovery Model to Simple then Shrink Files Log 1. Database Properties > Options > Recovery Model > Simple 2. Database Tasks > Shrink > Files > Log Reference:... Read More