April 2007 - Posts

• Problems when removing a filegroup

  This week we ran into a weird problem. We were not able to remove an empty filegroup, SQL Server was throwing the 5042 error “The filegroup 'FG18' cannot be removed because it is not empty”. There were definitely no files in that filegroup so the whole Read More... Posted Thursday, April 26, 2007 5:19 PM by roman | 2 Comments

• Change in trace flags behavior in SQL Server 2005

  The other day I was setting up trace flags when chasing a deadlock issue. The way it works is that after you run DBCC TRACEON, SQL Server outputs detailed log to the SQL Server event log. But for some reason this trace was just not showing. The only thing Read More... Posted Tuesday, April 24, 2007 3:03 PM by roman | 2 Comments