Monthly Archives: March 2009

login failures for windows based authentication what does that error mean

Posted on March 31, 2009 by

Have you ever come across the following login failure within the SQL Server error logs? “Login failed for user ”. (Note the empty user name). This is all a bit unusual if you think about it. Since the user attempting … Continue reading →

Posted in security, sql

auto generating statements every dba should try one

Posted on March 19, 2009 by

Have you ever performed a scripted restore or some of similar operation and then got entirely frustrated at the laborious and error prone nature of this exercise especially when the database consists of many datafiles and transaction log files? Of … Continue reading →

Posted in automation, datafiles, sql

moving sql server data and log files dont detach

Posted on March 5, 2009 by

Recently I came across the ALTER FILE part of the ALTER DATABASE command and started thinking about its use when moving physical datafiles. I must admit that this particular part of the ALTER DATABASE command has largely gone unused. Whilst … Continue reading →

Posted in database, datafiles, filesystem, sql