At work, one of the logs was taking up too much space as the transaction mode was set to full and we deleted the log and had difficulty reattaching the database. There is a gem of a command that allows you to do that. exec sp_attach_single_file_db @dbname
Read More...
I been struggling with a weird error with sql server enterprise manager. Every time I click on it, it crashes. On investigation, the log says SQL Server is terminating due to 'stop' request from Service Control Manager. I tried installing msde,
Read More...