Subversion Error Message on Windows 7/Windows 2008 Server

Some times when I am performing a Subversion task (update, commit, check out) I get an error message stating that files can’t be moved or deleted. A subsequent boot of my machine causes CHKDSK to run (this is what concerned me).

The error message looks like this:

Error: Can't move
Error: '[...]\.svntmpentries'
Error: to
Error: '[...]\.svnentries':
Error: The file or directory is corrupted and unreadable.

This is a known issue with Windows 7 and you can http://support.microsoft.com/kb/982927/en-us”>download a Hot Fix to fix it.

This issue is also addressed in Service Pack 1 for Windows 7 and Windows Server 2008.

Here is a good post on the issue: http://serverfault.com/questions/72561/64-bit-tortoisesvn-on-windows-7-says-file-or-directory-is-corrupted-and-unreadab

Template for SQL Server Stored Procedures

Talking with our in house DBA, it was mentioned that DROP/CREATE is a bad model to follow when updating stored procedures. However, this is the model used in the stored procedure template provided by Visual Studio 2005/2010. Here is a modified template that creates an empty stored procedure if it doesn’t exist and performs an ALTER on all subsequent calls.

IF NOT EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'Stored_Procedure_Name')
BEGIN
exec sp_executesql N'CREATE PROCEDURE [dbo].[Stored_Procedure_Name] AS select 1'
END
GO
ALTER Procedure Stored_Procedure_Name
(
  @parameter1 int = 5,
  @parameter2 datatype OUTPUT
)
AS
GO

GRANT EXEC ON Stored_Procedure_Name TO PUBLIC

GO