May 2006 Blog Posts
VSTS stuff

To delete a build type, get latest and then delete within Source Control Explorer.

To delete a Team Project, use the tfsdeleteproject command from a command prompt on the Build server.

To delete specific builds, use the tfsbuild delete command from a command prompt on the Build server.

posted @ Wednesday, May 24, 2006 10:19 PM | Feedback (0)
SQL Server 2000: SPID blocking itself

This is one of those “it's a feature, not a bug” things that was introduced in SP4:

Technically, this makes sense, but if you are used to using sp_who2 to check for harmful blocking, this is really rather annoying, as it can look like a process is blocking itself for an extended period of time while it is still doing useful work.

posted @ Tuesday, May 23, 2006 4:26 PM | Feedback (0)
SQL Server 2005: under the default settings SQL Server does not allow remote connections

If you receive this method when attempting to connect to SQL Server 2005, after establishing that the server is running, open up the SQL Server Configuration Manager (found under Configuration Tools in the SQL Server 2005 start menu group) and check to see which protocols are enabled.  By default, only “Shared Memory” is enabled, and so you will need to enable TCP-IP and/or Named Pipes (depending on your network configuration).

posted @ Tuesday, May 09, 2006 9:58 AM | Feedback (0)
Post-build event for custom SSIS package component

Requires strong name.

1. "C:\Program Files\Microsoft Visual Studio 8\SDK\v2.0\Bin\gacutil.exe" -u "componentName.dll"

2. copy "$(TargetPath)" "C:\Program Files\Microsoft SQL Server\90\DTS\PipelineComponents" /y

3. "C:\Program Files\Microsoft Visual Studio 8\SDK\v2.0\Bin\gacutil.exe" -i "componentName.dll"


Change paths for other components (depending on the solution, you may or may not need to copy the dll).

posted @ Monday, May 08, 2006 10:40 AM | Feedback (0)