Some Useful Microsoft SQL commands
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 MoreTag: SQL
SQL Server Database Log Full
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
